The Essential Fields for a Collection Catalog
Every collection catalog needs six core fields: figure name, edition or variant, purchase price, purchase date, current condition, and location (which shelf, which storage bin). These six fields answer the questions that matter most — what do I own, what did it cost, what shape is it in, and where is it right now. Everything else is supplementary.
Add current estimated value as a seventh field and you have the foundation of an insurance catalog. You don't need to update this field constantly — quarterly is often enough for most collections. Note the date the value was estimated alongside the number, so you can tell at a glance whether the figure is valued at today's prices or two years ago's prices.
Optional but useful additional fields: the source (where you bought it — store name, website, secondary market), box condition (if you keep packaging), photo reference (a cell link to the photo file), and notes (any detail about the piece's history, significance, or condition quirks). These fields add depth without being required to maintain the core catalog's function.
Building the Template in Google Sheets
Create a new Google Sheet and set up columns in this order: Figure Name, Series/Edition, Purchase Price, Purchase Date, Condition, Location, Current Value (Est.), Value Date, Source, Notes. Freeze the header row (View → Freeze → 1 row) so it stays visible as you scroll. Use alternating row colors (Format → Alternating Colors) for readability.
Set up data validation on the Condition column to restrict entries to a defined set: Mint in Box, Near Mint, Very Good, Good, Fair. This prevents typos and makes filtering by condition reliable. In Google Sheets, select the condition column, go to Data → Data Validation, choose 'List of items', and enter your condition grades separated by commas.
Add a Summary tab. In this second tab, use COUNTIF and SUMIF formulas to automatically calculate total pieces owned, total purchase cost, total estimated current value, and value by condition tier. These summary numbers update automatically as you add to the catalog and give you a portfolio overview at a glance.
Using Conditional Formatting to Surface Insights
Apply conditional formatting to the Current Value column to highlight pieces where value has increased significantly over purchase price. A formula rule like =(G2-C2)/C2 > 0.5 (value has increased more than 50% over purchase price) highlights those cells in green. This makes it instantly visible which pieces have appreciated most without manually scanning the catalog.
Highlight figures with no photo reference using conditional formatting on the photo column — any blank cell flagged in light yellow reminds you that documentation is incomplete. This simple visual flag keeps the catalog's documentation quality high without requiring manual audits.
Sort and filter are your most powerful catalog tools once the data is in. Filter by location to see everything on a particular shelf before rearranging. Sort by purchase date to see the chronological story of your collection. Sort by current value to see your most valuable pieces at a glance. Filter by condition 'Near Mint' to identify pieces that might benefit from improved storage.
Maintaining the Catalog Without Burnout
The catalog only works if it's current, and it only stays current if updating it feels light. Keep the template open in a browser tab or pinned in your bookmarks. When a new figure arrives, add its row within 24 hours — the details are fresh in your mind and it takes about two minutes. Waiting until 'later' is how catalogs fall three months behind and become inaccurate.
Set a quarterly reminder for the value update. Go through the catalog, check current eBay sold listings or secondary market prices for any pieces you suspect have moved significantly, and update those values. You don't need to update every piece every quarter — focus on pieces you know are actively traded on the secondary market.
Share the sheet (read-only) with anyone who might need the catalog: a partner, a trusted friend who knows about the collection, or your insurance agent if you're maintaining it for coverage purposes. The shareable link means your catalog is accessible even if your primary device is unavailable — an important consideration if you ever need to file an insurance claim.