Export Anki Notes to CSV Without Losing Fields

For a spreadsheet handoff, start with Anki's plain-text note export and inspect its columns. Make a deck package separately when you need to preserve collection features such as media.

Worked example

Expected spreadsheet row

Term,Definition,Tag
café,"coffee, café",lesson-1
Check: the comma inside the definition must stay in the second field.

Steps

  1. In the export dialog, choose the plain-text notes option and select a small deck. Decide whether tags and other optional fields belong in the final CSV.
  2. Inspect the exported text in a plain editor and follow its separator and column declarations when importing into a spreadsheet. Keep the file's UTF-8 encoding.
  3. Save the clean table as CSV. Reopen it in an independent CSV reader and check a record containing a comma and accented text.

What to check

  • A plain-text export may reference media without bundling its binary files. Retain a separate package when the recipient needs working media.
  • Check the exported notes count rather than the cards count if one note generates multiple card faces.

Read the spreadsheet import workflow

References