How to Migrate Your Art Collection from Spreadsheets to Software

Have you ever opened your art collection spreadsheet to look up one painting and spent 20 minutes hunting through five different tabs before giving up?

If so, you already know the spreadsheet problem. It's not that spreadsheets are bad tools. They're genuinely great for lists, budgets, and simple data. The issue is that art collections aren't simple data. They're layered records with ownership histories, condition timelines, valuation changes, and image files that all need to connect to each other. Spreadsheets weren't built for that.

The good news: migrating to dedicated collection management software is a one-time project. Do it right and you'll never need to do it again. This tutorial walks through every step, from cleaning your data before export to verifying your condition records after import.

Why Spreadsheets Fall Apart at Scale

Before getting into the steps, it's worth being clear about where spreadsheets actually break down. Not everyone needs to migrate. If you have 15 pieces and no plans to grow, a well-organized spreadsheet can work just fine.

The problems show up when:

• Your collection hits 40 to 50 pieces and data entry becomes error-prone
• You need to share records with an advisor, appraiser, or estate attorney
• You're tracking multiple versions (current value, insurance value, purchase price) for each piece
• You have images stored in separate folders that have no link to the spreadsheet rows
• Two people edit the sheet at different times and create conflicting records
• You need to generate an insurance report quickly and have to manually compile it

The core structural issue is that spreadsheets store flat, row-based data. Art records are relational. One painting can have five previous owners, three exhibition appearances, two independent valuations, and a conservation treatment that changed its condition grade. You can't represent that cleanly in a single row without either duplicating data everywhere or stuffing everything into one unreadable cell.

Collection management software handles this with linked records. Each artwork connects to separate provenance entries, condition reports, image files, and valuation history without any duplication. That's the architecture that makes things like one-click insurance reports possible.

Step 1: Audit and Clean Your Spreadsheet First

The single most important rule of data migration: clean your data before you move it. Importing a messy spreadsheet into a professional system gives you a messy professional system.

Set aside a few hours to go through your spreadsheet and fix these issues:

• Remove duplicate rows (same artwork entered more than once, usually from different import dates)
• Standardize artist names to one format consistently ("Hockney, David" or "David Hockney," but never both)
• Make sure dimensions follow one unit throughout (all centimeters or all inches)
• Flag records with missing critical data: no title, no artist, no date acquired
• Combine split fields: if "Month Acquired" and "Year Acquired" are separate columns, merge them into one date field
• Check that currency values are plain numbers without symbols (500000, not $500,000)

Save a backup of the original before you touch anything. You'll want that reference if something goes wrong during import.

For a collection of 80 to 100 pieces, this cleaning pass typically takes three to five hours. It's not glamorous work, but problems you fix here won't come back to bite you later.

Step 2: Map Your Fields to Standard Cataloging Fields

Your spreadsheet probably has columns with names that made sense when you created them: "Where I Bought It," "My Estimate," "Last Looked At." Those need to map to standard fields before import.

The Cataloging Cultural Objects standard from the Visual Resources Association defines the fields that galleries, museums, and serious private collectors use. You don't need to follow every convention, but knowing the standard gives you a vocabulary to work from.

Core fields every artwork record needs:

• Title (official title and any alternate titles as separate entries)
• Artist or Creator, with nationality and life dates if known
• Date of Creation, even if approximate (circa 1920, or just "20th century")
• Medium and Materials, specific enough to be useful ("oil on linen" beats "painting")
• Dimensions, height x width x depth, framed and unframed separately
• Acquisition Date, Source, and Purchase Price
• Current Physical Location (room, storage facility, or on loan)
• Condition Status using a defined scale
• Object Identifier or Accession Number, a unique ID you assign

See the art collection database template guide for a complete field list with definitions and examples for each one.

Step 3: Assign Accession Numbers Before You Export

If your spreadsheet doesn't already have a unique ID for each artwork, create one now. Do not skip this step.

Accession numbers are what link everything together during import: artwork records to images, artwork records to provenance entries, artwork records to condition reports. Without them, you're importing disconnected data that can't be joined.

A simple sequence works fine: ACC001, ACC002, ACC003. Or year-based: 2024-001, 2024-002. The format doesn't matter much. What matters is that every row has one, they're all unique, and you use the same ones on your image files and supporting documents.

Once you have accession numbers, export from Excel or Google Sheets as CSV with UTF-8 encoding. This format is accepted by every major collection management platform and preserves special characters in artist names (accents, non-Latin scripts) that would otherwise turn into garbled text.

Step 4: Organize Your Image Files Before Import

Images are the part of migration that almost everyone underestimates. You can't just dump a folder of JPEGs and expect the software to figure out which image belongs to which artwork. You need to organize first.

Before importing any records, rename your image files to match your accession numbers:

• ACC001_front.jpg for the main front view
• ACC001_back.jpg for the reverse with any labels or stamps
• ACC001_detail01.jpg for signature closeups or areas of interest
• ACC001_condition.jpg for any damage documentation

Keep your master files (RAW or TIFF format) separate from the compressed copies you'll upload. The masters are your archival backup. The compressed copies are what goes into the software for daily use.

The art photography documentation guide covers what images you actually need for each piece and the technical specs (minimum 300 DPI, consistent color temperature) that insurance companies and auction houses expect.

For digital artworks or software-based pieces, check the vector graphics and digital art documentation guide, which handles the unique requirements for born-digital collections.

Step 5: Run a Test Import with 15 Records

Never import your full collection in one shot. Test first.

Pick 15 records that represent the variety in your collection: a few well-documented pieces, a few with gaps in the data, one with an unusual material description, and one with multiple previous owners if you have it. Import those and check every field carefully.

Check for:

• Artist names importing with clean formatting and no extra spaces
• Dates reading correctly in the software's date fields
• Currency values displaying as numbers, not garbled text
• Special characters appearing correctly in names and titles
• Images linking to the correct records

Most platforms let you adjust field mapping in the import settings. An hour of testing here saves 10 hours of cleanup after you've imported 500 records and discovered a systematic error.

Once the test import looks clean, delete those test records and run the full import. You want a clean slate, not a mix of test and production data.

Step 6: Migrate Provenance Records Separately

This step is where most migrations fall apart, because provenance doesn't fit neatly into the main artwork record import.

Provenance is the documented ownership history of an artwork from creation to the present day. It's one of the most legally and financially significant things about any piece. Incomplete provenance is one of the leading causes of failed insurance claims and authentication disputes. According to research documented by the Smithsonian Institution, pieces with complete provenance records command significantly higher market values at auction than comparable works with gaps in their history.

If your spreadsheet has provenance crammed into a single notes cell, something like "Bought at Sotheby's 2018, previously Smith Collection, acquired from artist 1965," you'll need to parse that into separate entries. Each ownership period gets its own record with its own date, owner name, location, and documentation reference.

It's painstaking. But doing it right now means you have a defensible paper trail when you need one.

The provenance tracking guide covers the fields and verification methods that meet professional standards, along with common gaps that collectors don't realize matter until it's too late.

Step 7: Set Up Condition Records and Schedule Your First Audit

The final step after getting your main records and provenance in order is condition documentation.

A condition report captures the physical state of an artwork at a specific point in time. In proper collection management software, condition reports are date-stamped and non-editable after the fact. You can only add new ones, never change old ones. This creates an audit trail that insurers and auction houses can actually rely on.

For migration purposes, if your spreadsheet had a simple condition column with values like "Good" or "Fair," those become your baseline entries. Import them dated as of your migration date with a note that they came from a prior system. Then, over the following months, schedule physical inspections to create verified condition reports for each piece.

The art collection inventory guide includes a practical scheduling framework for working through condition audits without turning it into a full-time job.

Common Mistakes to Avoid

A few things that consistently cause problems during migrations:

Importing without accession numbers: If you skip Step 3, your records, images, and provenance entries can't link to each other. You end up with three separate islands of data instead of one connected collection.

Migrating images after the fact: Linking images to records after import is tedious and error-prone. Do the image organization before you start importing. It's much cleaner.

Not setting user permissions: If anyone else will access the system, an advisor, an estate manager, a gallery contact, decide which roles get read access and which get edit access before you share credentials. Most platforms have read-only, editor, and admin tiers.

Ignoring the test import: It feels like an extra step you don't need. It never is.

Treating migration as a one-person job without review: After you import, have someone else spot-check 20 records against the original spreadsheet. You'll almost always catch something you missed.

What You Can Do After Migration That You Couldn't Before

Once your collection is properly migrated, things that used to take hours become fast:

• Generate a complete insurance report filtered by location or medium in one click
• Share a secure, view-only link to a buyer or appraiser without emailing files
• Pull up a full ownership timeline for any piece in seconds
• Set automated reminders for annual valuations or condition checks
• Run a report showing every piece currently on loan with return dates
• Search across your entire collection by any field: artist, medium, acquisition year, condition grade

For most collections between 50 and 200 pieces, the actual migration work takes two to three days of focused effort. The timeline for getting everything right is typically two weeks if you're fitting it around other work.

That investment pays off every time you need documentation quickly, whether for an insurance claim, an estate attorney, a loan request, or a sale. The documentation is already there, already organized, already linked to the images and the history.

For a broader look at the documentation errors that migration alone won't fix, the art cataloging mistakes guide covers the ongoing habits that determine whether your collection records stay clean after you've moved them.