Fix an Anki CSV Import That Shows Only One Field

If the preview shows an entire line in the first column, check the separator before editing the cards. A file with a .csv extension can still contain semicolons.

Worked example

File using semicolons

#separator:semicolon
#html:false
Capital of France?;Paris
Capital of Japan?;Tokyo

What the preview should show

Front: Capital of France?   Back: Paris
Front: Capital of Japan?    Back: Tokyo

Steps

  1. Open the original file in a plain-text editor. Find the character between the question and the answer. Inspect a simple row without punctuation first.
  2. Choose that delimiter in Anki's text import settings or add the appropriate file header.
  3. Map the separated fields to Front and Back. If words still split into extra columns, quote fields containing the delimiter or export again from the sheet.

What to check

  • A tab can look like spaces in an editor. Use a whitespace display or try the visible delimiter in Anki's preview.
  • The browser exporter expects two tab-separated columns. Copy the cells from the sheet if you want to use it.

Check two columns in the Anki exporter

References