Anki ↔ Excel Converter

View Source Code on GitHub

Convert Your File

Choose a mode, then drop your file here to convert it instantly. A download prompt will appear as soon as the file is converted.

Drop your file here or click to select

Instructions

This tool helps you move notes between Anki and Excel without manual re-encoding steps and without going through Excel’s Text Import Wizard. Just follow the steps below.

Exporting from Anki (for "Anki to Excel" mode)

  1. In Anki, go to File > Export.
  2. Select "Notes in Plain Text" as the export format.
  3. Select the deck you want to export.
  4. Optionally include tags, HTML, or media references as needed.
  5. Export the deck as a .txt file.

Next, select the "Anki to Excel" option above and then drag and drop your exported .txt file onto the drop zone (or click to select it). As soon as you drop the file, it will be converted automatically and your browser will prompt you to save the new yourfile-excel_ready.csv file. This CSV will open directly in Excel with proper encoding.

Editing in Excel

  1. Open the generated CSV directly in Excel by double-clicking it.
  2. Make your edits. Each column corresponds to a field in your Anki note type.
  3. When finished, just use File > Save or Ctrl+S to preserve UTF-8 encoding with no extra steps required.

Importing Back into Anki (for "Excel to Anki" mode)

  1. Select "Excel to Anki" above.
  2. Upload the edited UTF-8 CSV file in the same manner.
  3. Right after dropping the file, you’ll be prompted to save the new yourfile-anki_ready.txt file. This file is UTF-8 tab-delimited and ready for Anki.
  4. In Anki, go to File > Import and select this file to import your changes.

Credit & Additional Information:

Adapted from the original process: Original Instructions Document

Further details on importing (including handling HTML or media): https://docs.ankiweb.net/importing.html

Note: These instructions assume a modern version of Excel (e.g., Excel 2016 or later, or Microsoft 365) that preserves UTF-8 encoding when simply using File > Save or Ctrl+S.

This tool is a bit experimental, so proceed at your own risk. If your Anki deck suddenly insists on spelling everything backwards, you’re on your own.

Google Analytics is used here purely to satisfy my curiosity about whether anyone is actually using this page.