Skip to content

How Import Works

OENARI imports your existing collection from any CSV or Excel file — an export from another cellar app, or a spreadsheet you keep yourself. Import is free for every tier, in the apps and on the web at app.oenari.com. This page explains what happens between Select file and Done; the platform-specific pages tell you how to get the file.

Coming from Guide
CellarTracker From CellarTracker — auto-detected, no column mapping
Vivino From Vivino
InVinum, InVintory, Oeni, or anything else From Other Apps
Your own spreadsheet CSV Format & Sample File — download a template

Where to find it

Menu → Import Wines. OENARI also offers import where you are likely to need it: on an empty cellar, and in My Wines before your first import.

1. Upload

Tap Select file and choose a .csv, .xls or .xlsx. OENARI reads the file on your device and tells you how many wines it found. For Excel files, the first sheet is read.

Character encoding is detected automatically — Latin-1 exports (CellarTracker's default) are converted without you doing anything.

2. Preview

A quick check before continuing: the detected format (CellarTracker, CellarTracker consumed, or generic CSV / Excel), the columns found, and a sample from your file. If something looks wrong, choose a different file here.

The file check

For generic files, OENARI looks at the file the way a person would before anything is sent: how many rows have a vintage, and whether the rows look like wines at all.

  • Stopped. A file that is not a cellar list — a printed restaurant menu with price lines (……€), a single column with almost no vintages, or a file where a quarter of the rows or more are headings — is stopped with the reason. The continue button is off, and OENARI suggests exporting from the app or service you use today.
  • Warning. If only a few rows have a vintage, or there are some headings, you see the numbers and can still continue. Wines without a vintage are harder to match correctly.

Section headings such as ESPUMOSOS, Red wines or V I N O S are never imported as wines. CellarTracker files skip the check.

Currency

Choose the purchase currency for the import here. If your file has a currency column, it is respected row by row — the preview says which currencies the file states, and your choice only fills the rows that leave it blank. You can edit the currency per bottle afterwards. Unknown currency codes, negative prices and impossible quantities are cleaned rather than stored.

3. Map Columns

For generic files, OENARI suggests which of your columns is which. It recognises common column names from CellarTracker, Vivino, InVinum and other apps, in several languages — Winery becomes Producer, not the wine name. Check the suggestions and change any that are wrong. Wine name is the only required column; producer and vintage make matching far more accurate. You can map:

Wine name · Producer · Vintage · Color · Country · Region · Subregion · Grape / Varietal · Quantity · Price · Currency · Purchase date · Store / Vendor · Bottle size · Drink from · Drink to · Consumed date · Notes

CellarTracker files skip this step entirely. Rows without a wine name are skipped, and OENARI tells you how many.

Consumed mode

If you map a Consumed date column, the whole file is imported as consumed: bottles are archived with that date, and any notes are saved as draft tasting notes for you to complete.

Numbers and dates

Prices and quantities are read the way people write them: 1 200 kr, €45,50, SEK 4 500:-, 1.234,50 and 2 st all work. Dates can be 2024-03-31, 31.03.2024, 31-03-2024 or 31/03/2024. A value that still cannot be read is left blank — the bottle is imported and you can fill it in afterwards. It no longer stops the import.

Dates with slashes

With slashes, a date where both numbers could be the month is read the US way, month first: 03/04/2024 is 4 March. YYYY-MM-DD is always safe.

Vintages

Non vintage, NV, N.V. and Multi-Vintage are understood as non-vintage. A four-digit year is found even inside text such as Vintage 2018. If the vintage is also written into the wine name — 2015 Tignanello with vintage 2015 — it is taken out of the name.

4. Matching

Each row is compared against the community database of 183,000+ wines. OENARI decides by confidence:

Confidence What happens
Strong Auto-matched — goes straight in.
Uncertain Needs review — OENARI shows its best guess and the alternatives; you decide.
Weak or none Becomes a new wine instead of attaching to the wrong bottle.

Some rows always go to review, even with a high score:

  • Name only. A row with no producer and no vintage needs a near-perfect match to go straight in.
  • Name is the producer. Château Margaux by Château Margaux could be the grand vin or the second wine. When the producer has several likely wines, you choose.

Matching runs in the background. You can leave the screen — it continues, and you can pick up where you left off (see Resume).

5. Review

Three sections:

  • Auto-matched — found with high confidence. Tap any to change or reject.
  • Needs review — similar wines found. Accept the best match, pick another from Other matches, create it as a new wine, or skip the row.
  • New wines — not in the database. They are created for you and go through community moderation before other users see them.

Do several at once: Create all N as new wines handles the whole no-match pile in one tap; Skip all N without a match leaves them out. Rows you have not touched in Needs review are imported with OENARI's best suggestion — the review screen tells you how many.

Tap Import N Wines to write everything to your cellar. Nothing is added until you do. Cancel & discard import throws the whole thing away.

6. Done

The result screen shows what was imported, created, skipped and — if anything failed — which rows and why (invalid number, invalid date, field too long, and so on). Imported bottles land in My Wines without a slot; place them from the cellar grid or leave them unplaced.

Resume

An import that is interrupted — you closed the app, took a call, lost signal — is not lost. Return to Import Wines and you are offered Continue your import with the file name and how far it got. Discard starts fresh.

Import History & Undo

Past imports lists your five most recent imports with counts and errors. For 24 hours after an import, Undo removes what it added:

  • every bottle it added to your cellar, active or consumed;
  • the draft tasting notes a consumed import created, as long as they are still drafts;
  • new wines the import created in the database, as long as moderation has not approved them and nothing else refers to them — no bottle, note, wishlist entry or label photo, yours or anyone's.

Wines that already existed in the database are never affected. After 24 hours the Undo button is gone.

Troubleshooting

"This doesn't look like a cellar list." The file is a menu, a price list or a single column of text. Export your cellar from the app you use today, or build a file from the sample — one row per wine, with a vintage column.

The file fails to parse. Save as CSV (UTF-8 or Latin-1) or Excel (.xlsx). Plain text, PDF and Google Sheets links are not supported — export to CSV first.

Too many wines land in "New wines". Add a producer column, and check that wine names don't contain the bottle size or the producer. See CSV Format.

Consumed dates are wrong or missing. Use YYYY-MM-DD if you can. A consumed date that cannot be read is replaced by the purchase date, or by the day of the import if there is none. Free-text dates like "last Christmas" cannot be read.

Quantities. A quantity of 3 becomes three bottles — OENARI stores every bottle as its own entry. A blank quantity means 1; a quantity of 0 skips the row.

The file is very large. Imports of several thousand rows work, but split the file if you hit a timeout.

Need more help?

Contact support with the platform you're coming from and, if possible, the first few rows of your file. We add platform guides on request.