Skip to main content
OCLC Support

Use Tab-delimited text files

Learn how to create a tab-delimited text file, enter dates in a tab-delimited text file, and use Microsoft Excel to create tab-delimited text files.

Tab-delimited text files are an easy way to import metadata for multiple files. Use tab-delimited text files to import:

  • Metadata into a specific field
  • Multiple files
  • Single compound object
  • Multiple compound objects

Creating a Tab-delimited Text File

Regardless of how you use a tab-delimited file, follow these guidelines:

  • One field must contain the file name of the items.
  • For best results, place the field that contains the file names of the imported files as the last field in your tab-delimited text file.
  • All collection metadata field names must appear in the first record of the tab-delimited text file.
  • The file names must exactly match the contents of the upload directory for the files. One single mismatch causes the entire upload to fail.
  • Use a tab for the delimiting character.
  • End each record with a carriage return.
  • Do not use carriage returns or tabs within a field.
  • The end of the document should be the very end of the last word in the last line, with no extra blank lines or spaces.
  • Remove special characters from file names and collection metadata field names. Special characters are: \ / : * ? " < > |
  • When entering file names, enter only the file name of the item, such as item.jpg. Do not enter full path names such as c:\windows\item.jpg.
  • When entering file names, be sure to include the extension, even if your operating system hides the extension type. Common extension types are JPG, TIF, GIF, and PDF.
  • When importing files, use unique file names for each item. Using capital letters in the file name does not make the file name unique. The file name item.jpg is treated the same as ITEM.jpg and ITEM.JPG.
  • Field name mapping need not be 1:1. Multiple tab-delimited fields may map to a single CONTENTdm collection field or you might have fewer fields in your tab-delimited file than in your CONTENTdm collection.
  • One or more fields must map to the Title field of your collection.
  • Store all of your items referred to in the tab-delimited file in one directory.

Entering Dates in a Tab-delimited Text File

If importing dates to a Date data type field, they must be valid dates in the following supported formats:

Supported formats Format Example
Supported Formats yyyy-mm-dd
Supported delimiters between dates Comma (,) and
semicolon (;)
2008, 2009
2008; 2009
Supported delimiter in date range Hyphen (-) 2008-2009
Leading spaces are okay but not required when using multiple dates YYYY; YYYY; YYYY
2007; 2008; 2009

After dates are added to the project spreadsheet, they will be displayed in a yyyy-mm-dd format.

Using Microsoft Excel to Create Tab-delimited Text Files

In addition to the general guidelines highlighted above, there are specific guidelines for creating tab-delimited text files using Microsoft Excel:

  • Turn off the text wrap option before saving as a tab-delimited text file. Using the text wrap option sometimes places a special character at the end of the line, which then causes the import to fail.
  • For cleanest metadata, replace quotation marks within fields with apostrophes. Otherwise, when the spreadsheet is converted to a text file, another set of quotation marks is added next to the quotation marks. For example, if you have a field in Excel that contains the following:

Frank "Ol' Blue Eyes" Sinatra

Once the file is saved as a text file, the tab-delimited text file will read:

"Frank ""Ol' Blue Eyes"" Sinatra" unless you change the quotation marks to apostrophes.

See Troubleshoot tab-delimited text files for help resolving problems.