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 templateFree .xlsx file with filters, status dropdowns and a blank register ready to fill.
A look inside the register
| Work / ID | Location | Sales 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- Save the Inventory tab as CSV UTF-8.Keep the header row. You can also use the sample CSV to try importing fictional works.
- Open Inventory records → Import CSV.Choose your file, check the column mapping and review any skipped rows before saving.
- Add photos when you need them.In the register, use Match photos with files named by inventory ID, such as DEMO-101.jpg.