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
