Art Inventory Spreadsheet Template: What to Track and When to Upgrade

Why artists start with spreadsheets

Spreadsheets feel approachable. They are inexpensive, flexible, and familiar. If you have a small body of work and you are only trying to answer basic questions such as what the piece is called, when it was made, and whether it has sold, a spreadsheet can do the job.

The problem is not that spreadsheets are bad. The problem is that artists often build them in a rush, then discover a year later that they cannot reliably track images, editions, consignments, or documents. A good art inventory spreadsheet solves more than one administrative headache. It becomes the backbone of your records.

If you want a starting point instead of a blank sheet, you can download this free art inventory template and adapt it to your practice.

The essential columns to include

If you are building an art inventory spreadsheet from scratch, start with columns that answer the questions you get asked most often by collectors, galleries, insurers, and your future self.

• Inventory number: Create a unique code for every work, such as2026-001orLC-2026-001.
• Title: Keep the title exactly as you want it to appear in catalogs and on invoices.
• Year: Use a single year or a year range where necessary.
• Medium: Be consistent with phrasing. Do not alternate between short and long versions.
• Dimensions: Include units every time, even if all your work is in the same measurement system.
• Status: Available, sold, on loan, on consignment, reserved, or in exhibition.
• Location: Studio, storage, gallery, collector, or fair booth.
• Price: Record list price and, if sold, final sale price separately.
• Image filename: Even if the actual image lives in a folder, the spreadsheet should point to the correct file.
• Notes: Use this for framing details, condition notes, or edition information.

Useful optional columns

Once the core sheet is stable, add fields that support sales, exhibitions, and documentation. Good optional columns include buyer name, commission split, exhibition history, provenance notes, certificate number, and tags or series names.

The test is simple: if you find yourself digging through email or old messages more than once for the same information, that information probably deserves its own column.

A simple spreadsheet structure that works

Keep one row per artwork. Avoid merged cells, color coding that only makes sense to you, and formulas that are hard to maintain. The more structured the sheet is, the easier it becomes to sort, filter, back up, and eventually import into dedicated software.

A clean header row might look like this:

Breaking dimensions into separate columns can feel tedious, but it pays off later. It makes sorting and importing much easier, and it reduces formatting mistakes.

What spreadsheets do poorly

Spreadsheets work best as structured lists. They start to struggle when your records become visual, document-heavy, or collaborative. That usually happens sooner than artists expect.

• They do not manage multiple artwork images elegantly.
• They make it hard to generate polished PDFs and labels.
• Tracking consignments, exhibitions, and contacts becomes messy across tabs.
• There is no clean collector-facing output like a viewing room or private share link.
• It is easy to break formulas or drift into inconsistent formatting.

None of these issues matter much when you have eight artworks. They matter a lot when you have eighty.

Signs you are ready to upgrade

You do not need to wait until your spreadsheet becomes chaotic. Usually the right time to switch is when administrative work starts competing with studio time.

1. You are regularly sending artwork PDFs to galleries or clients.
2. You want to store more than one image per piece.
3. You need to track editions, COAs, labels, or consignments.
4. You are duplicating the same information across multiple files.
5. You want your records to be usable on your phone as well as your computer.

Dedicated art inventory software should not replace a good record structure. It should preserve that structure while making the visual and administrative parts far easier. If you are at that point, comparing the current art inventory software options is usually a better next step than patching another year onto a spreadsheet that has already outgrown its role.

How to make your spreadsheet migration easier later

Even if you plan to keep using a spreadsheet for now, build it in a way that future you will appreciate. Use one header row, keep dates in a consistent format, avoid burying multiple values in one cell, and standardize status names.

That way, when you decide to import your records into software, you are not first forced into a long cleanup project. Good structure now creates options later. The free template here follows that structure, and Artwork Codex supports CSV import, so a clean spreadsheet today can become a more usable system later without starting from zero.