Wonderful, it's now time to take all that hard work and use it to jumpstart your collection of wines in Personal Wine Curator!

This guide describes what we need from you to have a successful import for a simple single-worksheet spreadsheet. If you are looking to import a multi-worksheet spreadsheet please contact us via Chat to get started.

We don't like to use general CSV files because they don't respect UTF-8 (the funny looking characters in common wines like Mourvèdre and Châteauneuf-du-Pape). We don't want your wines to get funky characters in them like Ch‰teauneuf-du-Pape 😦 We can accept an Excel file that you prepare for us. Sample file is linked to below.

Wine Name
​Producer
Date Created
Date Modified
Bottle Size
Added By
Alcohol Percentage
Vintage
Type
Body
Varietal
Distinction
Vineyard
Custom ID
Barcode Number
Price
Quantity
Quantity On Order
Location
Value Per Bottle
In Wish List
Drink after year
Drink by year
Notes
Grapes
Region
Sub Region
Country
Wine Maker
Wine Importer
Case Production
My Rating
One Hundred Point Scale Rating
Wine Advocate Rating
Wine Spectator Rating

Download this sample spreadsheet so you can match up your fields with those above:

You will need to match up your field with our field names.

We accept the default Excel date format of 2004-02-12T15:19:21+00:00 but can accept most date formats like 2010-01-23, don't worry about this field we will adjust the format for you as necessary before processing.

Enter your own OR match our options. If you go to add wine in the app and search the bottle size field you can lookup the ones we have built in our system.

The name of the person who added the wine.

Use whole numbers. Also known as ABV.

The year the grapes were all, or primarily, grown and harvested in.
Use four digits (E.g. 2002) or NV for Non-vintage wines.

One of the following: Dessert, Fortified (non-dessert), Red, Rose, Sparkling or White

Only accepted values: Light, Medium or Full

The type of grape primarily used to make the wine. If you go to add wine in the app and search the varietal field you can see which ones we use.

Distinction is a unique concept to Personal Wine Curator that encompasses varietal and region. If you go to add wine in the app and search the distinction field you can lookup the ones we have built in our system. We use the distinction to drive food and wine pairings and also to provide aging potential so you can calculate the optimal drink after and drink by dates. 

Where the grapes were grown.

If you have your own unique way of labeling your wines, use Custom ID and we will store this with your wine for searching.

If you have generated barcodes we will display the barcode for you to print labels. Read more about barcodes and labels equipment we use here.

Please exclude the currency symbol, you can adjust your currency in the settings.

The number of bottles in your cellar.

The number of bottles on order.

The location of your wine, we recommend using Bin numbers for quickly locating your wines but you can enter whatever you want.

Please exclude the currency symbol, you can adjust your currency in the settings.

You "Wish List" is a list of wines that you do not have in your cellar but would like to have in your cellar.
Leave blank for not in wish list OR use "Yes" to mark a wine as on your Wish List.

Maturities are automatically calculated based on Drink after and Drink by dates. We don't allow you to import Maturity. Learn more about Maturities and Drink After / By dates here.

Use four digits (E.g. 2002) OR leave blank.

Use four digits (E.g. 2002) OR leave blank.

General notes on the wine.

Enter the names and optionally the percentage of the grape separated by a comma. E.g. "97% Cabernet Sauvignon, 3% Carmenere" or just "Cabernet Sauvignon, Carmenere"

Maturities are calculated based on Region, Sub Region & Country. For the calculation to work your imported region must match one of our system Regions which you can find in the app by searching the region field when adding a wine.

If you use one of our system regions, you only need to submit a Region column and a Country column. To get the exact region name in our system, just go to add wine in the app and search for it in the region field. You only need to submit the first part that is displayed. So if you search for "Anderson", you'll see "Anderson Valley > California (North Coast) > United States".

You then only need to submit the Region column as Anderson Valley and the Country column as United States. You do not need to submit a Sub Region column.
​
You can alternatively enter your own text but if it doesn't match then we won't be able to calculate maturities.

The person or winery who made the wine.

Often times foreign wineries or producers don't bring the wines into the country, this is left to the importer. Keep track of the Wine Importer using this field.

The numbers of cases produced for this wine OR enter the size according to Wines & Vines chart:

Large 500,000+
Medium 50,000 - 499,999
Small 5,000 - 49,999
Very Small 1,000 - 4,999
Limited Production < 1,000

Enter your personal rating via numbers, text or emoji here.

Your 100 point rating.

50-100 point ratings from a paid bimonthly wine publication: https://www.robertparker.com/articles/the-wine-advocate

100 point ratings. Search for Wine Spectator ratings: http://www.winespectator.com/wineratings

If you have any other questions please click the chat icon to send us a message. 

Thanks for using Personal Wine Curator!