My Wine Storage

To import data from an Excel® XLSX file, select "File => Import from Excel® XLSX" from the menu.

You should always make a backup before importing.

Select an Excel XLSX file. Now you see a preview of the Excel® file. Click on continue.

In the next window you can map the fields of the import file to the fields of "My Wine Storage". To do this, drag the fields from the "Import fields" list and drop them on the corresponding field in the "Existing fields" list. If you have accidentally assigned a field incorrectly, you can simply move it back again.

Once you have assigned all the fields, click Next.

Here you see a preview of the Excel file and its assigned fields. If the data is okay, click on "Import data". If not, you can click "back" to return to the last or penultimate window.

One last query before the import.

After the import you will get an overview of the imported data.

When importing from an Excel® XLSX file, the following must be observed.

The following values can be imported for the column "Check minimum quantity":

• ✓
• 1
• true
• wahr
• ja
• yes
• x

The following values can be imported for the "Category" column:

• 1 or Wine white
  
• 2 or Wine red
  
• 3 or Wine rosé
  
• 4 or Sparkling wine red
  
• 5 or Sparkling wine white
  
• 6 or Sparkling wine rosé
  
• 7 or Champagner red
  
• 8 or Champagner white
  
• 9 or Champagner rosé

The following values can be imported for the "Country" column:

• Albania
  
• Algeria
  
• Argentinia
  
• Australia
  
• Austria
  
• Belgium
  
• Bolivia
  
• Brazil
  
• Bulgaria
  
• Canada
  
• Chile
  
• China
  
• Croatia
  
• Czechia
  
• Denmark
  
• Egypt
  
• England
  
• France
  
• Georgia
  
• Germany
  
• Greece
  
• Hungary
  
• Israel
  
• Italy
  
• Lebanon
  
• Libya
  
• Liechtenstein
  
• Luxembourg
  
• Macedonia
  
• Madagascar
  
• Malta
  
• Mexico
  
• Moldova
  
• Morocco
  
• Namibia
  
• Netherlands
  
• Poland
  
• Portugal
  
• Romania
  
• Russia
  
• Slovakia
  
• Slovenia
  
• South Africa
  
• Spain
  
• Sweden
  
• Swiss
  
• Syria
  
• Tansania
  
• Tunisia
  
• Turkey
  
• USA
  
• Ukraine
  
• Uruguay

The following values can be imported for the "Aging" column:

• sweet wine
• medium-dry
• dry
• 0 (corresponds to sweet wine)
• 1 (corresponds to medium-dry)
• 2 (corresponds to dry)

For the column "Bottle is open" the following values can be imported:

• ✓
• 1
• true
• wahr
• ja
• yes
• x

The following values can be imported for the "Rating" column:

• 0
• 1
• 2
• 3
• 4
• 5
• *
• **
• ***
• ****
• *****
• ✭
• ✭✭
• ✭✭✭
• ✭✭✭✭
• ✭✭✭✭✭