Art inventory spreadsheet for galleries

An art inventory spreadsheet has a simple promise: put the works in one place, then make the list useful whenever a gallery needs it. That can be enough for a young programme, a defined consignment group or a small team that knows every work intimately. The trouble begins when the spreadsheet becomes the place where a gallery records facts but not the context needed to use them.

A row can say that a work is at a fair. It does not automatically explain whether it is available, who asked about it, which document supports the movement or what should happen after the fair closes. The goal is not to make a spreadsheet imitate a full system. It is to build a clean, dependable working record, understand its limits and avoid losing useful information while the gallery grows.

Start with a structure a gallery can maintain

One row per work is the right starting point for most gallery inventory spreadsheets. Give that row a permanent inventory number, then treat the number as the thread that follows the work through a label, condition report, consignment agreement, image folder, shipping document and PDF. Titles can repeat. Works can be retitled. A reliable internal number prevents the gallery from having to guess which “Untitled” is being discussed.

The core fields should help a colleague identify the work without opening another file: artist, title, date, medium, dimensions, edition information where relevant and an image reference. Practical templates from Artopia similarly separate artist, title, medium and dimensions into clear fields, which makes the record easier to sort and export without turning a measurement into an ambiguous sentence.

Then add the fields that answer a busy gallery’s next questions: current location, availability, ownership or consignment context, price policy where appropriate, condition, documents and a brief note of the last meaningful change. Do not begin with every conceivable column. Begin with the facts that would be costly to reconstruct from memory or email.

Keep location and availability separate

Location tells the team where a work is. Availability tells the team what can happen next. They are related, but they are not the same thing. A work can be in storage and ready to offer. A work can be installed in the gallery but reserved. A work at a fair can be on approval, sold, on hold or simply awaiting collection.

Use location values that reflect real places the programme manages: gallery, storage, fair booth, client site, photographer, conservator, courier or in transit. For availability, use a short shared vocabulary. The exact wording matters less than a consistent agreement about what “available”, “reserved”, “on approval”, “on loan” and “sold” require the next colleague to do.

This small separation prevents an easy but expensive mistake: reading a physical location as a commercial instruction. It also makes filters more useful before a viewing or fair, because the team can ask two different questions, “What is here?” and “What can we show?”

Use five fields to prevent most rework

There is no universal gallery template, but five choices make a spreadsheet much easier to trust. They are not glamorous, which is precisely why they deserve agreement before a fair deadline turns them into a problem.

First, keep an inventory number that never changes. Avoid a number based solely on the current location or price. A work may move, be re-priced or return from a consignment. The stable number should remain while the operational facts around it change. Use it in the image filename, document filename and paper label where the gallery has one.

Second, keep dimensions in separate, predictable fields. A short display field can read beautifully in a PDF, but a working sheet benefits from a numeric height, width and depth, plus one unit column. That gives the team a dependable way to check fit, filter works for a presentation and avoid mixing inches and centimetres in the same calculation. Keep the client-facing wording in the presentation document, not in the operational source.

Third, distinguish the record’s current state from its history. The current location and availability should be easy to scan. A separate last-update date and note can hold the immediate explanation. Do not overwrite a prior important event just to make a row look tidy. If a work has changed hands, returned from a fair or received a new condition report, the team will need a way to understand why the row now says what it says.

Fourth, make ownership or consignment context visible. A work that looks available may still carry a different instruction depending on whether the gallery owns it, represents it, holds it on consignment or is handling it for a lender. The sheet does not need to expose every commercial detail to every person. It should make clear that the context exists and point the right colleague to the agreement when a decision depends on it.

Finally, use controlled language for repeatable fields. If one colleague writes “Art Basel”, another writes “Basel 2026” and a third uses “AB”, a filter becomes a guessing game. Keep a small shared list for locations, statuses, artists and document types. This is not about policing vocabulary. It is about ensuring that a busy team can retrieve the same group of works without knowing who entered the data.

These decisions make a spreadsheet calmer to use because they reduce the number of private interpretations hiding inside it. They also make a future import cleaner. A gallery does not need to redesign its working language when it moves to a more connected system, it can carry forward the names and records it has already learned to trust.

A simple test is to filter the sheet for a real task before calling it complete. Find every work available for a particular fair, every item currently off-site, or every work missing a current image. If the result needs manual decoding, split the field, tighten the shared language or remove an old workaround. A useful spreadsheet should answer ordinary questions quickly enough that the team uses it before opening an inbox.

Link the row to the evidence behind it

A spreadsheet is not a document archive, and it does not need to be. It does need a consistent way to point to the evidence that supports each row. Use the inventory number in the names of image files and folders. Keep a document column that identifies the relevant condition report, certificate, consignment agreement or shipping form. Where the team uses a shared drive, use a stable link rather than a personal desktop path.

This is especially important for images. An image named only “IMG_3021” becomes an archaeological problem after a folder is sorted or copied. A filename built around the inventory number gives the work and its images a common reference. The Joan Mitchell Foundation’s career-documentation guide likewise recommends recording key identifiers and maintaining photographs as part of an inventory practice.

Record the last meaningful change in plain language. “Moved to Frieze booth, condition report updated, hold pending” is more useful than a cell filled with a date alone. It preserves the reason a row changed without attempting to turn every spreadsheet cell into an inbox.

Build an update routine around real moments

The spreadsheet is only as current as its last handover. A quarterly clean-up can help, but it should not be the only time records are touched. The most dependable approach is to update the sheet at the moments when the work’s practical story changes.

1. At intake: assign the inventory number, confirm the core details, attach the right image reference, note condition and set the first location.
2. Before a viewing or fair: check location, availability, price context, images and any restrictions before the work enters a list or PDF.
3. At movement: update the location and availability when custody changes, then note the document or reason that supports it.
4. After an event: reconcile returns, holds, sales, documents and next actions while the conversations are still clear.
5. At a short review: compare a defined group of works with the record, resolve exceptions and improve the habit that allowed the gap.

A spreadsheet is often strongest when it is deliberately modest. A team is more likely to record a dependable location and status at the handover than to complete twenty optional fields later. The first protects the next decision. The rest can be added where it genuinely helps.

Use simple checks to catch quiet gaps

Choose a review scope that matches the programme: works returning from a fair, a storage bay, an exhibition changeover or a consignment group. Take the current sheet, then verify the physical work against its location, status, image reference and supporting documents. The point is not to produce a ceremonial annual count. It is to catch the small discrepancies while someone can still explain them.

When a row does not match reality, correct the record and ask what made the gap likely. Was the work moved before the sheet was updated? Did a condition report remain in email? Was “reserved” interpreted differently by two people? The repair belongs in the row. The lesson belongs in the shared routine.

Recognise the point where a sheet is no longer enough

There is no shame in using a spreadsheet. It is portable, familiar and often exactly right for a small, stable group of works. Its limit is not a fixed number of rows. The limit arrives when a gallery regularly needs to reconcile the spreadsheet with a second list, email, folders, fair notes and someone’s memory before it can answer a normal question.

That usually happens when several people update records, works move frequently, documents matter to daily decisions, or a work needs to stay connected to collectors, fairs, proposals and follow-up. At that point, the issue is not spreadsheet skill. It is that the relationships around a work are being maintained in several places.

The earlier guide to art gallery inventory management explains the wider operational record, while the guide to managing art collections shows why location, documents and history must remain legible during a handover. Together, they make a useful test: can a new colleague answer the gallery’s next question without rebuilding the story?