A Learn-Static Template
The table below provides sorting and basic search of the collection contents. Use the “CSV” or “Excel” button below to download the filtered metadata you see on the page in your preferred format.
| Title | Date | Description | Subjects | Link |
|---|
Welcome to CollectionBuilder-Sheets!
Using the options below you can select demo metadata to explore a pre-built collection, or load your own metadata from the web or your local computer. The configurations are temporarily stored in your browser's session storage, so will remain only until you close this window!
Select one of our example collections
Paste in the full url for a CSV hosted online, such as a published Google Sheet (see below for instructions!)
Select a CSV file from your computer
Set up your metadata carefully following the template guidelines. 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.
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?output=csv
If you have a CSV available anywhere on the web, you can use it by referencing the full URL. However, depending on where your CSV is hosted, you may encounter CORS errors.
For example, to use a CSV hosted in a GitHub repository, use the “raw” link:
https://raw.githubusercontent.com/CollectionBuilder/collectionbuilder-sample-data/main/psychiana_cbdemo_gh.csv
Paste the link into the "Use Metadata CSV Link" form above and click Submit.
To share your work with others, the default template can also load web CSV metadata specified as a parameter in the URL. Add your full metadata link to the end of the CB-Sheets instance’s URL as the “csv” option, like:
https://collectionbuilder.github.io/collectionbuilder-sheets/?csv=<your metadata url here>
For example:
https://collectionbuilder.github.io/collectionbuilder-sheets/?csv=https://raw.githubusercontent.com/CollectionBuilder/collectionbuilder-sample-data/main/psychiana_cbdemo_gh.csv
or
https://collectionbuilder.github.io/collectionbuilder-sheets/?csv=https://docs.google.com/spreadsheets/d/e/2PACX-1vSn7AA-cbsXT3_nNUGftc1ab-CKXOJHMQCIENeR9NHElbyI9_qA99o0-HNZdG04v-M2_N21bUe_krQQ/pub?output=csv
Note: the metadata URL can not have any & (i.e. additional query string parameters).
Having a & in the URL will cause the parsing to fail.