Provide metadata in a Google Sheet
Overview
Providing your item metadata within a Google Sheet is the recommended format. This ensures your data is stored in a secure and readily accessible location.
Each row will contain all the available metadata you have for a single item. There are some mandatory fields that need to be included to upload items. We also have a number of recommended and optional fields we advise you to populate, if you have that information available.
If you have multiple digitizations for the same item, then you should include these as subitems.
Each item and subitem must be identified by a unique and long lived identifier (ID). Once an item or subitem is assigned an ID, you will be unable to change it.
Templates & Examples
To help get you started, below are templates and prefilled examples of Google Sheets.
Templates |
General CSV |
Art CSV |
Fashion CSV |
Inventions and Discoveries CSV |
Create your Google Sheet
-
Choose the template most suitable for your needs, it will open in Google Sheets
-
Select File > Make a Copy
-
Add a name for your copy and click OK, it will open in a new browser tab. All changes you make in this spreadsheet will be saved automatically to your Google Drive.
-
Following the guidelines in the header row of your spreadsheet, complete one row of information for each item you have uploaded
-
Add additional fields if necessary, by inserting new columns. Your Sheet should only contain one tab