Search
Clear search
Close search
Google apps
Main menu
true

Prepare a metadata file

With your media files now uploaded, the next stage is to prepare the metadata associated with it. This will make it possible for users to discover and enjoy your content.

CI  Importing with Google Sheets is highly recommended. It's the simplest and most efficient way to upload your metadata.

Provide Metadata in a Google Sheet

Overview

Providing your item metadata within a Google Sheet is the suggested 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. 

Simple example

Here's a simple example of how metadata for 3 items would look in Google Sheets:

itemid title description creator filetype filespec
p1 George Washington The first president of the United States Sam Jones image george1.jpg
p2 John Adams The second president of the United States Jeff Ross image john1.jpg
p3 Thomas Jefferson The third president of the United States A. Richardson image thomas1.jpg

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 Basic (blank)
Complete (blank)
Examples Basic (filled with sample data)
Complete (filled with sample data)

 

Create your Google Sheet

  1. Choose the template most suitable for your needs, it will open in Google Sheets

  2. Select File > Make a Copy

  3. 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. 

  4. Following the guidelines in the header row of your spreadsheet, complete one row of information for each item you have uploaded

  5. Add additional fields if necessary, by inserting new columns. Your Sheet should only contain one tab

 

 

Your metadata will be saved on a Google Sheets, but you can also download it as a CSV file. In Google Sheets, select File > Download as > Comma Separated Values (.csv, current sheet) to download the metadata or template to your computer as a CSV file.

We strongly recommend using Google Sheets to prepare your metadata.  We also accept the following formats:

CSV     XML     

 

Was this article helpful?
How can we improve it?