Skip to content

How to prepare your spreadsheet for import

Web .csv or .xlsx

Name three columns Vintage, Producer and Wine name, and save the file as .csv or .xlsx. Download our template on the upload page has them already.

Spreadsheets are uploaded on the web. In Collection settings → Import data, tap Spreadsheet and we email you the instructions.

An approximation of the iPhone app
Column What goes in it Example
Vintage The year, four digits. For a non-vintage wine write NV or leave it blank 2013
Producer The winemaker Example Estate
Wine name The wine’s name, without the producer Reserve Cabernet Sauvignon

Leaving Size, Quantity or Cellar or fridge name empty is a warning you can carry on from. A value we can’t read is an error you fix in the file.

Column What it accepts If you leave it out
Size The volume, written your way: 750, 750ml, 1.5L, 1,5 l or MAGNUM 1.5L. A bare number under 20 is litres, 20 and up is millilitres. It must be a size we list Every bottle is 750ml
Quantity A whole number from 1 to 1000 Each row is one bottle
Cellar or fridge name A storage you have, spelled exactly the same, or a new name, which creates it. Up to 1000 storages per file Bottles go to a cellar called My Cellar
Wine type Red, White, Rosé, Red Sparkling, White Sparkling, Rosé Sparkling, Fortified, Dessert, Orange, Sake or Distillate No warning, but matching is harder
Grapes The grapes, as text, such as Cabernet Sauvignon, Merlot Matching is harder
Dates

Write dates that can only be read one way, such as 2024-06-12 or Jun 12, 2024. If a date like 03/04/2024 could be either, a Just checking… step asks you to pick the Date format, day first or month first.

Prices and currency
  • Prices are read as numbers. Currency signs are ignored, and a comma or a point works as the decimal.
  • A price without a Currency column is taken in the currency of the collection’s owner. That isn’t yours if you import into someone else’s collection.
  • Mixing currencies? Add a Currency column with a three-letter code, such as EUR, on every row with a price. Leaving it out is a warning. An unknown code is an error.
Bottles you’ve already drunk

Give the row a Removal date. It goes to Past bottles as consumed on that date, instead of into your collection. Leave it blank for bottles you still own.

Bin locations

An import can’t place bottles in 3D. Put your own location in a Custom bottle location column, as text in any format, then place the bottles in VinLocate afterwards.

Re-importing one of our exports? Its Section Name, Row, Column and Depth columns become that text, on rows with no Custom bottle location of their own.

  • New storages are made when you upload. A storage named in the file stays even if you cancel the import.
  • Unusual wines and unusual headings are what slow a file down. The template and the Wine type and Grapes columns speed it up.