Reviewed as of 27 September 2026. If anything has changed, let me know and I will update it with the date of the change.
The master record is the register from which all the other documents derive: the technical data sheet for an exhibition, the certificate of authenticity, the description on an invoice, the dossier entry and, in time, the catalogue raisonné entry. If it is well kept, they all repeat the same data. If it does not exist, each document is rebuilt from memory and discrepancies appear.
This template proposes essential fields and explains what they are for. It is an internal document: it is not handed over as it is and has no contractual effect. It can be managed in a spreadsheet, a database or a collections management system. What matters is that each work has a stable identifier, a single master record and a history of changes.
Downloads
- Master artwork record, full workbook in ODS format
- Master record, CSV
- Restricted data, CSV
- Gallery consignment, CSV
The ODS file is the main version. It contains four sheets:
- Master record (Ficha maestra), with one row per work.
- Restricted data (Datos reservados), for owner, location, price, invoice, intermediary and insurance value.
- Gallery consignment (Depósito en galería), for recording handovers, returns or sales.
- Legend (Leyenda), with the formats and calculated fields.
The ODS includes validations, filters, frozen headers and an example row. In 'Gallery consignment', the title is pulled from the master record through the inventory number. The CSV files let you open or import the three data sheets separately; they use UTF-8 with BOM and a semicolon as separator.
The 'Restricted data' sheet contains personal, financial and location information. It must not be published or shared together with the general record. The 'Gallery consignment' sheet is a handover log: it does not replace the contract, nor does it on its own govern custody, liability, insurance, commission, discounts, payment or return.
Identification
Inventory number
What to enter. A unique code that is never reused, even if the work is destroyed, lost or leaves the artist's collection.
Why it matters. It links the work to photographs, invoices, contracts, certificates, loans and publications. The title is not a stable identifier because it can be repeated or change.
Caution. The code should physically accompany the work, but it is not written directly on just any material. The labelling or marking method should be safe, findable and, where possible, reversible. If in doubt, consult a conservator. For works with separable components, record each part.
Title
What to enter. The current title and any known earlier titles.
Why it matters. A retitled work may appear under another name in older exhibitions, invoices or publications.
Fecha
What to enter. Year of completion and, if the process was long, the year started. Use an approximate date when the exact one is not documented, for example 'c. 2019' or '2019-2020'.
Caution. Do not turn an estimate into an exact date just to fill in the field.
Series or project
What to enter. The group the work belongs to and its position within it, if relevant.
Material description
Medium, materials and support
What to enter. A specific description, for example 'oil on canvas' or 'pigment print on cotton paper'.
Why it matters. It affects identification, conservation, transport and installation.
Dimensions
What to enter. Height by width by depth, in centimetres, without frame. Add the framed dimensions separately when useful.
Caution. Always indicate the order and the unit. For variable installations, record the minimum, maximum or recommended dimensions and attach a plan. The template uses three numerical columns in this order: height, width and depth.
Weight
What to enter. The total weight and, where relevant, that of each component or crate.
Why it matters. It can affect transport, fixings, handling and safety.
Edition
What to enter. Copy number, total edition size and artist's proofs when the work type is 'Edition'.
Caution. Copies share an edition but must have their own identifiers. Do not enlarge an edition that has already been announced or sold without weighing the contractual and commercial consequences.
Signature, inscriptions and marks
What to enter. Location and transcription of signatures, dates, dedications, stamps, labels and other marks. Also document them with photographs.
Image and files
Identification photographs
What to enter. The file names of the front, back, signature and other views or details. Keep a stable naming convention that starts with the inventory number.
Why it matters. The reverse, labels and details are often decisive in identifying a piece years later.
Digital files
What to enter. Name, format, version and location of the artwork's files.
Caution. Distinguish between the master file, the exhibition copy, documentation and any software needed to run the work. If you need to record size, duration, checksum or technical dependencies, add them to the field or to a linked document.
Process and authorship
Process
What to enter. References to sketches, studies, versions and working files.
If you used artificial intelligence tools, select 'Yes' in the corresponding field and describe separately what the artist did: materials contributed, selection, editing, composition, transformation or material intervention. Do not present the mere use of a tool as automatic proof of authorship.
Installation instructions and variability
The downloadable sheet does not have a separate column for long instructions. Record a brief reference in 'Process' or 'Notes' and keep the full document linked through the inventory number.
In an installation or a variable work, the instructions may be part of what allows the work to be recognised across its different realisations.
History
Exhibitions and publications
What to enter. Institution, venue, title, curators and dates of each exhibition; and enough detail to locate books, catalogues, articles, websites or audiovisual material.
Transfers, deposits and location
The general situation is recorded in 'Current status'. Personal data, location, price, invoice, intermediary and insurance value belong in 'Restricted data'. Handovers to galleries are also recorded in 'Gallery consignment'.
Caution. Distinguish between ownership, possession and location. Do not publish private information about the buyer or depositary.
Condition and conservation
What to enter. Current condition, damage, restorations and the date of each intervention. If you need a detailed report, keep the file linked through the inventory number.
Rights and conditions
The downloadable sheet is not meant to replace a full legal register. Use 'Notes' to refer to contracts, assignments, licences, reproduction restrictions, photo credits and agreed credits. Keep the full documents separately and link them through a stable name or reference.
Caution. Selling the physical object does not in itself transfer the exploitation rights.
Restricted data
The full record may contain personal, commercial and security data. The resource explicitly separates them from the master record.
Owner, consent and location
The 'Restricted data' sheet lets you record the current owner, consent to record their details, date and location. Consent is not the only possible legal basis for processing personal data, and ticking 'Yes' does not replace the relevant analysis. The field documents whether that consent was obtained; it does not claim that consent is always necessary or sufficient.
Restrict access and avoid disclosing addresses or sensitive locations.
Price, invoice and insurance value
Record sale price, date, invoice number, intermediary and insurance value separately. They are internal data and may change for different reasons.
Checks and maintenance
- Delete the example rows before entering real data.
- Do not reuse inventory numbers.
- Update the record after every exhibition, deposit, loan, sale, intervention or move.
- Keep contracts and full documents outside the sheet, linked by the inventory number.
- Keep separate copies and check that they open.
- Export the data sheets to CSV regularly.
- Decide who will keep and be able to update the file if you cannot.
Fields included in the downloadable version
The 'Master record' sheet includes:
- inventory number;
- title and previous titles;
- year of completion and year started;
- approximate date flag;
- series or project;
- medium and support;
- height, width and depth in centimetres;
- framed dimensions;
- weight;
- work type;
- copy number, total edition size and artist's proofs;
- signature, inscriptions and marks;
- image files;
- digital files;
- process;
- use of AI tools and description of the artist's intervention;
- exhibitions and publications;
- condition and restorations;
- current status;
- certificate number;
- last update;
- notes.
On the open conversation
This template draws on archive and collections registration practice. It is a starting point, not a closed standard. If you work in registration, conservation or artist archives and notice a missing field or wording that should be corrected, the template remains open.