Why Your Gallery Spreadsheet Will Eventually Betray You

Every gallery owner we talk to has a spreadsheet horror story.

The one where the consignment agreement was in column AD and nobody updated it when the artist took the work back. The one where two staff members edited the same row at the same time and the client got invoiced twice. The one where the “DO NOT TOUCH” row turned out to be the formula everyone else depended on, and when someone touched it the whole sheet broke silently, and nobody noticed for six weeks.

Spreadsheets are remarkable tools. They are flexible, portable, and universally understood. For a gallery that has forty works in inventory and one person running everything, a spreadsheet is fine. For a gallery that has four hundred works, three staff members, multiple locations, active consignments, an online shop, and quarterly exhibitions — a spreadsheet is a liability.

What a spreadsheet cannot do

A spreadsheet stores data. It does not model relationships. When you record a consignment in a spreadsheet, you are making a note. When you record a consignment in a proper inventory system, you are creating a transaction that links the artist, the artwork, the terms, the dates, and the expected return — and all of those relationships remain queryable forever.

A spreadsheet does not have a transaction log. If someone changes the price of a work, the old price is gone. If someone marks a work as sold and then un-marks it, there is no record that the sale was ever attempted. A proper inventory system records every state change. “Sold, then returned” is different from “never sold.” The difference matters for insurance, for consignment accounting, and for the artist’s exhibition history.

A spreadsheet cannot enforce rules. There is nothing stopping someone from marking a work as sold and consigned simultaneously, or entering a price of $0 for a work worth $45,000, or misspelling an artist’s name seventeen different ways across two hundred rows. A proper system has validation. It knows that a work cannot be in two places at once. It normalises artist names. It checks that consignment terms have been signed before allowing a work to be offered for sale.

A spreadsheet does not integrate. When you sell a work, you then open your invoicing tool and re-enter the details. You open your email client and write the confirmation. You update your website manually. You update your consignment report for the artist manually. A proper system does all of this from a single transaction.

What changes when you move off spreadsheets

The first thing gallery owners notice is not the features. It is the cognitive load.

When your inventory is in a spreadsheet, you are always slightly anxious about the spreadsheet. Is it backed up? Did someone break the formula? Is the version in Dropbox the right one? Is the offline copy on your laptop more current than the cloud copy? This anxiety is subtle but constant.

When your inventory is in a proper system, you stop thinking about the container and start thinking about the contents. The works. The artists. The collectors. The exhibitions. That is where your attention should be.

The second thing gallery owners notice is that data they did not know they wanted starts becoming available. When was this work last on public display? How long has it been in storage? Which collector has bought more than one work by this artist? What is the average time between consignment and sale for works in this price range? None of these questions are answerable from a spreadsheet without a significant manual effort. From a proper inventory system, they are instant.

The migration is easier than you think

The hardest part of migrating from a spreadsheet is not the technical work. It is the psychological work of admitting that the spreadsheet is not good enough. Once you have admitted that, the migration itself is mechanical.

You export your spreadsheet to CSV. You map your columns to the new system’s fields. You import. The system flags duplicates and formatting inconsistencies. You resolve them. You are done.

At Galexivo, we do this for you. Send us your spreadsheet, however messy it is, and we will migrate your inventory, normalise your artist names, and have your gallery running within 24 hours. We have migrated galleries with twelve works and galleries with twelve hundred. The process is the same.

The spreadsheet that has served you faithfully for five years will not be offended if you retire it.