
Guides
Small Museum Collection Management Software Basics
Small museum collection management software supports the unseen work behind a visit. Learn how spreadsheets, open-source catalogs and hosted systems differ.
What to take away
- A spreadsheet is the right answer for one keeper, a few hundred objects, and no public search.
- A free or open-source catalog earns its place once records pass roughly 1,000 items or a second person needs to edit.
- Paid hosted software is the right answer when volunteers rotate, when records go public, or when a museum wants a support line that answers.
- IMLS grant programs can cover software and training, so free versus paid is often a funding question, not a budget one.
- No option, free or paid, repairs inconsistent accession numbers.
Small museum collection management software is only as useful as the filing habits behind it. Most small museums do not outgrow their software; they outgrow those habits.
Why this matters on a small museum side trip
The small, unusual and overlooked museums this site covers often run on one keeper, a borrowed laptop and a box of objects with handwritten tags. That is part of what makes a visit feel close to the collection.
It also means the records behind the labels may be thin, uneven or stored in a spreadsheet nobody else can open. Knowing how a museum tracks its objects changes what you notice. You can ask better questions at the front desk. You can understand why a volunteer cannot always answer on the spot.
The advice below is for the people who run those rooms. For a visitor, it is a look at the invisible work that holds a side trip together.
What actually differs between the options
The difference is not storage space or field count. It is how each tool treats a record. The NPS preservation reformatting guidance concerns choosing a copy technology, not a collection-management standard. A structured catalog can link objects, people and places, while a spreadsheet stores whatever text a typist puts in a cell.
How each tool treats a record
Spreadsheet
- Record model
- Free text in cells
- Multi-user editing
- One at a time
- Audit trail
- None
- Support
- None
- Export quality
- Copy and paste
Free catalog
- Record model
- Linked entries
- Multi-user editing
- Yes, with hosting
- Audit trail
- Limited
- Support
- Community forums
- Export quality
- Varies by project
Paid hosted
- Record model
- Linked entries
- Multi-user editing
- Roles and permissions
- Audit trail
- Yes
- Support
- Vendor help desk
- Export quality
- Varies by contract
Multi-user editing separates the tiers. Free and paid systems both let two people work at once, but paid ones add permissions, audit trails and a support line. A volunteer who overwrites a cell in a spreadsheet leaves no trace.
Then there is the exit. Every system holds data in its own shape. Export quality matters more than the feature list, because a museum's records should outlive the vendor. Ask whether a system can export a usable CSV file and whether linked records remain connected; a clean export today can keep a future migration from eating a season of volunteer hours.
Choosing a catalog repeats a lesson familiar from museum trip planning: a polished demo shows the best case, not the ordinary Tuesday when a donor arrives with a box of objects.
The criteria matrix
Criteria matrix for choosing a catalog
Spreadsheet
- Setup time
- Hours
- Simultaneous editors
- One at a time
- Accession numbering
- Manual, breakable
- Public web search
- Extra work
- Condition and loans
- Free-form notes
- Backups
- Whoever remembers
- Best fit
- Solo keeper
Free or open-source
- Setup time
- Weekend to months
- Simultaneous editors
- Yes, with training
- Accession numbering
- Enforced by tool
- Public web search
- Add-on module
- Condition and loans
- Templated
- Backups
- Depends on host
- Best fit
- Small team going digital
Paid hosted
- Setup time
- Days, data import
- Simultaneous editors
- Yes, with permissions
- Accession numbering
- Enforced, audited
- Public web search
- Usually included
- Condition and loans
- Templated, reminders
- Backups
- Vendor responsibility
- Best fit
- Volunteer-heavy, public-facing
Spreadsheet
- Setup time
- Hours
- Simultaneous editors
- One at a time
- Accession numbering
- Manual and easy to break
- Public web search
- Extra work
- Condition and loan records
- Free-form notes
- Backups
- Whoever remembers
- Support
- None
- Export
- Copy and paste
- Best fit
- Solo keeper
Free or open-source catalog
- Setup time
- A weekend to a few months
- Simultaneous editors
- Yes, with hosting and training
- Accession numbering
- Enforced by the tool
- Public web search
- Add-on module
- Condition and loan records
- Templated
- Backups
- Depends on your host
- Support
- Community forums
- Export
- Varies by project
- Best fit
- Small team going digital
Paid hosted catalog
- Setup time
- Days, mostly data import
- Simultaneous editors
- Yes, with roles and permissions
- Accession numbering
- Enforced, with an audit trail
- Public web search
- Usually included
- Condition and loan records
- Templated, with reminders
- Backups
- Vendor responsibility
- Support
- Vendor help desk
- Export
- Varies by contract
- Best fit
- Volunteer-heavy and public-facing
Where each option is the right answer
A spreadsheet is the right answer for a single keeper with a few hundred objects, no loans and no public search. It starts in an afternoon. The plain facts about museum trip mistakes also hold for catalogs: unplanned hours vanish without a receipt.
Which route fits your museum
Few hundred objects, no loans, no public search?
Spreadsheet
Keep asking
A free or open-source catalog is the right answer for a small team going digital on volunteer labor or a modest grant. Omeka suits online exhibits, while CollectiveAccess and ArchivesSpace handle deeper cataloging. The museum owns the hosting, the updates and the backups.
A paid hosted catalog is the right answer when volunteers rotate each season, when the board wants a support number, or when records are published online. PastPerfect, CatalogIt and Axiell sit in this tier. A museum should treat the subscription as a recurring expense, and lean on the same managing your business finances discipline it applies to insurance.
What every option shares
Every system fails at the same point: it cannot tell whether a record is correct. Accession numbers are assigned by people, and numbering rules drift when keepers change. A row with the wrong number looks exactly like a row with the right one.
Shared limits to plan around
- No system verifies a record is correct
- Accession numbers are assigned by people
- Numbering rules drift when keepers change
- Wrong and right rows look identical
- Migration takes unbudgeted staff hours
- Plan the move before picking the tool
Migration is the other shared limit. Moving records between tools takes staff hours that no vendor refunds. A bad day at the museum costs hours the same way, quietly and without an invoice. A museum should plan the move before it picks the tool.
How to choose between the close calls
- Count objects, editors and public queries before watching any demo.
- List the three reports the museum produces for a board, an insurer or a lender.
- Ask for a full export of a sample dataset, then open the file.
- Check grant deadlines before signing a multi-year agreement.
The same habit of asking early appears in the site's museum booking questions: ask what happens if the company folds, who owns the data, and what a renewal locks in.
Import real data into a trial system, then export it again. If the round trip loses fields, that is the answer.







