Anki add-on: Anki Excel Sync

Anki Excel Sync GitHub link An addon that lets you add cards and edit them via Excel. It batch syncs all excel files in a directory, and all notes that has specified tags. Creates an excel file per each tag. Note: Supports only .xlsx files. (Microsoft Excel file) Notes cannot have more than two tags with selected super-tag. (Super-tag is the top-most level of hierarchical tags. Super-tag of tag science::physics::var would be science ) If there are formulas in excel files, the formula itself will be seen as values, not computed values. Images put directly into excel files will not be loaded into Anki. Use Anki to put images inside notes. If you delete, rename, or modify a note type, Excel -> Anki will not work until Anki -> Excel runs. Import your edited excel files before changing note type. If you find any bugs, please report them here instead of in the comments. I do not get any notification from the comments. Alternatively, you could message me on reddit u/bluegreenmagick. Setup After downloading the add-on, restart Anki. Edit config set _directory . (Tools > Addon > Anki Excel Sync > Config) The excel files will be written to the directory, and searched from the directory. It is recommended to set it to an empty directory - other excel files in the directory will be deleted. In the directory, make sub-directories with the names, the super-tags of notes you wish to sync. Excel File Format 1st row : Names of note types. <b>2nd row~</b>: note-type-rows. Each row represents one note type. <b>1st column</b>: designator of note type. Can be any sequence of letters. <b>2nd column~</b>: name of fields in note type. *Must be the same as the name of fields of note type in Anki, or it will not work. <b>n+2 row~</b>: note-rows. Each row represents one note. <b>1st column</b>: designator of this note's note type specified in note-type-rows <b>2nd column</b>: value for each fields. *The order must be the same as the order specified in the note-type-row. *You can leave it blank if you want. <b>Last column</b>: note id in Anki. *The addon will automatically fill this cell in, so there is no need to put anything here. If it doesn't exist, creates new note. Obviously, you aren't expected to type all the note type stuff. Intended use is to run 'Anki -> Excel' first, then edit / add notes on it. Credits Thanks to finia2NA for adding compatibility for 2.1.50+

GitHub repository: bluegreenmagick/sync-excel-with-anki
Repository description: Automatically syncs a batch of excel files with Anki
Languages: Python