Why Spreadsheets Fail at Edition Tracking
Galleries have relied on spreadsheets to track editions for decades. But as catalogs grow and staff changes, the cracks in this approach become impossible to ignore.
Every gallery starts the same way. A new sculpture series launches with eight editions, and someone opens a spreadsheet. Columns for edition number, status, collector name, sale date, maybe a note about the foundry. It works fine for the first few months.
Then the problems begin.
Version control is a myth
The spreadsheet gets emailed between the director, the registrar, and the sales team. Someone updates their copy but forgets to share it. Another person overwrites a cell by accident. Within a year, nobody is entirely sure which version is correct. Was Edition 3/8 sold to the Hendersons or the Petersons? The answer depends on which laptop you open.
This is not a minor inconvenience. When a collector calls to ask about the provenance of their piece, or when a secondary sale requires documentation, the gallery needs a single authoritative record. A spreadsheet that exists in multiple conflicting versions is worse than no record at all, because it creates false confidence.
No audit trail
When a cell changes in a spreadsheet, the previous value vanishes. There is no record of who changed it, when, or why. For artwork records — where provenance and chain of custody are the foundation of value — this is a fundamental flaw.
Consider what happens when an edition is reassigned from one collector to another. In a spreadsheet, someone simply types over the old name. The previous assignment is gone. If a dispute arises later, there is nothing to reference.
A proper edition registry maintains an append-only history. Every change is recorded with a timestamp, the user who made it, and the reason. The old data is never destroyed — it becomes part of the permanent record.
Certificates live somewhere else
Spreadsheets track data, but they do not generate documents. Certificates of authenticity are typically created in a separate design tool, stored in a different folder, and linked to the spreadsheet record only in someone's memory. When that person leaves, the connection is lost.
The same applies to condition reports, installation instructions, and production photos. All of these are part of the edition record, but a spreadsheet has no way to attach them. Over time, the physical files scatter across drives, email threads, and filing cabinets.
Production tracking is invisible
For galleries that work with foundries or print studios, production is a critical part of the edition lifecycle. When is the wax complete? When does patina begin? When will the piece ship?
These questions get answered over phone calls, text messages, and emails. The spreadsheet might have a column called "Status" that says "In Production." But it reveals nothing about where the piece actually is, what milestone was just completed, or whether there are photos to share with the waiting collector.
The real cost
The cost of spreadsheet-based edition tracking is not measured in software fees. It is measured in lost records, embarrassing errors, and weakened collector relationships. When a gallery cannot confidently answer "What edition do I own?" the trust that underpins the entire relationship begins to erode.
The art world has moved past handwritten ledgers. It is time to move past spreadsheets too.