© Copyright 1999 by Bob Ross. All rights reserved.
While there's plenty of sophisticated wine-cellar and wine-inventory software around, many wine fanciers find that a simple spreadsheet or database setup is ample for the basic purpose of keeping track of a modest to mid-size wine collection.
Now we have a fine example for your free non-commercial use, and many thanks to my friend Robert C. Ross -- who devised this spreadsheet for his own collection -- for making it available to the wine-loving public. Read Bob's summary; then click either of the links at the bottom of the page to download your choice of the Excel version or a plain-text, tab-delimited version that should be importable into any spreadsheet or database program.
By BOB ROSS
Generally, the columns in the database are adapted from those used in the Parker database. The first two columns identify each location in the racks, under a system suggested by Hugh Johnson: it makes maximum use of all space available. It is sometimes odd to see what ends up next to each other from time to time - a $10 Chilean wine next to a prized Cheval Blanc, for example, but it works for me.
I print the whole thing out; cross off bottles consumed on the print out each time we take out a bottle; when the floor is too crowded or I get a neatness attack, I re-stock the empty spaces and fill in the database with the new information. Then make a new printout until the next time.
One limitation with this system is the number of columns one can sort on. If I were willing to do it over, I would use a database manager like Access. But this has worked really well for me for over five years, and I'd rather learn about wine than re-code or learn to re-format for another system.
A = Row
Things I don't use: Bottle Size - most to my stuff is 750 mm; those that aren't 750 mm are obvious for all the purposes I care about.
I don't keep track of wine consumed; I keep a wine diary for that purpose. When wine goes out, I just blank out the spaces after A and B, which indicates location, and then fill in the new information when I re-stock that space.
And now, click either link below to download a copy: