Cellars and racks

How to take a wine cellar inventory using a spreadsheet

Take a cellar inventory in Excel, Numbers or Google Sheets that stays useful, starting with what each row means and ending with totals that agree.

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.

  1. Write the shelf’s name in the location column, exactly as it’s labelled.
  2. Enter a row for each wine, vintage and size on that shelf, with how many there are.
  3. 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.

A cellar in SmartCellar with each wine’s bottle count, drinking window and rack positions

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.

Take a stocktakeExport your data

Compare SmartCellar with a spreadsheet

Start your cellar. The free plan covers one cellar and up to 50 bottles, and you don’t need a card.

Help from the SmartCellar team

If this guide didn’t cover it, send us a message with your account email and what you were trying to do, and we’ll reply by email.