Customer Notice
Please note that the option to download bibliographic data directly from this OUP webpage has been replaced with a significantly improved service called DataBank.
As a result of this improvement, files available from this webpage will only continue to be provided until September 30th 2011 at which point the page will be taken down.
The new service, DataBank, offers customers the option to receive data directly from OUP in a variety of forms. DataBank runs queries from OUP's complete UK catalogue of "in print" and forthcoming products available internationally from OUP’s UK distribution centre. This catalogue is updated daily and includes books, CD-Roms, sheet music, and 3rd party products distributed from the UK by OUP under an agency agreement.
DataBank allows customers to refine their data selection by subject, price, availability, format as well as many other criteria. DataBank also allows customers to subscribe to bespoke data feeds at a regularity of their own choosing.
Trade customers wanting to download a full list of OUP bibliographic data, please select one of the links below. There is a feed of In Print Titles and a feed of Not Yet Published Titles. Both feeds are produced on a nightly basis. There is a text version and a zipped version. Please note that in some cases information contained in these downloads is "tentative", and therefore subject to change.
Downloading a file
To save one of the files to your computer, simply click on the link to open the feed and then save to your computer, or save direct from the link, usually by clicking with the right-hand mouse button, and choosing to 'save' or 'save target as'.
In Print Titles (39MB) | In Print Titles (ZIP file) (14MB)
Includes details of all OUP titles that are in print with the following exceptions: gratis items, confidential titles, unconfirmed titles, music hire titles, Oceana looseleaf titles
Not Yet Published Titles (1.7MB)
Includes details of all OUP titles that have not published yet, with the same exceptions as the In Print list above.
Description of contents
1. Format
The feed is a tab-delimited file with a header.
2. Fields
Fields are in the following order:
| FIELD | COMMENT |
| EAN | 13 digit ISBN |
| ISBN | 10 digit ISBN |
| Title | |
| Subtitle | |
| Series | |
| Author | Semi-colon delimited list. Individual authors presented in style "Surname, First name" |
| HIER | OUP Hierarchy |
| PRODT | Product type (from OUP reporting codes) |
| Readership | |
| Short cat copy | Should be under 350 characters |
| Binding | Hardback, Paperback etc... |
| Edition | |
| Price | List price if available, tentative price if not yet published and no list price available |
| Pubdate | Pub date if available, tentative pub date if not yet published and no firm pub date available |
| Illustrations | |
| No. of Pages | |
| Trim Size (mm) | |
| No. of Volumes | |
| OUP rights | Rights include / rights exclude |
| Discount | MPG code |
| Subject | Semi colon delimited list. Code and description separated by "|T" |
| Availability code |
| AB | Pub. Abandoned |
| IP | In Print |
| MD | Manufactured on Demand |
| NP | Not Published |
| NS | Not Sold Separately |
| OF | Other Format available |
| OO | On Order |
| OP | Out of Print |
| OR | Replace - New edition |
| RE | Re-Issue |
| RF | Refer to Supplier |
| RP | Reprinting |
| TO | Only to Order |
| TU | Temporarily Unavailable |
|
| Stock availability flag | "Yes" if stock is in warehouse |
| VAT-rated | Y/N |
| VAT % | % of list price to which VAT must be applied |
How to Open the file in Excel
To open the file in Excel, start Excel and use the File, Open menu items to open the file. It will open a dialogue box to convert the file from the comma-separated format
On the first Text Import Wizard screen, choose file type Delimited:
Press Next.
On the second screen, choose the Tab Delimiter:
Press Next.
On the third screen, make sure that the first two ISBN columns are specified as data format TEXT:
Press Finish.
For all enquiries, please email ac.salessupport.uk@oup.com
