Import a CSV file to add vocabulary to a Flexi deck. CSV import is free and supports six text fields. It creates new cards; it does not update existing cards or restore their review history.
Prepare your file
Save the file as CSV in UTF-8 encoding. Use a header row to identify the columns. word is required; the other supported columns are optional.
| Column | What to put in it |
|---|---|
| word | The word or short expression to learn |
| translation | Its translation |
| example | An example sentence |
| definition | A definition |
| pronunciation | A written pronunciation guide |
| partOfSpeech | A supported part-of-speech value |
Use commas, semicolons, or tabs to separate fields. Each row must contain the same number of fields as the header, and every row must have a nonempty word. Header names must be unique. Other columns are ignored.
Example
Copy this into a text file or use the same columns in a spreadsheet, then save it as UTF-8 CSV:
word,translation,example,definition,pronunciation,partOfSpeech
bonjour,hello,Elle dit bonjour.,Salutation utilisée pendant la journée.,/bɔ̃.ʒuʁ/,interjectionYou can leave optional cells blank, or omit their columns entirely. For the simplest file, use just word and translation. Keep commas inside a cell in quotation marks, or let your spreadsheet’s CSV exporter handle them.
Supported partOfSpeech values are noun, properNoun, verb, auxiliary, adjective, adverb, pronoun, determiner, adposition, conjunction, numeral, particle, and interjection. An unrecognized value is skipped rather than used as a new part-of-speech label.
Import on iOS or Android
-
Open the deck that should receive the cards.
-
Select Add card → Import → From CSV file.
-
On Import from CSV, select Choose CSV file and choose your file.
-
Wait for the result, then check the imported cards in the deck.
The file must be no larger than 8 MiB and contain no more than 5,100 cards. To import a larger collection, divide it into smaller files with the same header row.
If the import fails or looks incomplete
Check the file’s encoding, header names, separator, and row lengths. A spreadsheet file such as .xlsx must be exported as CSV; renaming its extension is not enough.
If an import is interrupted or reports an error, inspect the deck before trying again. Some cards may already have been saved. Importing the whole file again can create duplicates.
Compare the reported imported count with your intended rows, and open several cards to check their fields. A successful import does not mean that every optional field is filled.
FAQ
Will this preserve my images or review progress?
No. CSV is for card text. It does not contain images, audio recordings, or review history. For an Anki deck, see Import from Anki.
Can I use this to update existing cards?
No. CSV import adds new cards. Edit an existing card directly instead of importing another copy.
Can I paste a Quizlet link?
No. For Quizlet’s exported terms and definitions, use Import from Quizlet.