Guides for Cardfox
Anki CSV import and export: moving flashcards between apps
Flashcards you have typed or collected over months are worth keeping, even if you switch apps or devices. The most reliable way to move them is a plain text file where each line is one card: front and back separated by a tab or semicolon, saved as UTF-8. Anki exports exactly this with File > Export > “Notes in Plain Text” and reads it back with File > Import.
This guide explains how CSV and tab-separated files for flashcards are built, how to get your notes out of Anki and a CSV into it, and which small details (separators, quotes, encoding) cause most failed imports.
What a flashcard file looks like
A flashcard export is just a table saved as text. Each line is one card, and a separator character splits the line into columns: front, back, and sometimes tags.
CSV stands for comma-separated values, but in practice “CSV” files also use semicolons or tabs. A tab-separated file is often called TSV and frequently ends in .txt or .tsv. A minimal example with a semicolon as separator looks like the lines below. The first line is an optional header; many apps recognize common column names like Front and Back and skip that line instead of turning it into a card.
- Front;Back
- the dog;der Hund
- to run;laufen
- It’s raining.;Es regnet.
Separators, quotes and line breaks
Problems start when the content itself contains the separator. “to take, took, taken” has two commas, so in a comma-separated file it would be split into three columns. The standard solution is quoting: wrap the field in double quotes, and write a double quote inside a quoted field as two double quotes.
- Tabs are the safest separator for vocabulary, because they almost never appear inside a word or sentence.
- Semicolons are a good second choice for language cards; commas are the most likely to appear inside content.
- Keep it to one card per line unless the field is properly quoted.
| Content | Written in a comma-separated file |
|---|---|
| to take, took, taken | "to take, took, taken" |
| He said "hi" | "He said ""hi""" |
| A field with a line break | The whole field in double quotes, line break included |
Encoding: why umlauts turn into strange characters
Text files store characters as bytes, and the encoding defines how. Today’s standard is UTF-8, which covers every language, from ä and ñ to Japanese and Arabic. If a file was saved in an older encoding such as Windows-1252 and opened as UTF-8 (or the other way around), “Mädchen” can turn into something like “Mädchen”.
When you create a CSV in a spreadsheet, choose the UTF-8 option if there is one. Recent versions of Excel offer “CSV UTF-8 (Comma delimited)” as a separate format from plain “CSV”. Also note that Excel with German regional settings uses semicolons instead of commas in CSV files, which is fine as long as the importing app recognizes the separator.
Exporting plain text from Anki
Anki can export notes as a tab-separated text file. In the desktop version, go to File > Export, pick the deck you want, and choose “Notes in Plain Text” as the format. Depending on your version you will see options such as including HTML and media references or including tags.
Some things to know about this format:
- It exports note fields as text. Images and audio files are not included; at most you get references to them, like [sound:word.mp3].
- Review history and scheduling are not part of a plain text export. In the new app, the cards start as new.
- If your notes have more than two fields (for example word, translation, example sentence), each field becomes its own column.
- Unchecking the HTML option gives cleaner text if your cards contain formatting.
Importing a CSV file into Anki
In the Anki desktop app, choose File > Import and select your .csv or .txt file. The import screen shows a preview and lets you set the field separator, the note type, the deck the cards go into and which column belongs in which field. Check the preview before you confirm: if everything sits in one field, the separator is wrong.
Recent Anki versions also read optional header lines at the top of the file, such as #separator:tab or #deck:Spanish, which preset those options. If a card already exists, the import options let you decide whether Anki updates it, keeps the existing note or adds a duplicate.
Common pitfalls and how to fix them
Most failed imports come down to a handful of causes. If the result looks wrong, check these first.
| Symptom | Likely cause | Fix |
|---|---|---|
| Everything ends up on the front | Separator not recognized | Save as tab- or semicolon-separated, or check the separator setting |
| Cards are split in odd places | Commas or semicolons inside the content | Quote those fields or switch to tabs |
| Umlauts or accents look broken | File isn’t UTF-8 | Re-save as UTF-8 |
| Tags like <b> or appear on cards | HTML in the exported fields | Export without HTML, or clean the text first |
| The header row shows up as a card | Header names not recognized | Delete the first line before importing |
Importing and exporting with Cardfox
Cardfox, a vocabulary flashcard app for iPhone and iPad, can import and export cards as CSV or Anki text files. That means you can bring in a list you prepared in a spreadsheet or exported from Anki, and take your cards with you as a plain file at any time.
After importing, Cardfox schedules the cards with FSRS, a modern spaced repetition algorithm, so they come back just before you would forget them. Because plain text files don’t carry review history, imported cards start fresh there, as they would in any other app.
Bottom line
Two columns, a tab or semicolon as separator, UTF-8 encoding and quotes around anything tricky: that format moves between almost any flashcard tools. Keep an export of your decks now and then, and your work never depends on a single app. If you’re looking for a place to study those cards with spaced repetition, Cardfox reads exactly these files.
Frequently asked questions
How do I import a CSV file into Anki?
In Anki desktop, go to File > Import and pick the file. In the preview, check the separator, note type, deck and which column goes into which field, then import. Save the file as UTF-8 first so accents and umlauts come through.
Can I keep my Anki review history when switching apps?
Not with a plain text export. “Notes in Plain Text” contains the card contents (and optionally tags), not scheduling data, so imported cards start as new.
Should I use commas, semicolons or tabs?
Tabs are the least likely to clash with your content. Semicolons work well for most language cards. Commas are fine if fields containing commas are wrapped in double quotes.
Can I open an Anki export in Excel or Google Sheets?
Yes. The plain text export is tab-separated, so spreadsheet apps can open or import it as a table with one column per field. Choose tab as the separator and UTF-8 as the encoding.
Why does my CSV from Excel use semicolons?
Excel uses the list separator from your regional settings. In many European locales, including German, that is a semicolon, because the comma is the decimal separator.