Wine Cellar Inventory Management

A wine cellar is something very special. Anyone who deals intensively with the subject of wine, whose wine stock will become larger and larger in a short time. Quickly comes the question, how to manage a private wine cellar best?

My research showed that there are three groups of wine lovers and collectors:

  • The old-fashioned collector writing down everything in a pretty book.
  • The old fashioned IT affine who creates an Excel spreadsheet or even Access database and
  • the modern enthusiast with a large collection of wines that relies on professional and expensive software.

Who counts to point 1 can fall back here on a beautiful book.

Modern software is available from these providers:

And the rest will be happy with the following template for managing your private wine-cellar 🙂

Preview of the wine-cellar-inventory with excel

Winecellar-Inventory with Excel
Winecellar-Inventory with Excel

Free download of the excel-winecellar-inventory-list

As usual, these templates are available as xlsx and xltx files as well as zip.

For those who do not want to work with Excel, there is still a PDF to download. This can be opened with the Acrobat Reader and conveniently printed.

If you like my templates, I’m looking forward to a little donation 🙂

8 thoughts on “Wine Cellar Inventory Management”

  1. Can you recommend an excel spreadsheet for tracking the oxygen levels of winemaking vats. It would be used to determine the need for maintenance and ensure that as little nitrogen as possible is used during our winemaking.

  2. I suggest you overlook the largest obstacle: data entry. The optimal wine cellar inventory program/database would have an associated label reader that would allow a cell phone capture of a label to generate a database entry of the year, name, chateau (if there is one), classification (primeur cru, etc), region, and country. In addition, the database optimally would have the # of bottles, color, varietal, cost, and value (these would have to be inputted manually if desired). The program would need to allow for the addition of new “holdings” and the change (especially to zero) of any no longer in the cellar. (Most, I suspect, would like to keep a record of Holding’s once held but now exhausted.) There also might need to be a function for notes and/or personal evaluations.

    So, the “cellar master” of a 700 bottle cellar of perhaps 200 or 250 different wines (my situation) would not face the extreme obstacle of “typing in” this information for each “holding”, a point overlooked by any “Excel” recommendation: most cellars do not start with the intention of growing monsterous, so by the time a need for record keeping becomes apparent the task is too daunting to contemplate, so it’s kicked down the road.

    If you know any such utility as I’ve described, I’d love to buy it.


Leave a Comment