Art Inventory Template for Excel and Google Sheets

You don't need expensive software to start documenting your art collection. A well-structured spreadsheet in Excel or Google Sheets captures the same core data that professional collection management systems use. The key is getting the column structure right from the start so you don't have to rebuild it later when your collection grows or your insurer asks for a specific report format.

Setting Up Your Spreadsheet Structure

Open a new workbook and create two sheets: "Inventory" for your main catalog and "Provenance Notes" for ownership history details. The Inventory sheet is your daily reference. The Provenance sheet links to it by inventory number and holds longer text entries that would make the main sheet unreadable.

Inventory Sheet Columns

These columns cover the fields that insurers, appraisers, and estate planners most commonly request. Set them up in this order, left to right:

Column	Format	Notes
A: Inventory #	Text (e.g., 2026.001)	Never reuse numbers, even after selling a piece
B: Artist	Last, First	Use "Unknown" or "Attributed to" where needed
C: Title	Text	"Untitled (description)" for untitled works
D: Year	Text (allows "c. 1920")	Use "c." for circa, ranges as "1918-1920"
E: Medium	Text	Standardize: "Oil on canvas" not "oil/canvas"
F: Height	Number	Always in same unit across entire sheet
G: Width	Number	Same unit as height
H: Depth	Number	For sculptures, installations. Leave blank for flat works
I: Unit	Dropdown (in / cm)	Data validation: restrict to "in" or "cm"
J: Acquisition Date	Date (YYYY-MM-DD)	ISO format sorts correctly
K: Source	Text	Gallery name, auction house + lot #, private sale
L: Purchase Price	Currency	Include currency code if mixed (USD, EUR, GBP)
M: Location	Text	"Home - Living Room, North Wall"
N: Condition	Dropdown	Excellent / Good / Fair / Poor
O: Insurance Value	Currency	Current replacement value per your policy
P: Last Appraisal	Date	Highlight if older than 3 years
Q: Image File	Text	Filename referencing your photo folder
R: Notes	Text	Brief notes, condition updates, research flags

Provenance Notes Sheet

The second sheet tracks ownership history for each piece. Columns: Inventory # (linking to main sheet), Previous Owner, Owner Location, Date Range (from-to), Transfer Method (purchase, gift, inheritance, auction), Supporting Documents (filename references), and Notes. One row per ownership period means a piece that changed hands four times gets four rows, all sharing the same inventory number.

Data Validation Tips

A spreadsheet without data validation drifts into inconsistency within weeks. Set these up before entering your first artwork:

• Condition column: Add a dropdown list restricted to four values: Excellent, Good, Fair, Poor. In Google Sheets: Data > Data validation > List of items. In Excel: Data > Data Validation > List.
• Unit column: Dropdown restricted to "in" and "cm". Mixing units in the same sheet causes errors in insurance totals and shipping estimates.
• Date columns: Format as date type with YYYY-MM-DD pattern. This ensures chronological sorting works correctly and avoids the US/EU date format confusion that causes catalog errors.
• Currency columns: Format as currency with two decimal places. If your collection includes pieces purchased in different currencies, add a Currency Code column and store values in the original currency. Convert for reports, not in the source data.

Conditional Formatting for Quick Visibility

These formatting rules let you scan the spreadsheet and spot items that need attention:

• Overdue appraisals: Highlight the Last Appraisal column in yellow when the date is more than 3 years old. Formula: =P2
• High-value items: Bold or color the Insurance Value column for pieces above a threshold (say $10,000). These are the records that need the most thorough documentation.
• Condition alerts: Red background on "Poor" condition entries so they stand out during a quick scroll through the collection.
• Missing data: Light orange background on any empty cell in required columns (Artist, Title, Location, Insurance Value). Gaps in these fields create problems during insurance claims.

Photo Management Alongside Your Spreadsheet

The spreadsheet catalogs the data. Your photos live separately. Set up a folder structure that mirrors the inventory:

Art-Collection-Photos/
  2026.001/
    2026.001_front.jpg
    2026.001_back.jpg
    2026.001_detail-signature.jpg
  2026.002/
    2026.002_front.jpg
    2026.002_installation.jpg
  2026.003/
    ...
        

Name every photo starting with the inventory number. When you need to find the image for a specific piece, sort your photo folder and the spreadsheet matches up instantly. Store originals at full resolution for insurance documentation. Photograph each piece against a neutral background with even lighting, and include a color reference card in at least one shot for accurate reproduction.

When the Spreadsheet Hits Its Limits

A spreadsheet handles the data side of collection management. It doesn't handle:

• Integrated image viewing: You can't click a spreadsheet row and see all six photographs of that sculpture in a gallery view.
• Formatted reports: Generating a PDF insurance report with images, valuations, and provenance from a spreadsheet requires manual layout work every time.
• Relational queries: "Show me everything acquired from Gallery X that's currently on loan" is a complex cross-reference in a spreadsheet but a single search in dedicated software.
• Audit trail: Spreadsheets don't log who changed what and when. For collections with multiple stakeholders, this matters.

If you're reaching these limits, your spreadsheet has done its job as a starting point. The data exports cleanly to CSV, and most collection management platforms accept CSV imports. Moving to a structured database system means your spreadsheet data migrates over and gains the features that flat files can't provide. ArtVault Pro's import tools are built for exactly this transition.