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/ISBN | The 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 Phrase | The Title Phrase as uploaded in a Title Phrase batch search only |
Brief record | Brief summary details from the record |
Date of publication | Date of publication, distribution etc. taken from bibliographic record |
Number of holding libraries | The 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 library | The name of the holding library and branch if included in your search |
Total number of holdings | Total number of holdings held by the library or branch |
Format | Document 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 |
---|---|
ISSN | Record standard number, depending on the type of search performed. This row will not be included following a keyword or title phrase search |
Title Phrase | The Title Phrase as uploaded in a Title Phrase batch search only. |
Title | Record Title |
Number of libraries with holdings | The number of libraies which have holdings for that record |
Name of holding library | The 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 |