Every art collection needs a backbone: a structured database that records what you own, where it came from, where it sits right now, and what it's worth. Whether you're managing twelve paintings inherited from a relative or three hundred works acquired over decades, the database structure matters more than the tool you choose. Get the fields right and the data stays useful for years. Get them wrong and you'll be rebuilding from scratch when your insurer asks for documentation you never captured.
Core Fields Every Art Database Needs
Regardless of whether you're working in a spreadsheet or dedicated software, these fields form the minimum viable record for each artwork. Skip any of them and you'll eventually regret it.
| Field | Purpose | Example |
|---|---|---|
| Inventory Number | Unique identifier per piece | 2026.014 |
| Artist Name | Creator attribution (Last, First) | Hockney, David |
| Title | Work title (or "Untitled" with description) | A Bigger Splash |
| Date Created | Year or date range | 1967 |
| Medium | Materials and technique | Acrylic on canvas |
| Dimensions | Height x Width x Depth (specify unit) | 96 x 96 in (243.8 x 243.8 cm) |
| Acquisition Date | When you obtained the work | 2024-11-15 |
| Acquisition Source | Gallery, auction, private sale, gift | Christie's London, Lot 42 |
| Purchase Price | Amount paid (with currency) | $45,000 USD |
| Current Location | Physical location of the piece | Home office, east wall |
| Image Reference | Primary photograph filename or link | 2026-014_front.jpg |
Extended Fields for Serious Collections
Once you've covered the basics, these additional fields turn a simple inventory into a proper collection management system. They become essential when dealing with insurers, lenders, or estate planning.
Provenance and Ownership History
Record the chain of ownership from the artist's studio to your hands. Each provenance entry should include the previous owner's name, their location, the dates of ownership, and how the transfer happened (purchase, gift, inheritance, auction). If you have supporting documents like receipts, invoices, or auction catalog pages, note the filename or storage location for each. A well-documented provenance record adds both monetary and scholarly value to every piece.
Condition and Conservation
Include a condition status field (excellent, good, fair, poor) along with a date-stamped notes field for condition observations. Whenever a piece is moved, lent, or returned from exhibition, update the condition record. If conservation work was performed, record the conservator's name, the date, what was done, and the cost. These records protect you during insurance claims and help future owners understand the work's physical history. Our condition report guide covers the documentation standards in detail.
Insurance and Valuation
Track the current insured value, the date of the last appraisal, and the appraiser's name. Insurance values drift from market values over time, so include a field for scheduled reappraisal dates. Most fine art policies require updated appraisals every three to five years. Having this data in your database means you can filter for pieces due for reappraisal and generate a list for your insurer without digging through paper files.
Exhibition and Publication History
If a piece has been exhibited or published, record the venue name, exhibition title, dates, and catalog reference. This data matters for both provenance verification and value assessment. Works with strong exhibition histories from recognized institutions carry higher market confidence.
Structuring Your Database for Growth
The biggest mistake collectors make isn't choosing the wrong tool. It's designing a flat structure that can't scale. Here's what to keep in mind:
- One record per artwork: Never group multiple works in a single row, even if they were acquired together. Each piece needs its own inventory number and complete field set.
- Consistent formatting: Decide on a date format (ISO 8601: YYYY-MM-DD), a dimension format (H x W x D with unit), and an artist name format (Last, First) before entering your first record. Document these conventions.
- Controlled vocabulary: Use standardized terms for medium descriptions. "Oil on canvas" not "oil/canvas" or "Oil paint on stretched canvas." The Getty Art & Architecture Thesaurus is the industry standard reference.
- Separate tables for related data: If your tool supports it, keep exhibition history, provenance entries, and condition reports in linked tables rather than cramming everything into a single row. This is where dedicated collection software outperforms spreadsheets.
- Image file naming convention: Use the inventory number as the base filename. Front views, detail shots, and verso images get suffixes: 2026-014_front.jpg, 2026-014_detail-signature.jpg, 2026-014_verso.jpg.
Spreadsheet Approach: When It Works
A Google Sheets or Excel workbook with the core fields listed above handles collections under 50 pieces reasonably well. Create one sheet for the main inventory and a second sheet for provenance notes linked by inventory number. Use data validation on the condition status column (dropdown: Excellent / Good / Fair / Poor) and a date picker for acquisition dates to keep formatting consistent.
The limitation hits when you need to attach images, link one artwork to multiple exhibitions, or generate reports for an insurer. At that point, a free or low-cost collection tool is worth the migration effort.
Software Approach: When to Upgrade
Move to dedicated software when any of these apply:
- Collection exceeds 50 works: Managing more than 50 rows of complex data with linked images and provenance documents becomes unwieldy in a spreadsheet.
- Insurance requirements: Your insurer requests formatted valuation reports. Most spreadsheets can't generate these in the expected format.
- Multi-location storage: Pieces are split across homes, storage facilities, and loan venues. Software with location tracking prevents the "where is that painting?" problem.
- Collaboration needs: An advisor, estate planner, or registrar needs access with controlled permissions. Shared spreadsheets don't support role-based access.
Professional platforms like ArtVault Pro handle all of these scenarios with structured data models built specifically for art collections. The features page explains how each module maps to the fields and workflows described here.
Frequently Asked Questions
What fields should an art collection database include?
Every art collection database needs these core fields: unique inventory number, artist name, title, date created, medium/materials, dimensions (height x width x depth with unit), acquisition date, acquisition source, purchase price, current location, and at least one image reference. For serious collections, add provenance notes, condition status, insurance value, exhibition history, and last appraisal date.
Should I use a spreadsheet or dedicated software for my art database?
Spreadsheets work for collections under 50 pieces with straightforward documentation needs. They're free, familiar, and easily shared. However, they can't handle image galleries attached to records, relational provenance data, or formatted insurance reports. Once your collection exceeds 50 works or includes pieces valued above $5,000, dedicated collection management software saves significant time and reduces documentation gaps that could cause problems during insurance claims.
How do I number artworks in my collection database?
Use a consistent numbering system from the start. A common approach is year-based sequential numbering: 2026.001, 2026.002, and so on. Museums often use accession numbers (year of acquisition followed by a sequence number). Avoid renumbering or reusing numbers after deaccessioning a piece. Whatever system you choose, apply it uniformly and record it in your database documentation so anyone managing the collection later can continue the pattern.
Can I migrate data from a spreadsheet into collection management software?
Yes. Most art collection management platforms accept CSV imports. Before migrating, clean your spreadsheet: standardize artist name formatting (Last, First), ensure dimensions use a consistent unit, and remove duplicate entries. Export as CSV, then use your software's import tool to map spreadsheet columns to database fields. Budget a few hours for cleanup and field mapping for every 100 records.