How do I import a word list from Excel or CSV?
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 inSpanish ContextandEnglish Context. - Tags: a column called
Tags, with several tags in one cell separated by commas.
Vokabulo ignores any other column.
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
- What is the Words screen for?
- What do the icons on the Words screen do?
- How do I add a new word?
- Why does every word come with a context sentence?
- Can I trust the AI translation?
- How do I edit a word I already saved?
- How do I share words with someone?
- How do I get the words from a blog article?
- How does Vokabulo pronounce my words?
- How do I search my collection, and what happens with duplicates?
- How do I change a lot of words at once?
- What are tags for?
- How do I tag every new word automatically?
- How do I show only the words with a certain tag?
- How do I rename or delete a tag?
- What are usage labels?
- I started typing in the wrong language. Now what?