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
- 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.
- Choose that delimiter in Anki's text import settings or add the appropriate file header.
- 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.