Why Spreadsheets Are Killing Your Whisky Collection

The Spreadsheet That Made You Feel Organised

Most serious collectors reach for a spreadsheet at around bottle number eight. Before that, memory works fine. After that, a Google Sheet feels like a reasonable solution. You create a few columns—Distillery, Name, Vintage, Age Statement, Purchase Price, Retailer, Date Acquired, Notes—and spend a satisfying Saturday afternoon entering everything you own. You share it with a friend. You feel organised.

For twenty bottles, this works. You can scan the whole list in two minutes. You remember the context behind most of them. The spreadsheet is essentially a tidy version of what you already carry in your head.

Then the collection grows. You add a few bottles at a trade show, a handful from a distillery visit, some special releases you picked up at retail. The spreadsheet gets longer. Updating it becomes a task you defer. Some columns start to drift—you stopped filling in the retailer field months ago, the notes column is inconsistent, two entries have slightly different naming conventions for the same distillery. And none of it—not a single cell—tells you what those bottles are worth today.

This is where the spreadsheet stops being a tool and starts being a liability.

Problem 1: It Tracks Cost, Not Value

This is the fundamental flaw, and it is worth being direct about it. A spreadsheet is a ledger of what you paid. It is not a valuation of what you own. Those are different things, and in a market as dynamic as whisky, the difference compounds over time.

Consider a bottle of Ardbeg 10 you purchased in late 2021 for £45 at retail. Secondary market data from 2025 shows the same expression regularly achieving £60–65 at auction, reflecting increased demand and a tighter retail supply following allocation changes. Your spreadsheet still says £45. You have an unrealised gain of roughly 40% that you cannot see, cannot act on, and cannot factor into any decision about whether to hold, sell, or drink that bottle.

The reverse is equally important. A blended malt you paid a premium for during peak hype has softened. The secondary market has corrected. Your spreadsheet does not know this. You might be holding a bottle you believe is appreciating when it has already given back its gains. This kind of invisible loss is precisely what a portfolio tracker is designed to surface.

Cost basis matters for tax purposes. But for portfolio decisions—what to hold, what to sell, what to buy more of—current market value is what counts. A spreadsheet gives you cost and calls it done.

Problem 2: It Rots Over Time

A spreadsheet requires active, deliberate maintenance. Every bottle you acquire needs to be entered. Every bottle you open or sell needs to be removed or marked as consumed. This is straightforward when you're disciplined about it and the collection is small. It becomes increasingly unmanageable as the collection grows—and virtually nobody maintains the discipline indefinitely.

The typical pattern is a period of conscientious updating followed by a gradual drift. You add three bottles but forget to enter the third one. You drink a Springbank but don't delete it from the sheet for a month. You sell two bottles at a charity auction and mean to update the records but never quite get around to it. Within eighteen months, a spreadsheet that began as a precise record has become an approximation.

An outdated spreadsheet is worse than no spreadsheet, because it provides false confidence. You think you know what you own. You reference it when deciding whether to buy a duplicate. You use it to estimate your collection's insurance value. You quote the total to a friend. All of these actions are now based on stale data that no longer accurately reflects reality.

A proper tracking tool solves this by making updates frictionless—mobile entry at the point of acquisition, barcode or search-based bottle identification, automatic removal when you mark a bottle as opened or sold. The lower the friction, the more reliably the record stays current.

Problem 3: It Doesn't Think For You

Even a perfectly maintained spreadsheet is passive. It holds data; it does not analyse it. If you want to know which distillery represents the largest proportion of your portfolio by current value, you need to build a pivot table and populate it with manually sourced market prices. If you want to know which age bracket has appreciated most over the past two years, you need to reconstruct historical pricing from memory or external sources. If you want to see your total unrealised gain across the collection, you need to find current valuations for every bottle, enter them by hand, and write a formula.

None of this is technically impossible. It is just sufficiently tedious that almost nobody does it—which means almost nobody actually knows what their collection is doing.

A portfolio tracker performs this analysis automatically. Portfolio allocation by distillery, region, age bracket, or bottler. Gain and loss per bottle, per category, and across the whole collection. Bottles that have performed above or below the market average. These are not sophisticated requirements; they are the basic analytics that any investor would expect from a portfolio management tool in any other asset class. Whisky collectors have been making do without them because the tooling has not existed. That is changing.

Problem 4: It Can't Follow Market Movements

Whisky auction prices are not static. They move in response to distillery news, new releases, collector trends, and broader economic conditions. A distillery acquisition can move prices 15–20% in either direction within weeks of the announcement. A high-profile auction result for an old expression can reprice the entire series. A limited release announcement from a previously undercollected distillery can shift the market for that producer's older bottles significantly.

A spreadsheet captures a price at the moment you enter it. From that point forward, it ages. The market moves; your spreadsheet doesn't. The gap between the prices in your sheet and the prices on the current secondary market widens incrementally every day. After two years, your spreadsheet might be so disconnected from reality that it is actively misleading.

Portfolio trackers connected to live auction data solve this by updating valuations automatically as new comparable lots sell. You open the app and see the collection's current market value, not the value at the time you last decided to update your spreadsheet.

Problem 5: It Doesn't Scale

The scaling problem is not just about volume. It is about complexity. At 20 bottles, your collection is probably concentrated in a few distilleries you know well. At 100 bottles, you likely have expressions from dozens of producers across multiple regions, bottled by both distilleries and independents, spanning several decades of vintage. The cognitive load of tracking this accurately increases non-linearly with the size of the collection.

A spreadsheet has no mechanism to handle this complexity gracefully. It presents all 100 rows with equal weight, forcing you to impose your own organisation through sorting, filtering, and colour-coding that drifts and breaks over time. A purpose-built tracker organises the data for you, surfaces what matters, and hides what doesn't until you need it.

What a Proper Portfolio Tracker Does Instead

The contrast with a spreadsheet is not subtle. A portfolio tracker built for whisky collectors does the following without manual effort on your part:

• Auto-valuations based on recent auction data. Current market prices for each expression, updated as comparable lots sell. No manual research required.
• Gain and loss per bottle. The difference between what you paid and what the current market says it is worth, expressed clearly and updated automatically.
• Portfolio allocation analytics. Breakdown by distillery, region, age, bottler, and vintage. Know where your collection is concentrated and where it is diversified.
• Shareable portfolio pages. A clean, permanent URL you can share with a buyer, insurer, or fellow collector without exporting anything.
• Mobile access at auctions and retailers. Check what you already own and what comparable bottles have recently sold for, in real time, at the point of decision.

These are table stakes for any serious collector. The technology to deliver them has existed for years in other asset classes. It is now available for whisky.

The Transition Is Easier Than You Think

The most common objection to switching from a spreadsheet is the migration effort. If you have 80 bottles carefully recorded, the thought of re-entering them somewhere else is not appealing.

In practice, the transition is far less painful than it sounds. Most collectors find it takes 30–45 minutes to enter their first ten bottles in DramFolio—after which the search and auto-complete functionality makes each subsequent entry faster. You can start with your most valuable bottles, or your most recently acquired ones, and add the rest over time. The tracker is useful from the first bottle you enter; you do not need to migrate everything at once.

There is no credit card required to start, and the first tier covers collections up to ten bottles for free. Sign up here and you can have your first five bottles tracked with current market valuations in under twenty minutes. The dashboard is ready the moment you add your first entry.

The Bottom Line

A spreadsheet is a hobbyist tool. It is adequate for someone who collects a few bottles a year with no interest in the financial performance of the collection. The moment you start thinking about your whisky as something with real monetary value—something you might eventually sell, insure properly, or use to make future buying decisions—a spreadsheet is not the right tool.

The gap between what you paid and what your collection is worth today is real money. A spreadsheet cannot show you that gap. It cannot help you understand which parts of your collection are performing and which are not. It cannot tell you when a market movement has made one of your bottles significantly more or less valuable than you thought.

The collectors who are managing their whisky seriously have moved on from spreadsheets. The ones still using them are leaving real insight—and real money—on the table.