4 0
Contact Author Sign in to rate

Spreadsheet Import Plus

0.25MB. Updated 2022-01-20.
The author has shared 5 other item(s).

Description

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.

Download

As add-ons are programs downloaded from the internet, they are potentially malicious. You should only download add-ons you trust.

Supported Anki versions:

To download this add-on, please copy and paste the following code into Anki 2.1:

716643677

If you were linked to this page from the internet, please open Anki on your computer, go to the Tools menu and then Add-ons>Browse & Install to paste in the code.

All Anki 2.1.x Add-Ons Contact Author

Reviews

on 1643245929
Fantastic, thanks for putting this together. Not being able to do this before was the only thing stopping me from making Anki decks.
on 1602516240
My first time ever commenting on an add-on. Thank you for your amazing work. Seriously, you are a life saver. Be safe!
on 1601191847
works great! thank you. very useful for starting to see the whole picture first before doing anki. esp on learning new material.
on 1589560305
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.