Skip to main content
OCLC Support

Data requirements for non-MARC patterned data collections

Data requirements for non-MARC patterned bibliographic data

  • Data must be sent as a .CSV file, encoded as UTF-8, with additional data to create MARC records for processing.
  • Download the Non-MARC patterned data template.
    • The order and format of the columns in the template should not be changed.
    • Red headings denote required fields.
    • Italicized column headings denote the ability for OCLC to create repeatable fields. Separate each entry in these columns with a semi-colon to trigger separate entries.
    • Save the template by encoding it as UTF-8.

Data requirements for non-MARC patterned local holdings records data

  • Data must be sent as a .CSV file encoded as UTF-8.
  • Download the Non-MARC patterned data template.
    • The order and format of the columns in the template should not be changed.
    • Red headings denote required fields.
    • Italicized column headings denote the ability for OCLC to create repeatable fields. Separate each entry in these columns with a semi-colon to trigger separate entries.
    • Save the template by encoding it as UTF-8.

Encode a .CSV Excel file to UTF-8

 Note: UTF-8 encoding a .CSV in Excel is not available for Mac.

  1. Click the File tab.
  2. Click Save As.
  3. Enter your file name and update your file path as needed.
  4. Select CSV (Comma delimited) from the Save as type drop-down list.
  5. Click Tools, then select Web Options from the drop-down list.
  6. Click the Encoding tab.
  7. Select Unicode (UTF-8) from the Save this document as drop-down list.
  8. Click OK.
  9. Click Save.