Answers
How do I import a CSV into Anki?
Anki can import CSV/TSV directly, but a dedicated converter helps when separators, headers, or UTF-8 issues trip you up — and it can emit a ready .apkg.
Steps
- 1.
Prepare two columns
Column A = front, column B = back. Optional header row is fine; remove extra columns you do not want as fields.
- 2.
Save as CSV (UTF-8)
From Excel, Google Sheets, or Numbers, export UTF-8 CSV so accents and CJK characters survive.
- 3.
Upload to CSV to Anki
Drop the file on tools.neurako.com/csv-to-anki and preview mapped fields.
- 4.
Download .apkg
Export the package and import it in Anki, or continue with Open in Neurako.
What carries over
- Front/back (and extra columns you map as fields)
- Not Excel formulas, charts, or cell colors
- Not prior Anki scheduling if this is a new import
Open CSV to Anki
Opens https://tools.neurako.com/csv-to-anki
FAQ
- Can Anki import CSV without this tool?
- Yes — File → Import accepts delimited text. The converter is useful when you want a one-click .apkg or a cleaner preview.
- What about cloze columns?
- Put Anki cloze syntax in the text cells ({{c1::…}}). Confirm the note type after import if you use cloze in Anki Desktop.