Sooner or later, every serious CellarTracker user runs into the same question. Sometimes the insurance agent asks for an updated wine schedule. Sometimes the estate attorney needs an asset list. Sometimes you're at dinner and a guest asks what's on the table — and you realize you don't actually know what it's worth.
I'd bought four bottles of Hibiki 12 Year when I heard the Japanese whisky was being discontinued back in 2015. I tucked them away and didn't think about them for over a decade — until one day I did, and wondered what they were worth. I had no reliable way to find out.
CellarTracker can tell you what's in your cellar. It's been doing that for twenty years, and there's no better record. But CellarTracker was built to answer what bottles do I own, not what is this worth today. For serious collectors, that second question is the one that matters — and it takes a different method to answer.
This piece walks the methodology a CellarTracker user can apply today, using their existing export, with no specialized tools. Plus the honest time cost: three to four hours for a 200-bottle cellar.
Why collectors actually need this number
Four reasons, each carrying enough weight that getting the answer right matters.
Insurance scheduling. Standard homeowner policies in the US cap collectibles — art, wine, spirits — at a sublimit that typically runs $1,000 to $5,000 per category, regardless of what the collection is actually worth. A 200-bottle serious cellar sits far above that: $30,000 to $200,000+ is the typical range for the kind of collection reading this far. The gap between policy default and real value is uninsured unless you schedule the collection, and scheduling requires a documented valuation.
Estate and trust planning. Wine and whisky are real asset classes for estate filings. The IRS expects documentation; trustees expect a number. Vague valuations create vague tax exposure and slow probate. A collection with no documented value is one that makes work for your heirs at exactly the wrong moment.
Sale preparation. Consignment fees, broker rates, auction commissions, and timing decisions all depend on knowing what you have. Sellers who walk in with the right number get better outcomes than sellers who guess. Guess low and you leave money on the table; guess high and the buyer talks you down.
Portfolio framing. The decisions about which bottles to hold, drink, or sell change once you know the aggregate. The cellar stops being a hobby and starts being a position. Whether that framing fits your relationship to your wine is personal — but it isn't available to you until the number is.
Why most collectors guess wrong
Most collectors who try to value their cellar make at least one of three mistakes, and each moves the number in a predictable direction.
Anchoring on retail prices. What a retailer charges today is what it costs to buy a bottle, not what it would clear at sale. Retail carries margin, storage, and the cost of running a shop. Secondary-market clearing prices — what an end buyer actually pays in a peer-to-peer or auction-adjacent transaction — typically run 15 to 40 percent below retail. Anchor on retail and you overstate your cellar by roughly that gap.
Using release prices. A 2010 Pétrus released at futures pricing in the low thousands per bottle; a verified bottle clears north of $6,000 on the secondary market today. More than a decade of appreciation gets missed if you anchor on what you paid. Whisky is the same story: those four Hibiki 12s I bought near release sit well into the hundreds each now, because Suntory discontinued the expression in 2015 and the supply never came back. This mistake especially hits collectors who bought ten-plus years ago and haven't tracked the market — exactly the cohort with the largest cellars.
Asking a single merchant. “What would you pay for these?” produces a wholesale-flavored number. Merchants need margin to resell, so their offer sits below your fair-sale value. Three merchants triangulate better, but the floor is still wholesale. The right comparison is a merchant offer benchmarked against secondary-market data, not the offer alone.
The bonus mistake: skipping the haircut. Provenance and storage both move value. A bottle with verifiable cellar history — temperature-controlled, low light, no transit damage — clears at full market. A bottle without that history typically haircuts 10 to 25 percent. Most DIY valuations skip this step entirely.
The combined effect is unpredictable but rarely small. Collectors who do the work honestly end up with a number 20 to 50 percent different from where they started.
The data sources that matter
Four categories of source data. Each has tradeoffs; none is sufficient alone.
Secondary-market price aggregators. Several public aggregators compile buy-side and sell-side data across merchants, auction houses, and recent listings. The aggregate is the closest proxy to what would this clear at for liquid bottles. For Bordeaux first growths, top-tier Burgundy, Napa cult Cabernet, and headline whisky like Macallan or Yamazaki, the aggregator answer usually lands within a few percent of the true clearing price. For niche bottles — small Burgundy producers, single-cask whisky, mature Champagne — the data thins out and gets less reliable.
Auction-house archives. Public records of lots sold at known houses are the gold standard for liquid bottles. The hammer price is real money paid; the date and lot details are verifiable. The downside is selection bias — only a thin, top-tier slice of bottles reaches auction. For a Cru Bourgeois that drinks well but never trades at auction, the archives won't help.
Community-aggregated values. CellarTracker's own approach: members enter what they paid and what they think bottles are worth. The data is real but lags the market, because it reflects observations made months or years ago. Useful as a sanity check; not a primary source for a current valuation.
Professional appraisers. Specialized firms produce defensible documents for insurance, estate, and divorce — contexts where the deliverable is the paperwork, not the number. Cost typically runs $500 to $2,500 for a serious cellar. Worth it when you need a defensible third-party valuation; overkill when you just want to know.
Most DIY valuations should triangulate between the first two — aggregators and auction archives — with community values used as a check rather than a foundation.
The DIY method using your CellarTracker export
A repeatable method you can run today. Five steps. Realistic time cost: three to four hours for a 200-bottle cellar.
Step 1: Export. In CellarTracker, go to Settings, then Export, then choose CSV. The file lands in your downloads folder.
Step 2: Sort by likely value. Open the CSV in a spreadsheet and sort by your top 20 line items by estimated value — usually producer × vintage × quantity. The top 20 typically carry 60 to 80 percent of total cellar value, so that's the highest-leverage place to spend your effort. Three bottles of 2010 Pétrus, or a few discontinued Hibikis, will outweigh forty bottles of everyday drinking wine in the rollup.
Step 3: Cross-reference. For each top-20 line item, look up secondary-market data from two or three sources for triangulation: an aggregator, an auction-archive search, and a sanity check against community values. For a 2010 Pétrus or a Macallan 18 Sherry Oak, expect the aggregator and archive numbers to converge within a few percent. For a niche Burgundy or a single-cask bottling, expect more spread.
Step 4: Apply haircuts. Make two adjustments to each top-20 value. First, provenance: if you don't have documented cellar history for these bottles, take 10 to 15 percent off. Second, storage: if your cellar isn't temperature-controlled to professional standards, take another 5 to 10 percent. Combined, most home cellars haircut 15 to 25 percent against the aggregator quote. If your storage is impeccable and documented, skip it.
Step 5: Roll up. Add the adjusted top-20 values, then estimate the remaining 80 percent of the cellar at conservative averages — release price plus modest appreciation for non-liquid bottles, market value for the liquid ones. Add the two together. That total is your aggregate.
The first time I tried this on my own collection, I started bottle-by-bottle with Google, then a couple of wine pricing aggregators, then fell down a rabbit hole looking for reliable data. With AI everywhere now, I figured I'd just have it value the whole thing — exported my CellarTracker file, dropped it into ChatGPT, and it went badly. Lots of back-and-forth, and lots of caveats from the model itself that these weren't live prices, just “informational” estimates. That's when I realized I'd have to build this myself. What started as a weekend project became Cellar IQ. When I finally ran my collection through it — against live secondary-market valuations, refreshed weekly — the number came back more than three times what ChatGPT had given me. That was the aha moment, and I knew I wasn't the only one stuck on this.
What this exercise does not produce is a defensible legal document. If you need that — for insurance scheduling, estate filings, or sale prep on a high-value collection — pay the appraiser. What it does produce is a number good enough for portfolio decisions, sanity checks, and the conversations you'll have with your insurance agent before deciding whether to pay for the formal appraisal.
When automation is worth it
The DIY method works. The problem is it has a half-life.
A valuation you produce today is good for about six months. After that, market shifts — vintage re-ratings, peer-producer movements, broader fine-wine and whisky trends — make the number drift. For a static cellar, six months is fine; you redo it once or twice a year and move on.
For an active cellar — ten or more transactions a year, regular allocations, ongoing purchases — the refresh becomes a quarterly chore. You're back in the spreadsheet, re-running the top 20, re-applying the haircuts, re-rolling the aggregate. Three to four hours each time, twelve to sixteen hours a year. That's the real cost of DIY for a moving collection.
This is the gap that drove me to build Cellar IQ. The same CellarTracker export you'd use for the DIY exercise imports in one upload, and a reference index of 204,000+ wines and whiskies handles the matching — it matches the vast majority of mainstream collections automatically. Live secondary-market valuations refresh weekly, with on-demand refresh once a day on the Collector tier. The aggregate becomes a glance, not an afternoon. If you're weighing the switch, the CellarTracker-specific comparison is here.
Get your collection valued automatically
Cellar IQ turns that same CellarTracker export into an ongoing valuation. Import your full collection free — the first 50 bottles stay visible, the rest are stored, never deleted. Collector unlocks your full collection at $19/month, and the first 50 founding members lock $12/month for life.
Sign up for free early access →If you'd do the DIY method once and never revisit it, skip the automation. If you'd repeat it more than twice a year, the time pays for itself.
The aggregate number is the beginning, not the end
Knowing what your cellar is worth changes what you do with it. The decisions about which bottles to hold, drink, or sell are different when you have the number than when you don't. Most CellarTracker users have never crossed that threshold — the data wasn't there to support it.
Once I had that number, I knew this was more than a decades-long collection of wine and whisky. It was a real asset — and it needed to be treated like one.
For a framework on what to do with the number once you have it, see When to sell wine from your cellar.
Informational only. Not investment advice.