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

  1. Confirm that the original spreadsheet still contains the correct characters. If it has already replaced them with question marks, recover the original values.
  2. Export as UTF-8 text or copy two intact columns into the browser exporter to download a UTF-8 file.
  3. 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.

Check two columns in the Anki exporter

References