Fix Garbled Chinese or Japanese Text in Anki Imports
If you see question marks or groups such as ä½ instead of the original Han characters, compare the sheet and the text file before you change a card template.
Worked example
UTF-8 check with two rows
#separator:tab #html:false 你好 nǐ hǎo — hello (Mandarin) 学校 がっこう — school (Japanese)
Steps
- Confirm that the original spreadsheet still contains the correct characters. If it has already replaced them with question marks, recover the original values.
- Export as UTF-8 text or copy two intact columns into the browser exporter to download a UTF-8 file.
- Reopen the file in a UTF-8 editor and preview it in Anki. Use a known character and its pronunciation as a check.
What to check
- If the preview is correct but a studied card shows missing glyphs, check the card's font and device.
- A TSV separator controls where fields begin. UTF-8 controls how the text bytes are read.