06 · Choosing a method
When a Collection Spreadsheet Is Enough—and When Linked Records Help
A neutral guide to choosing between a spreadsheet and a dedicated collection record system without making compatibility or preservation promises.
3 min read
A spreadsheet is not a bad inventory. For a simple list, it can be portable, familiar, and enough.
It becomes harder to maintain when a single row needs more context than a few cells can hold. Photos and documents may live elsewhere. A single object may have multiple parts, repairs, sources, or related records. Field names may change over time, making it harder to compare older entries with newer ones.
Choose the format you can keep useful
Use a spreadsheet when the record is simple, the people maintaining it understand the columns, and the supporting evidence can be kept consistently. Define each column before entering data. Keep a source date for value-related information. Avoid importing or exporting formulas from an untrusted source without review.
Consider a linked record system when you want an item’s facts, photos, documents, location, and context to remain connected. That does not make one method universally better. The right choice is the one you can understand, maintain, and verify.
Test before depending on a workflow
Whichever method you choose, preserve independent copies of important records and periodically test whether the format still makes sense. Do not assume that a template, import, or migration will be complete until it has been tested with fabricated data that resembles your own workflow.