Wine cellar inventory template you can copy today
A good wine cellar inventory template needs about 18 columns: producer, wine, vintage, quantity, location, status, purchase details, drinking window and notes. Copy the table below into Excel, Google Sheets or Numbers, then read why each column earns its place and when a spreadsheet stops being worth the typing.

The columns to paste into your sheet
One header row, one wine per row (or one bottle per row if prices or locations differ). Keep each detail in its own cell, because a cell that says "Chateau X 2016 Bordeaux 3 btl" cannot be sorted by anything.
| Column | Example entry | Why it exists |
|---|---|---|
| Inventory ID | 0042 | Tells two similar rows apart |
| Producer | Domaine Example | Main sort key |
| Wine / cuvee | Les Vieilles Vignes | The specific bottling |
| Vintage | 2019 or NV | Drives drinking window |
| Country | France | Filter by origin |
| Region / appellation | Chablis | Finer filter |
| Grape | Chardonnay | Search by variety |
| Type | White | Quick filter |
| Bottle size | 750 ml | Magnums count differently |
| Quantity | 3 | Bottles left |
| Location | Rack B, Col 3, Row 4 | Find without moving others |
| Purchase date | 2024-05-12 | Context and age in storage |
| Seller | Local shop | Provenance |
| Purchase price | 28.00 | What you paid, per bottle |
| Estimated value | 35.00 | Separate from price |
| Drink from / Drink by | 2025 / 2030 | Choosing what to open |
| Status | Hold | Hold, ready, consumed, gifted |
| Tasting notes | Tight, citrus, wait | Your palate, not a critic's |
Checklist: identity and location columns
These come first because without them the sheet is a list of names and nothing more.
Identity
- Enter the producer and the cuvee in separate columns, because the same producer often makes several wines and you will want to filter by either.
- Type the vintage as a four-digit year, or NV for non-vintage, so the column sorts cleanly.
- Add country and region (appellation if there is one), since two bottles with the same name can come from different places.
- Record bottle size, because a 375 ml and a 1.5 L of the same wine are not the same row.
Location
- Use a fixed pattern such as Rack B, Column 3, Row 4, because a free-text "bottom left" means nothing six months later.
- Label the physical racks to match the codes before you enter anything; otherwise the sheet and the cellar drift apart on day one.
- Keep a quantity column and change it every time you open a bottle, since quantity is the number that goes stale first.
Checklist: money, status and drinking columns
Money and provenance
- Store purchase price and estimated value in two columns, because what you paid and what a bottle might fetch are different facts and the gap is what you actually want to see.
- Date every value estimate, since a number with no date is just a rumor.
- Note the seller and any receipt reference, so you can trace a bottle if a question comes up later.
- Add a condition note for damaged labels, low fill or seepage, as these affect both drinking and value.
Status and drinking window
- Use a status column with a short fixed list (Hold, Ready, Consumed, Gifted), because a dropdown stops you inventing a new spelling every week.
- Fill Drink from and Drink by as estimates and revise them after you open a bottle from the same case, since windows are guidance, not promises.
- Keep a tasting notes column in your own words; a note about how the wine actually behaved beats a copied score.
Mistakes that wreck a wine cellar spreadsheet
Most broken sheets fail the same way: the entering stops. Here is what to watch for.
- Merging several facts into one cell, which makes filtering impossible.
- Logging purchases but never removals, so the sheet claims you own wine you drank in March.
- Skipping the location column because the cellar is small. It will not stay small.
- Overwriting the purchase price with a newer value, which erases what you paid.
- Never auditing. Once or twice a year, walk the racks with the sheet open and fix the differences.
Freeze the header row, add filters, and use dropdowns for type, country and status. Ten minutes of setup saves a lot of cleanup.
When a spreadsheet stops being worth it
A spreadsheet is fine for a compact cellar, and it is the right pick if you like custom formulas or desktop typing. The trouble is entry. Typing a mixed case of twelve labels is dull, and dull jobs get skipped.
If you are weighing wine inventory spreadsheet vs app, ask how often you add bottles and whether you are ever standing at the rack or the shop shelf with only your phone. A wine tracking app like DiVino lets you photograph a label to get the producer, wine and vintage, then save it with a quantity and a rack, shelf or custom spot. The scan can misread the vintage on similar labels, so check the year on the bottle before saving.
Looking for a wine inventory app on iPhone or iPad? DiVino is in the App Store and needs iOS 18 or later. On Android, you can find this wine cellar app on Google Play. Its Hold, Ready, At peak and Past peak states replace the Drink from and Drink by columns, and the estimated value is guidance, not an appraisal.
Which tool handles which item
| Item | Spreadsheet | App |
|---|---|---|
| Custom formulas and totals | Strong | Limited to built-in fields |
| Adding a bottle | Typed by hand | Label scan, then review |
| Location | Your own codes | Racks, shelves, custom spots |
| Drinking window | You research it | Suggested, with status labels |
| Tasting notes | A text column | Notes journal |
| Updating at the rack | Awkward on a phone | Built for it |
Your own notes and receipts count either way. If you decide to start with a sheet and switch later, moving a collection between apps or from a sheet is easier when your columns were clean. Run both for a short time, then compare bottle counts against the racks before you retire the old file.
People ask how to catalog wine cellar contents without losing a weekend. Start with the sheet above for the structure, then add bottles by scanning if typing becomes the bottleneck.
Frequently asked questions
How do I decode a wine label to fill in my inventory?
Start with the producer name, the wine name or appellation, and the vintage year, since those three identify most bottles. Then note the region, grape or blend if listed, and the alcohol percentage, which can be copied into extra columns.
Should I track the drinking window in a cellar spreadsheet?
Yes, adding columns for the start year and end year of the drinking window lets you sort and filter by what is ready now. Add a status column such as Hold, Ready or Past peak, and review it once a year because estimates change as you taste your bottles.
What columns should a wine cellar inventory template have?
At minimum: producer, wine, vintage, quantity, location and status. Add purchase price, estimated value, drink from, drink by and tasting notes once you want to decide what to open.
Should I use one row per bottle or per wine?
One row per wine with a quantity column works when bottles are identical. Switch to one row per bottle when price, condition or location differs.