I made an addon to batch import files (Excel, CSV ...)

Anki Add-ons
1

Hi everyone,

I developed an add-on designed to streamline the workflow of importing vocabulary lists from spreadsheets.

Anki Batch Importer - Excel, CSV, TSV https://ankiweb.net/shared/info/1338048367

What it does: This add-on allows you to batch import multiple Excel (.xlsx) or CSV files at once. Instead of importing them into a single deck, it uses the filename to automatically create decks (or subdecks).

Key Features:

  • Native Excel Support (No Dependencies): It supports .xlsx files directly. It uses a custom lightweight parser, so no external libraries (like pandas or openpyxl) are required. It works out of the box.

  • Automated Deck Organization: If you have files like Chapter01.xlsx and Chapter02.xlsx:

    1. Select both files.

    2. Set a “Parent Deck” (e.g., Textbook).

    3. The add-on automatically creates Textbook::Chapter01 and Textbook::Chapter02 and imports the data respectively.

  • Smart Refactoring: If Chapter01 already exists as a standalone deck, the add-on can automatically move (rename) it under the new Parent Deck structure while preserving your study history.

  • Flexible Duplicate Handling: You can check for duplicates based on:

    • First Field (Standard)

    • Specific Field (e.g., an ID column)

    • All Fields (Exact match only)

Download: https://ankiweb.net/shared/info/1338048367

I hope this is useful for those who manage their cards in spreadsheets. Feedback is welcome!