2021-10-08 ArchivesSpace Trainers Corps “Office Hour”


Oct 8, 2021 – 2-3pm ET (11-12pm PT)

Date: October 8, 2021

Time: 2:00pm ET / 11:00am PT

Topic: Using the Load via Spreadsheet function in ArchivesSpace

Over the next year, the Trainers Corps will offer regularly scheduled trainings and office hours covering a variety of topics on all things ArchivesSpace.  Registration for each training will be separate and registration will open closer to each training date. Information about this training program is available at https://archivesspace.atlassian.net/wiki/spaces/ADC/pages/2331148319

Trainers in attendance:

Jodi Allison-Bunnell, Montana State University

Noah Huffman, Duke University

Miloche Kottman, University of Kansas Libraries

Brittany Newberry, Atlanta University Center

Christine Di Bella, ArchivesSpace

Jessica Crouch, ArchivesSpace

This office hour will not be recorded. Notes from the office hour, including links to shared resources, will be provided below.








Jessica Crouch


How to use the “Load via Spreadsheet” functionality in ArchivesSpace

Brittany Newberry, Atlanta University Center

Brittany demonstrated how to download the load via spreadsheet templates at You can find the templates for load via spreadsheet and all other import templates at https://archivesspace.org/using-archivesspace/migration-tools-and-data-mapping

Brittany demonstrated how to load via spreadsheet via ArchivesSpace. For ArchivesSpace members, there is documentation about using this functionality at https://archivesspace.atlassian.net/wiki/spaces/ArchivesSpaceUserManual/pages/1173913646

Brittany also demonstrated the ability to upload and link container profiles through load via spreadsheet (as of v3.0). Documentation for this is available at https://archivesspace.atlassian.net/wiki/spaces/ArchivesSpaceUserManual/pages/2457075717

You will need to be logged into the Help Center to access Help Center links.

Discussion about the “Load via Spreadsheet” functionality

All trainers

Jodi Allison-Bunnell discussed data cleanup using open refine after uploading 6000 digital objects with links that did not render. She based her work on this documentation on using open refine for clean up https://www.orbiscascade.org/programs/ulc/archives-and-manuscripts-collections/archivesspace/openrefine/



If you would like to use other import templates available at https://archivesspace.org/using-archivesspace/migration-tools-and-data-mapping , these will need to be invoked as background jobs, not through Load Via Spreadsheet.

Keep in mind that they load via spreadsheet archival object template contains LOTS of fields, but it doesn’t contain all fields. Some fields have default settings that you may need to change after the fact. Specifically note label is one field that does not appear.