Start with a useful wine cellar inventory template

Download a simple CSV for counting bottles and mapping racks, shelves, fridges and cases before deciding whether a spreadsheet is enough for the collection.

A template is a sensible way to audit a cellar. Begin with the physical facts, use consistent names and keep a safe copy. If the record later needs drinking windows, tasting history or shared upkeep, SmartCellar is ready for the next step.

One cellar and up to 50 bottles, free. No card required.

Download on the App Store

Count the wine that is actually there

Work from the bottles in front of you rather than an old merchant list. Record the producer, wine, vintage, quantity, cellar and exact location first; those fields make the initial audit trustworthy.

  • Use one row for each wine and vintage.
  • Write locations as you would search for them at the rack.
  • Add purchase and drinking-window details only when they are known.

Choose a naming pattern before the list grows

Decide whether locations will read Rack B · Row 3, Fridge · Top shelf or Case 12, then keep that pattern throughout. Consistent producer, cuvée and location names make sorting dependable and reduce duplicate rows.

Know when the template has done its job

A spreadsheet may remain perfectly adequate for a small, stable list. A cellar app becomes more useful when quantities change often, bottles occupy several places, tasting notes live elsewhere or you want to see what is ready to drink without maintaining formulas.

Free standalone resource

Download the wine cellar inventory CSV

The template includes fields for wine identity, bottle count, storage location, purchase details, drinking-window years and private notes. Open it in Excel, Numbers, Google Sheets or another spreadsheet program.

Download the free CSV template

This is a standalone planning template, not an automatic SmartCellar import file. Delete the clearly marked example row before adding your own bottles.

Fields included

  • Producer, wine, vintage, colour, country and region
  • Quantity, cellar and exact storage location
  • Purchase date, merchant and price paid
  • Drinking-window years and private notes

Audit the cellar before moving the record

Whether you keep the CSV or move into SmartCellar, these four steps prevent old quantity and location errors travelling with you.

  1. 1. Keep the old record

    Save an untouched copy before changing names, quantities or formats.

  2. 2. Count one physical section

    Begin with a rack, shelf or case and reconcile the quantity with the bottles in front of you.

  3. 3. Settle on location names

    Use a clear pattern that another person in the household could follow without explanation.

  4. 4. Test the record

    Find one bottle, update its quantity and decide whether the CSV or SmartCellar feels more natural for the remaining collection.

Common questions

What should a wine cellar inventory template include?

Start with producer, wine, vintage, quantity, cellar and exact location. Purchase details, drinking windows and private notes are useful additions when you know them.

Can I import this CSV directly into SmartCellar?

No. It is a standalone audit and planning template rather than an automatic import format. It remains useful for checking quantities and naming locations before entering the cellar.

When is a cellar app better than a spreadsheet?

Consider an app when quantities and locations change frequently, tasting notes sit elsewhere or you want drinking windows, label scans and shared access without maintaining more columns and formulas.