Decide what a row means
Use one row for each combination of wine, vintage, bottle size and location.
For example, four bottles of the 2019 Alberdi in Rack A and two in the fridge need two rows. A half bottle of the same wine needs a third. Keep that rule throughout the sheet so filtering by location shows what’s on each shelf.
Give each row the producer, wine, vintage, size, quantity and location, and what you paid if you know it. Leave a cell blank rather than guessing, because a guessed vintage turns into a puzzle at the next count.
Count one shelf at a time
Finish each rack, shelf or case before starting the next, and read the vintage off every label rather than trusting the case, since mixed cases and topped-up racks are where the surprises are.
- Write the shelf’s name in the location column, exactly as it’s labelled.
- Enter a row for each wine, vintage and size on that shelf, with how many there are.
- Mark the shelf done, on the sheet or with a sticky note on the rack, and move on to the next.
Check the totals
Add up the quantity column and compare it with a rough count of the racks. Then sort by producer and vintage to catch the same wine entered twice, and check whether the repeats are really two places before you delete one.
Finally, try to find three bottles using only the sheet. If one takes more than a minute, the location names need work, and it’s better to find that out now than with guests waiting.

Moving a spreadsheet into SmartCellar
SmartCellar doesn’t import spreadsheets. Use the sheet as a checklist and start with wines bought by the case to enter several bottles at a time. On the website, tick Keep adding after save on Add wine and the form stays open for the next one.
Your plan sets how many bottles your cellars can hold, which is worth checking before you start on a long sheet. Positions can wait until the racks are on the rack map.
Add bottles on the websitePlans and bottle allowancesMap your racks and wine fridges
Stocktakes after that
Once the bottles are in, the next stocktake happens in SmartCellar. Run stocktake on the cellar’s Analytics page lists each wine with the count it expects, and you enter what you find on the shelf.
If you ever want a spreadsheet back, Export my data on the Account tab of Settings gives you your cellars as CSV.