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:
- https://www.cellartracker.com (unfortunately this site is down right now!) But you can find apps for Android and iOS.
- https://www.uncork.biz/order.aspx
And the rest will be happy with the following template for managing your private wine-cellar 🙂
Preview of the wine-cellar-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 🙂
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.
Can’t wait to use this!
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.
did you ever find one?
Just donated $5 – how do I get the template?
Thanks for your donation.
The download link is in the content below the donate button.
Or use this link:
http://www.excel-template.net/wp-content/uploads/2018/03/wine-cellar-inventory-management.xlsx
same here, donated but couldn’t download after…does it get emailed?
The download-link is at the end of the article in the list after the donation-button.
Here is the direct download
http://www.excel-template.net/wp-content/uploads/2018/03/wine-cellar-inventory-management.xlsx