The Librarian Portal book catalogue CSV format provides structured information about books, their prices and availability, and, where applicable, your institution's access and usage.
It is designed to help librarians discover, evaluate, compare, and select books. The format is consistent across different book-related downloads in the Librarian Portal, although the books and fields included depend on the download.
This article describes version 2 (v2) of the format.
How the files are organised
Each file contains one row per book. The first row contains the column headings, followed by the book data.
The columns are arranged in three groups:
- Book metadata: Information about the book itself, including its title, ISBN, contributors, collection, and subject classifications.
- Price and availability: The book's list price, currency, and any restrictions or alternative access options.
- Institution-specific information: Where applicable, details of your institution's access and usage of the book.
Book metadata always comes first. Institution-specific columns appear towards the end of the file and are only included when relevant to the download.
Files use UTF-8 CSV, so you can open them in Excel, other spreadsheet applications, or tools that process structured data.
How the format relates to KBART
The format follows the KBART Phase III recommended practice (NISO RP-9-2026) where applicable. KBART helps publishers, libraries, and knowledge base providers exchange consistent information about publications and their availability.
We use KBART-defined names such as publication_title, online_identifier, and monograph_edition, and follow its field ordering where practical. We also add fields for purposes beyond KBART, such as book prices, subject classifications, and institutional usage.
These are catalogue files aligned with KBART, not formal KBART title lists. The Librarian Portal provides separate KBART downloads for holdings and discovery services.
Book metadata fields
| Field | Description |
|---|---|
| publication_title | Full book title, including subtitle when present, separated by : |
| online_identifier | eBook ISBN |
| contributors | Authors and/or editors |
| coverage_depth | Always full, indicating full-text coverage |
| notes | Additional information about the book |
| publication_type | Always monograph |
| content_type | Always text |
| monograph_edition | Edition of the book |
| copyright_year | Copyright year of the book |
| doi | Digital Object Identifier (DOI), without the https://doi.org/ prefix |
| collection_name | Main eBook collection |
The title, identifiers, edition, and other bibliographic fields use standardised naming wherever possible. Other fields extend the standard to support book discovery and acquisition decisions.
SN-T subject classifications
Books are classified using Springer Nature's subject taxonomy, SN-T. Each book can have up to three assigned classifications, and each classification can contain up to five hierarchy levels.
Each assigned classification has two fields: an identifier path and a readable subject path.
| Field | Description |
|---|---|
| sn_t_subject_1_id | Full identifier hierarchy for the first subject |
| sn_t_subject_1_path | Full subject-name hierarchy for the first subject |
| sn_t_subject_2_id | Identifier hierarchy for the second subject, if present |
| sn_t_subject_2_path | Name hierarchy for the second subject, if present |
| sn_t_subject_3_id | Identifier hierarchy for the third subject, if present |
| sn_t_subject_3_path | Name hierarchy for the third subject, if present |
For example:
Subject ID: 2874-2873-2872-6744
Subject path: Life Sciences > Biological Sciences > Agriculture > Agricultural Economics
The identifier path is useful for precise matching and data processing. The subject ID can also be used in book formula search, prefixed with SNT:. The corresponding subject names help you understand, filter, and group books. A book with fewer than three classifications has empty fields for the unused assignments.
Price and availability fields
| Field | Description |
|---|---|
| list_price | Book list price, expressed as an integer |
| currency | Currency code: EUR, GBP, USD, or JPY |
| availability_note | Explanation of restrictions or alternative ways to access a book, where applicable |
The price and currency are separate fields to make it easier to sort, filter, and process prices.
The availability note may explain, for example, that a book is available through SpringerMaterials, that it is Open Access, or that individual licensing is not possible.
An empty availability note means that no relevant restriction or alternative licensing condition is recorded for that book.
Institution-specific access and usage
Some downloads include additional information for your institution. These fields are not present in every file.
| Field | Description |
|---|---|
| institution_has_access | Whether your institution currently has access to the book |
| institution_has_perpetual_access | Whether your institution has perpetual access rights |
| unique_title_requests | COUNTER Unique Title Requests during the reporting period |
| total_item_requests | COUNTER Total Item Requests during the reporting period |
| usage_period_start | Start date of the COUNTER reporting period |
| usage_period_end | End date of the COUNTER reporting period |
The two COUNTER metrics are different:
- Unique Title Requests measures book requests in a way that avoids counting multiple chapter requests from the same book in the same user session as multiple title requests. This is the recommended metric for comparing book usage.
- Total Item Requests sum up the number of chapters of requested books. Books with many chapters will therefore get bigger counts, which is why Unique Title Requests are preferred when comparing book usage.
These figures can help you identify which books your patrons use, particularly when evaluating titles for acquisition.
A value of 0 means no qualifying usage was recorded. An empty value may mean that usage data is unavailable.
Institution-specific exports may also contain fields related to the workflow that generated them.
Working with the files
A few details are worth knowing:
- Column names are stable within a schema version. New versions may add or rename fields, so workflows that rely on column positions should be reviewed when the format changes.
- Different downloads contain different books and optional columns. The same field always has the same meaning wherever it appears.
- Filenames provide context. They identify the export type and schema version, and, where applicable, the institution or agreement. Keep the original filename when storing or sharing an export.
- The files are designed for filtering and analysis. You can use Excel, other spreadsheet applications, or automated tools to combine the bibliographic, classification, price, and usage information.
Our aim is to make book metadata easier to reuse, while keeping the files consistent with established library metadata practices.