Free art inventory template for small galleries.

Use this art inventory spreadsheet to track where each work is, who owns or consigned it, and whether it’s available for sale.

Download Excel template

Free .xlsx file with filters, status dropdowns and a blank register ready to fill.

A look inside the register

Work / IDLocationSales status
Quiet Forms DEMO-101 Main gallery Wall 2 · At gallery Available
Evening Study DEMO-102 West Annex Room 1 · On loan Not for sale

From the workbook’s Fictional examples tab.

What to record for each work

Inventory ID, title and artist
Give each work a unique ID and keep it when the work moves. Include the title and artist on every row.
Location and physical custody
Write a location someone else can find, such as “Storage · Rack B”. Use At gallery, On loan or Returned to owner to record who physically holds it.
Owner or consignor
Record the name your gallery uses to identify the owner or consignor. Include it even when it’s the same as the artist.
Sales status
Use Available, Reserved, Sold or Not for sale. Update it separately from custody. A sold work can still be at the gallery awaiting pickup.
Year, medium, dimensions and price
Add these when known. Include the measurement unit and make the currency clear.
Notes
Keep practical details such as edition, frame condition or pickup arrangements in this column.

Import the spreadsheet into Atelier Ledger

Use Atelier Ledger for day-to-day art inventory management. Search by artwork ID and filter by sales status or location. The free beta saves records in this browser. Download a full JSON backup to keep a copy.

Open the free beta

Download sample CSV for import

  1. Save the Inventory tab as CSV UTF-8.Keep the header row. You can also use the sample CSV to try importing fictional works.
  2. Open Inventory records → Import CSV.Choose your file, check the column mapping and review any skipped rows before saving.
  3. Add photos when you need them.In the register, use Match photos with files named by inventory ID, such as DEMO-101.jpg.