Anki ↔ Excel Converter

View Source Code on GitHub

Convert Your File

Drop an Anki text export or a spreadsheet CSV here. The tool will detect the file type and download the converted version automatically.

Drop your file here or click to select

File type detected:
Rows converted:
Output filename:
Warnings:

    Instructions

    This tool helps you move notes between Anki and Excel without choosing a mode manually. Export from Anki, edit in Excel, then drop the saved spreadsheet back here when you are done.

    Exporting from Anki

    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 instead of All Decks, unless you intentionally want to edit multiple decks.
    4. Turn on Include unique identifier so re-importing can update the same notes.
    5. Leave Include tags and Include HTML and media references on if you want to preserve them.
    6. Export the deck as a .txt file.

    Next, 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. If you exported with Include unique identifier, do not edit that column.
    4. When finished, just use File > Save or Ctrl+S to preserve UTF-8 encoding with no extra steps required.

    Importing Back into Anki

    1. Upload the edited UTF-8 CSV file in the same manner.
    2. 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.
    3. 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.