Artwork catalogue template: every column with an example
You want to keep your artwork catalogue in a spreadsheet and are looking for the right columns. You can copy the header row below and paste it into Excel, Numbers or LibreOffice. Why these details make sense is shown in the guide How to start an artwork catalogue.
The columns
Columns 1 to 11 describe the work and its sale status. Columns 12 to 16 add the type of work and everything that helps to recognise the work and document its history. A column that does not apply to a work stays empty.
| No. | Column | What goes in | Example |
|---|---|---|---|
| 1 | Inventory number | your fixed number for the work, see Numbering your works: a system that lasts | 2026-0014 |
| 2 | Filename | the name of the photo file, spelled exactly | 2026-0014_front.jpg |
| 3 | Title | the title as it should appear on labels | Untitled (Blue) |
| 4 | Year | the year the work was made, or "c. 2010" if unsure | 2026 |
| 5 | Medium | materials and technique | Oil on canvas |
| 6 | Dimensions | height × width × depth with unit | 120 × 100 cm |
| 7 | Edition | for prints and casts made in several copies: which copy of how many | 3/20 |
| 8 | Series | the name of the group of works | Colour spaces |
| 9 | Sale status | available, sold, reserved, on loan or not for sale | available |
| 10 | Price | the price you would ask today, as a plain number | 4800 |
| 11 | Location | where the work is right now | Studio, shelf 3 |
| 12 | Type of work | what kind of work it is | Painting |
| 13 | Signature and inscriptions | what is written on the work, and where | signed, dated and inscribed 2026-0014 on the back |
| 14 | Distinguishing features | marks that identify exactly this work, plus part numbers and notes such as "destroyed 2023" | small scratch at lower left |
| 15 | Exhibitions | where the work was shown, with year | Gallery Example 2026 |
| 16 | Provenance and whereabouts | who received or returned the work, and when, see Documenting provenance: proving the history of a work | 2026-05-04 consigned to Gallery Example | 2026-09-02 returned from consignment |
"On consignment" means that a gallery sells the work for you, but the work remains yours until it is sold. More on this in Gallery contracts: commission, duties, term.
Columns 13 and 14 come from the museum standard Object ID (source 1). They help you recognise a work for certain years later, for example after a theft or when someone doubts its authenticity.
Header row to copy
Select the row, copy it and paste it into the first cell of an empty spreadsheet. The columns are separated by tabs, so each heading lands in its own column.
Inventory number Filename Title Year Medium Dimensions Edition Series Sale status Price Location Type of work Signature and inscriptions Distinguishing features Exhibitions Provenance and whereabouts
One row as an example
2026-0014 2026-0014_front.jpg Untitled (Blue) 2026 Oil on canvas 120 × 100 cm Colour spaces available 4800 Studio, shelf 3 Painting signed, dated and inscribed 2026-0014 on the back small scratch at lower left Gallery Example 2026 2026-05-04 consigned to Gallery Example | 2026-09-02 returned from consignment
Empty fields simply stay empty, like the edition here. Never write "n/a" or a dash, because later that looks like a real entry.
Eight writing rules
- Anything that could be sold or lent on its own gets its own row. A work in three parts gets one row, with the part numbers .1 to .3 in the "distinguishing features" column. Each print of an edition gets its own row.
- Dimensions always follow the same order, height before width before depth, and always with a unit.
- Prices are plain numbers, without currency sign or thousands separator. That way the spreadsheet can calculate with them.
- Dates are written year-month-day, as in the example in column 16. That way dates sort correctly in any spreadsheet.
- The sale status uses fixed words. Always use one of the five words from the table above, never "gone" or "with Anna".
- File names start with the inventory number. Then every photo leads to its work, and every work to its photos.
- Exhibitions are written with place and year, several of them separated by a vertical bar. Separate the entries in column 16 the same way, oldest first.
- Nothing is deleted. A sold work stays in the spreadsheet, and only the sale status changes. A destroyed work stays as well, with "destroyed" and the year in the "distinguishing features" column.
Keeping the spreadsheet safe
Once a month, also save the spreadsheet as a CSV file. CSV is a simple text format for tables that any program can open, even in twenty years. Keep a copy in a second place, for example on a USB stick outside the studio.
From the template to Kolopheo
When you save your spreadsheet as CSV and import it under Works, Kolopheo recognises most of the headings in columns 2 to 11 by itself. In the preview, you can assign any column by hand. You also see what will change and choose which rows to import. A file can have up to 5,000 rows.

Two things are worth knowing. Kolopheo does not import columns 12 to 16 today, so they stay in your spreadsheet. And the inventory number from column 1 is only used to match rows to works. Kolopheo assigns its own inventory number, as described on the page Numbering your works: a system that lasts. Step-by-step instructions are in Moving from an Excel or PDF list to Kolopheo.
Sources
- ICOM, "Object ID", standard for describing cultural objects, retrieved 17 October 2026: https://icom.museum/en/resources/standards-guidelines/objectid/