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.

Updated 17 October 2026.

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.ColumnWhat goes inExample
1Inventory numberyour fixed number for the work, see Numbering your works: a system that lasts2026-0014
2Filenamethe name of the photo file, spelled exactly2026-0014_front.jpg
3Titlethe title as it should appear on labelsUntitled (Blue)
4Yearthe year the work was made, or "c. 2010" if unsure2026
5Mediummaterials and techniqueOil on canvas
6Dimensionsheight × width × depth with unit120 × 100 cm
7Editionfor prints and casts made in several copies: which copy of how many3/20
8Seriesthe name of the group of worksColour spaces
9Sale statusavailable, sold, reserved, on loan or not for saleavailable
10Pricethe price you would ask today, as a plain number4800
11Locationwhere the work is right nowStudio, shelf 3
12Type of workwhat kind of work it isPainting
13Signature and inscriptionswhat is written on the work, and wheresigned, dated and inscribed 2026-0014 on the back
14Distinguishing featuresmarks that identify exactly this work, plus part numbers and notes such as "destroyed 2023"small scratch at lower left
15Exhibitionswhere the work was shown, with yearGallery Example 2026
16Provenance and whereaboutswho received or returned the work, and when, see Documenting provenance: proving the history of a work2026-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

  1. 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.
  2. Dimensions always follow the same order, height before width before depth, and always with a unit.
  3. Prices are plain numbers, without currency sign or thousands separator. That way the spreadsheet can calculate with them.
  4. Dates are written year-month-day, as in the example in column 16. That way dates sort correctly in any spreadsheet.
  5. The sale status uses fixed words. Always use one of the five words from the table above, never "gone" or "with Anna".
  6. File names start with the inventory number. Then every photo leads to its work, and every work to its photos.
  7. 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.
  8. 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.

A spreadsheet with inventory number, title, year and location, and below it the preview Kolopheo shows before taking it over.

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

  1. ICOM, "Object ID", standard for describing cultural objects, retrieved 17 October 2026: https://icom.museum/en/resources/standards-guidelines/objectid/