How do I import a word list from Excel or CSV?

Short answer

In Languages (round button, top left), tap Import words and pick a .csv or .xlsx file whose first row names the two languages, for example Spanish and English, or an Anki deck. Import is part of Pro. Duplicates are skipped, and whatever is missing, a translation or the example sentences, is completed by AI.

Where to find it

Round button, top left Languages Import words

Import brings a whole word list in at once. It is part of Pro.

You find it in Languages (round button, top left): Import words. The words go into the language pair that is currently selected.

Preparing the file

Vokabulo reads .csv and .xlsx files, and Anki decks. Only the first sheet of an Excel workbook is read, and a CSV must be saved as UTF-8.

The first row holds the column headers, in any order. Name the two word columns after the languages, like Spanish and English in the example. The name can be in any language (Spanisch, Español) or be the language code (es). Word and Translation work too.

Two more columns are optional:

  • Example sentences: the language name followed by Context, as in Spanish Context and English Context.
  • Tags: a column called Tags, with several tags in one cell separated by commas.

Vokabulo ignores any other column.

Tip

The easiest template is an export. Export a few words from any pair and you get a CSV with exactly the headers Vokabulo expects.

Importing an Anki deck

Export your deck from Anki as an .apkg file and pick it like any other file. Vokabulo matches the fields by itself, and asks in a short Match Anki fields sheet if it cannot tell. The deck’s name and its Anki tags come along as tags. Cloze cards are left out.

Before anything is imported

Vokabulo shows a summary before it saves anything: new words, words you already have, and rows with gaps. You can also give the whole batch one or more tags here, for example "Chapter 5". Tap Import Words to start.

Duplicates

Words you already have are skipped, so it is safe to import the same file again after adding rows to it.

Where the words end up

Imported words start at Level 0, like any new word. If you chose no tag, the batch gets a dated tag such as Imported (260930), so you can find it again.

Rows with a gap

If a row has only one side, the AI fills in the other, like row 5 in the example, along with example sentences if your file had none. The word shows a Translation coming tag until that is done, which needs a connection. The word you supplied may come back slightly corrected, see What the AI changes on its way.

If the AI has nothing after several attempts, the tag changes to Translation Failed and you can finish the word yourself.

A row with both words but no example sentences, like row 6, keeps your words as they are. Vokabulo only adds the sentences.

When the file is rejected

  • No recognizable header row found: the headers don’t name the languages of the selected pair. Check the spelling, or check that the right pair is selected.
  • Failed to read the file: usually a CSV that isn’t UTF-8. Save it again as "CSV UTF-8".

Words