How to prepare your spreadsheet for import
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.
On each platform
Section titled “On each platform”Spreadsheets are uploaded on the web. In Collection settings → Import data, tap Spreadsheet and we email you the instructions.
Spreadsheets are uploaded on the web. In Collection and billing → Import data, tap Spreadsheet and we email you the instructions.
Open Import Bottles → Import spreadsheet. The Get Started guide lists every column with an example, and Download our template offers a Google Sheets or an Excel or Numbers version.
When a heading doesn’t match one of our columns, we may match it to a column your file is missing. The warnings step shows each match before anything is imported. Change it in the menu, or click Skip to leave that column out.
Your Column "Cuvée"
We read this as "wine name". Change it below if that's not right.
The three columns you need
Section titled “The three columns you need”| 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 |
The optional columns
Section titled “The optional columns”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, prices and locations
Section titled “Dates, prices and locations”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.
Good to know
Section titled “Good to know”- 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.

