Understanding the Librarian Portal book catalogue CSV format, version 2 (v2)

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:

  1. Book metadata: Information about the book itself, including its title, ISBN, contributors, collection, and subject classifications.
  2. Price and availability: The book's list price, currency, and any restrictions or alternative access options.
  3. 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_titleFull book title, including subtitle when present, separated by :
online_identifiereBook ISBN
contributorsAuthors and/or editors
coverage_depthAlways full, indicating full-text coverage
notesAdditional information about the book
publication_typeAlways monograph
content_typeAlways text
monograph_editionEdition of the book
copyright_yearCopyright year of the book
doiDigital Object Identifier (DOI), without the https://doi.org/ prefix
collection_nameMain 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_idFull identifier hierarchy for the first subject
sn_t_subject_1_pathFull subject-name hierarchy for the first subject
sn_t_subject_2_idIdentifier hierarchy for the second subject, if present
sn_t_subject_2_pathName hierarchy for the second subject, if present
sn_t_subject_3_idIdentifier hierarchy for the third subject, if present
sn_t_subject_3_pathName 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_priceBook list price, expressed as an integer
currencyCurrency code: EUR, GBP, USD, or JPY
availability_noteExplanation 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_accessWhether your institution currently has access to the book
institution_has_perpetual_accessWhether your institution has perpetual access rights
unique_title_requestsCOUNTER Unique Title Requests during the reporting period
total_item_requestsCOUNTER Total Item Requests during the reporting period
usage_period_startStart date of the COUNTER reporting period
usage_period_endEnd 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.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.