Use case
- You want to maintain the data for a deck in a spreadsheet (so the canonical version is in the spreadsheet, and the data within Anki is a copy). This could include collaborating on a deck in Google Sheets.
- The nature of your data means that Anki’s built-in CSV import requires too many steps or is too error-prone.
Features
- Imports XLSX files directly.
- Auto-matches field names.
- Allows each field to be configured within the spreadsheet as text, HTML or markdown.
Required layout
- The target sheet in the workbook must have “SpreadsheetImportPlus v1” in cell A1.
- The rest of row 1 must be empty.
- Row 2 contains the field names. Name these the same as the field names within Anki to allow auto-matching. The name “_tags” maps to the tags. Anything after the first empty cell will be ignored.
- Row 3 contains the field types: “text” means that HTML characters will be escaped (like when using the built-in CSV import without allowing HTML). “html” means the input will be used as-is. “markdown” means the input will be interpreted as Python-flavored Markdown. HTML tags will be preserved.
- Row 4 must be empty.
- The remaining rows contain the data to import. Any data to the right of the header rows will be ignored. Empty rows will be ignored by Anki’s “empty first field” rule.
Examples can be found in https://github.com/HelenFoster/AnkiSpreadsheetImportPlus/tree/v0.1.0/test
Importing
Always backup your collection before installing an addon that modifies it!
XLSX files can be imported using Anki’s usual import menus. In the import dialog, “Allow HTML in fields” must be checked. The fields can be remapped here, but it would normally make more sense to name them correctly in the spreadsheet.
Please post any questions or feedback to: https://github.com/HelenFoster/AnkiSpreadsheetImportPlus/issues
Version info
Version: 0.2.0 Development repo: https://github.com/HelenFoster/AnkiSpreadsheetImportPlus License: AGPLv3+ ( https://www.gnu.org/licenses/agpl.html ) Includes libraries openpyxl, et_xmlfile, and jdcal.
Liên kết hỗ trợ
- Contact Author
- https://github.com/HelenFoster/AnkiSpreadsheetImpo
- https://github.com/HelenFoster/AnkiSpreadsheetImpo
- https://github.com/HelenFoster/AnkiSpreadsheetImpo
- Contact Author
Reviews (9)
👍 2025-11-08
Works very well, also importing hundreds of lines.
👍 2023-12-16
Works like a charm.
👍 2023-12-09
Import failed. Debugging info: Traceback (most recent call last): File “aqt.importing”, line 351, in importFile File “/Users/XXXXX/Library/Application Support/Anki2/addons21/716643677/spreadsheet.py”, line 80, in open raise Exception(f’No sheet found with A1=“{magic}”’) Exception: No sheet found with A1=“SpreadsheetImportPlus v1”
👍 2023-02-28
genial!
👍 2023-02-12
Extremely good, helped immensely!
👍 2022-01-27
Fantastic, thanks for putting this together. Not being able to do this before was the only thing stopping me from making Anki decks.
👍 2020-10-12
My first time ever commenting on an add-on. Thank you for your amazing work. Seriously, you are a life saver. Be safe!
👍 2020-09-27
works great! thank you. very useful for starting to see the whole picture first before doing anki. esp on learning new material.
👍 2020-05-15
Excellent! My first test with some foreign characters from several languages worked perfectly as far as I can tell.
The ability to import directly from Excel is a life-saver. Has no one thought of this before, or have I missed something?! Thank you.
