Excel / spreadsheets → ArchivesSpace
Associated Press Corporate Archives
Ahead of a corporate headquarters move in 2017, the Associated Press Corporate Archives needed intellectual control over some 250 historical artifacts alongside 4,000 linear feet of paper records — data then held in legacy Microsoft Excel spreadsheets. The team assigned unique identifiers and used Office 365 spreadsheets mapped to Dublin Core to establish control, then batch-loaded the cleaned data into ArchivesSpace via its bulk importers, unifying artifacts and paper into format-based record groups. The work also linked images held in the AP's Preservica system. A rare, instructive example of a corporate archive adopting open-source archival management.
Original source
When Archives Have Artifacts: 250+ Objects / 100+ Years of AP History
Society of American Archivists (session notes)
The archived copy opens a snapshot on the Internet Archive's Wayback Machine, preserved for when the original moves or disappears.
The Archive Migration Review summarises this story in its own words and links to the original source for verification. We are editorially independent and not affiliated with the institution or software project named above. Summaries are compiled in good faith from publicly available accounts; corrections are welcome.