Test Your Metadata

This page can temporarily configure the metadata used on the site to test your CollectionBuilder spreadsheet. The configurations are stored in your browser’s session storage, so will remain only until you close this window!

The currently configured metadata is:

To keep the currently configured metadata, simply navigate to another page! To change the metadata you have two options: select a CSV file from your computer or paste in the full link for a CSV hosted online (such as a published Google Sheet).

Metadata Requirements

Set up your metadata carefully following the template. Be especially careful with column names in the first row–they need to exactly match the template, with no spaces and no extra white space at the end of the value. Records without an “objectid” will be skipped.

Note: no information is sent to the server, the metadata and configuration change is only on your computer.

How to Publish Your Google Sheet

• On your Google Sheet, click “File” and select “Publish to the Web”.
• On the popup modal, use the dropdowns in “Link” tab to select the sheet name of your metadata (usually “Sheet 1”) and “Comma-separated values (.csv)” options, then click “Publish” button.
• Copy the link that is provided.
• Paste the link into form above and click Submit.

For example, a published link looks like:

https://docs.google.com/spreadsheets/d/e/2PACX-1vSn7AA-cbsXT3_nNUGftc1ab-CKXOJHMQCIENeR9NHElbyI9_qA99o0-HNZdG04v-M2_N21bUe_krQQ/pub?gid=0&single=true&output=csv

How to Download Your Google Sheet as CSV

• On your Google Sheet, click “File” and select “Download as Comma-separated values”
• The file should download to your computer’s Downloads folder
• Click in the “Choose file” box in the form above and navigate in your file explorer to select the downloaded CSV.