Exporting data

Data from your results set can be exported. Export options are displayed at the bottom of the search results list, at the bottom of each individual record, and at the bottom of each visualisation available in the Graphs tab. Exports are provided in .csv format, which can be saved or opened in an Excel spreadsheet or other software as required.

Note: Export options are available for standard search results of up to 5000 records and for batch search results of up to 250,000 records. If export is unavailable it will be greyed out. If your search returns more than 5000 results and you would like to use the export option, try running it as a batch search.

Choose the export format required and then click the ‘Export’ button. Depending on the browser you are using and your local settings, the .csv file will either be saved to your downloads folder automatically, or you will be prompted to save it.

Item holdings data

The item holdings data option will export a file containing the following fields from your search results:

Column name Definition
ISSN/ISBNThe relevant standard number, depending on the type of search you performed. This column will not be included if you ran a keyword or title phrase search
Title PhraseThe Title Phrase as uploaded in a Title Phrase batch search only
Brief recordBrief summary details from the record
Date of publicationDate of publication, distribution etc. taken from bibliographic record
Number of holding librariesThe number of libraries which have holdings for that record
Name of holding libraries and format(s)The names of each holding library and the document format(s) of the library holdings along with any UKRR flag

If you limited your original search by library or region, you will see two different options in the Export dropdown menu:

Item holdings data.csv (selected libraries)
This export will include holdings information only for the libraries specified in your search
Item holdings data.csv (all libraries)
This export will include holdings information for all libraries

Note: any standard numbers in the exported data will be contained within single quotes eg:'0071317945'; this ensures any spreadsheet software you use treats them as text. If a spreadsheet identifies ISBNs, ISSNs etc as numbers then we have found that it will strip any leading zeros, meaning that they will no longer be valid.

Library holdings data

The library holdings data option will export a file containing the following fields from your search results:

Column name Definition
Name of holding libraryThe name of the holding library and branch if included in your search
Total number of holdingsTotal number of holdings held by the library or branch
FormatDocument format(s) of the library holdings along with any UKRR flag

The file will be in a .csv format with a file name [search result reference].libraryholdings.csv. This can be saved or opened in an Excel spreadsheet or other software as required.

If you limited your original search by library or region, you can export library holdings data only for your specified libraries by choosing Library holdings data.csv (selected libraries/groups/regions).

The file will be in .csv format with the file name [search result reference].[library/group/region name].libraryholdings.csv. This can be saved or opened in an Excel spreadsheet or other software as required.

OR you can include the details of all the libraries who hold the items returned in your search by choosing Library holdings data.csv (all libraries).

Note: any standard numbers in the export data will be contained within single quotes eg:'0071317945'; this ensures any spreadsheet software you use treats them as text. If a spreadsheet identifies ISBNs, record numbers etc as numbers then we have found that it will strip any leading zero's and they will no longer be valid.

UKRR checking

This is an export format provided for the British Library UK Research Reserve team, to enable checking of UK journal holdings as part of the UKRR service. You can find out more about the service on the British Library UKRR website.

Row name Definition
ISSNRecord standard number, depending on the type of search performed. This row will not be included following a keyword or title phrase search
Title PhraseThe Title Phrase as uploaded in a Title Phrase batch search only.
TitleRecord Title
Number of libraries with holdingsThe number of libraies which have holdings for that record
Name of holding libraryThe name of the holding libray and branch if included in the search
Format(s)Document format(s) of the library holdings along with any UKRR flag