- Home/
- Excel to Anki
Excel to Anki Converter
Drop an Excel .xlsx workbook or a CSV saved from Excel, pick the sheet and columns, and download a ready-to-import Anki deck (.apkg). UTF-8, CP949 (Korean), Shift-JIS (Japanese) and GBK (Chinese) are detected automatically — no more 한글 깨짐. Runs in your browser; nothing is uploaded.
Convert Excel .xlsx or CSV to an Anki .apkg in your browser. Auto-fixes CP949, Shift-JIS and GBK mojibake. Free, private, no signup.
Turn an Excel sheet into an Anki deck
Korean, Japanese and Chinese CSVs from Excel often open as mojibake in Anki. Drop the file here — we detect CP949, Shift-JIS and GBK automatically, so 한글 / かな / 汉字 stay readable.
Students searching “excel to anki” or Korean “안키 엑셀” usually already have a vocabulary sheet. Anki Desktop can import CSV, but Windows Excel often saves Korean, Japanese or Chinese CSVs as CP949, Shift-JIS or GBK — and those files open as mojibake in Anki. This page reads .xlsx directly (no Save As step) and auto-detects those encodings when you drop a CSV.
Pick the worksheet, say which column is the front and which is the back, preview the first cards, then download one .apkg for Anki Desktop, AnkiMobile, AnkiDroid or Guru on iPhone.
How to convert Excel to Anki
- 1Drop an .xlsx file, or a .csv / .tsv exported from Excel or Google Sheets. For .xlsx, choose the worksheet that holds your cards.
- 2Map Front (required) and optionally Back, Extra and Tags. A header row such as “Front, Back” or Korean “단어, 뜻” is recognised automatically.
- 3Check the live preview: the first cards, the note count, and any rows skipped because the front was empty.
- 4Select Build deck and download the .apkg. On a phone, open Files → Downloads, press and hold the deck, then Share → Guru.
- 5In Anki Desktop, double-click the .apkg or use File → Import. AnkiMobile and AnkiDroid import an .apkg opened from Files.
Fix Korean, Japanese and Chinese CSV mojibake
On Korean Windows, Excel’s default “CSV” type is often CP949 (EUC-KR). Japanese installs lean to Shift-JIS; Chinese installs to GBK. Anki expects UTF-8, so those files show 한글 깨짐 / mojibake. This converter sniffs the bytes and decodes with the right table before building the deck — no Notepad “Save as UTF-8” dance.
Prefer keeping the original .xlsx when you can: cells stay Unicode inside the workbook, so sheet mode skips encoding entirely. Use CSV mode when a classmate already sent a locale-encoded export.
- Detected encodings: UTF-8, CP949 (Korean), Shift-JIS (Japanese), GBK (Chinese).
- Google Sheets → Download → Comma-separated values is already UTF-8 and imports cleanly.
- Excel → Save As → “CSV UTF-8 (Comma delimited)” also works; older “CSV” types are what this page repairs.
What the deck contains
- One note per non-empty front row. Cloze text with {{c1::…}} becomes cloze notes; everything else is front/back.
- Tags from a Tags column are split on spaces and commas.
- Images and audio inside the spreadsheet are not packed into the .apkg — text only.
- Limits match the other converters: 10,000 rows, 20 MB, 50 columns.
Privacy: what happens to your file
The workbook or CSV is read entirely in this browser tab (JSZip for .xlsx, TextDecoder for CSV). Building the deck uses the same in-browser SQLite writer as CSV to Anki. Your sheet never leaves the device. An anonymous event records only note and card counts when a deck is built.
Frequently asked questions
Can I convert an Excel .xlsx file to Anki without saving as CSV?
Yes. Drop the .xlsx here, pick the worksheet, map Front and Back, preview, and download an .apkg. No Save As step.
Why do Korean Excel CSVs look broken in Anki?
Korean Excel often saves CSV as CP949, while Anki expects UTF-8. This page detects CP949 (and Shift-JIS / GBK) and decodes the text before building the deck, so Hangul stays readable.
Does this replace Anki’s CSV importer?
Anki Desktop can import UTF-8 CSV directly. Use this page when you have an .xlsx, a locale-encoded CSV, want a preview first, or need one .apkg for Guru or to share.
Is there a size limit?
Up to 10,000 rows, 20 MB and 50 columns per file. Split larger sheets, or import UTF-8 CSV with Anki Desktop.
Is this affiliated with Anki?
No. GuruOwl is an independent tool and is not affiliated with Anki, AnkiMobile, AnkiDroid or AnkiWeb. “Anki” here only describes the file format it reads and writes.
Keep exploring
Turn your PDF into a deck you’ll actually review
Web signup includes 50 credits. Estimated generation: 1 credit/page for Standard or 3 for Expert; check the estimate before confirming. No card required.
