a book, read, literature, to learn, book pages, writing, favorite book, mood, light, light shadow, to study, books, writing, writing, writing, writing, writing, books, books, books. Small Museum Collection Management Software Basics
Photo by congerdesign on Pixabay

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?

Yes

Spreadsheet

No

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

  1. Count objects, editors and public queries before watching any demo.
  2. List the three reports the museum produces for a board, an insurer or a lender.
  3. Ask for a full export of a sample dataset, then open the file.
  4. 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.

Common questions

Does a small museum need collection management software at all?
No, not always. A single keeper with a few hundred objects can run a clean spreadsheet for years, provided the numbering rules are written down.
What does free software demand from a small museum?
Hosting, backups, updates and training. Free tools replace a license line with staff time and a server.
Can grants pay for software?
IMLS runs museum grant programs that fund collections stewardship and the technology behind it. Museums for America (MFA) is one named program. Eligibility and categories change, so read the current notice of funding opportunity before you plan.
When should a small museum switch?
When two people edit the same records, when the public needs to search, or when a numbering error has gone unnoticed for a season.

More in Guides

Latest from Collections Desk