Skip to content
Wine Identifier

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.

Download DiVino on the App StoreGet DiVino on Google Play
Wine cellar inventory template showing bottle details, rack locations, quantities, and drinking windows

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.

ColumnExample entryWhy it exists
Inventory ID0042Tells two similar rows apart
ProducerDomaine ExampleMain sort key
Wine / cuveeLes Vieilles VignesThe specific bottling
Vintage2019 or NVDrives drinking window
CountryFranceFilter by origin
Region / appellationChablisFiner filter
GrapeChardonnaySearch by variety
TypeWhiteQuick filter
Bottle size750 mlMagnums count differently
Quantity3Bottles left
LocationRack B, Col 3, Row 4Find without moving others
Purchase date2024-05-12Context and age in storage
SellerLocal shopProvenance
Purchase price28.00What you paid, per bottle
Estimated value35.00Separate from price
Drink from / Drink by2025 / 2030Choosing what to open
StatusHoldHold, ready, consumed, gifted
Tasting notesTight, citrus, waitYour 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

ItemSpreadsheetApp
Custom formulas and totalsStrongLimited to built-in fields
Adding a bottleTyped by handLabel scan, then review
LocationYour own codesRacks, shelves, custom spots
Drinking windowYou research itSuggested, with status labels
Tasting notesA text columnNotes journal
Updating at the rackAwkward on a phoneBuilt 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.