Skip to content
Wine Cellar Inventory cover: a sample sheet with bottles in the cellar, labels and value at cost and a column chart, beside the Dashboard, Bottles and Log tabs

Wine Cellar Inventory

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

Home collectors and small restaurant cellars use this workbook to record each wine label with its code, colour, country, vintage, number of bottles, drink-from and drink-by years and the price paid. The Bottles tab works out the value at cost and a Window status of Hold, Drink now or Past best. The Log tab records bottles bought, opened, given away or sold. The Dashboard adds totals by colour, by drink window and by reason.

Enter each movement on the Log tab the same day, then correct the Bottles column so both tabs agree. Drink windows are general guides, so check the producer's note or ask a wine merchant before you choose a bottle for a particular occasion. If you want the value to match what you spent, include duties, shipping and storage costs in the Paid each figure.

Useful for

  • Tracking a home collection by vintage and drink window
  • Choosing which bottles to open for a dinner or event
  • Valuing a cellar at cost for insurance records

What's included

  • 4 tabs: Dashboard, Bottles, Log, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Bottles: a table
  • Log: a table
  • 3 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Bottles tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I work out a wine's drink window?

Use the producer's advice where it is printed, or a wine merchant's guidance for that vintage. Enter the first year to drink in Drink from and the last good year in Drink by. The Window column updates each year on its own, so you never have to edit it.

Why does the Window column stay blank?

The column stays blank while the Bottles cell is empty. Enter the number of bottles and the status appears. A label with zero bottles shows Empty, and that label drops out of the drink window chart.

Can I track bottles kept in more than one place?

Add a Location column to the Bottles tab, or keep one workbook per storage area. Keep one master total either way, so the Dashboard figures match the real count.

  • #inventory
  • #wine-cellar-inventory
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More inventory templates

See all 19

Also in Business operations

All business operations templates
Get this template

Preparing your template…