Excel and specific field types [Tiers 2-3]

You can use an Excel spreadsheet to update existing items or to add new items to your project. The first step in this process is to generate an Excel template so that your values match the project fields. For items that utilize List or Linked Authority field types, there are certain methods to formatting your data so that the terms are added or edited successfully. We recommend using .xls filetype for Excel.

Excel and Linked Authority fields

When cataloging values in a Linked Authority field, integrated Getty vocabularies are available for direct linking via an Excel spreadsheet using specific formatting practices. When formatting the linked authority data, enter the value as you would like it to display, followed by the source authority’s initials and the reference ID in double brackets.

To find the reference ID for vocabularies, search for local names or Getty’s website to find authoritative vocabularies. External resources cannot receive imported reference IDs, only terms.

Formatted examples:

• Shared Shelf Names, or SSN*
  • Puryear, Martin [[SSN 500009936]]
• Thesaurus of Geographic Names, or TGN
  • Seattle, Washington [[TGN 7014494]]
• Art and Architecture Thesaurus terms, or AAT
  • sculpture; public art; plazas [[AAT 300047090][AAT 300056501][AAT 300008214]]

Shared Shelf Names (SSN) builds from the Getty ULAN (Union List of Artist Names) and for most purposes, the two can be considered synonymous.

Excel and List fields

For List fields, you can import terms both when importing new items and when updating existing records with your Excel spreadsheet. There are two available options for importing list terms, the first has been simplified for strictly List fields that link to a local list. The second is for Linked Authority fields that link to a list, which requires additional formatting and can only be performed for NEW records.

To import list terms to a List field

• Enter a single term in the cell as you normally would.
• For multiple terms, separate with a vertical bar or pipe (|) symbol. For example: tomato|banana

To import list terms to a Linked Authority field

This process applies the same formatting as Linked Authority fields, enter the display information followed by double brackets containing LIST and the term ID. The term ID can be found in the Manage Lists page, where you can select the list and search or browse for the term. For example, tomato’s term ID is 100 and banana’s is 101 so the Excel value would be tomato|banana [[LIST 100][LIST 101]]

Since a Linked Authority field can be connected to both lists and integrated Getty authorities, the chart below presents different scenarios and how they would be formatted. For this scenario your list has two terms:

• tomato[200]
• banana[201]

If your project has a value that exists in two different lists, similar to the above ‘tomato’ example, you must use the LIST ID, instead of the term ID, so the value is linked to one of the available lists. Otherwise, the import will fail.

Important notes:

• You will be unable to add new list values when importing your items. If you attempt to import new values, you will see an error message.
• If you attempt the Excel import with values that are mixed valid and invalid values, the Excel import will fail.

Excel and Boolean checkbox fields

Excel import requires the values for Boolean fields to be all caps, (i.e. TRUE and FALSE). When editing an exported spreadsheet in Excel, the column formatting will default to capitalized text for this field.

Excel and Date fields

For Date field types in your project, format the Excel data as MM/DD/YYYY as either a date or custom cell format. This will import into your date field and display as YYYY-MM-DD.

Excel and Linked Work fields

Importing values with decimals

Use a Text Field or Text Area type if you need to input any values with decimals such as geographic coordinates. In order for the system to recognize the decimal point upon import, you need to add an apostrophe before the value in Excel.

For example, if your geographic coordinate is 35.9940, then the Excel value would display as ‘35.9940. If you do not add an apostrophe, then anything after the decimal will be truncated after importing. Use .xls as the filetype when creating your import spreadsheet.