16 1
Contact Author Sign in to rate

Anki Excel Sync

1.22MB. Updated 2021-01-28. Only supports Anki 2.1.x.
The author has shared 9 other item(s).

Description

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: Currently does not work with Anki v2.1.25+. 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. 2nd row~: note-type-rows. Each row represents one note type. 1st column: designator of note type. Can be any sequence of letters. 2nd column~: 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. n+2 row~: note-rows. Each row represents one note. 1st column: designator of this note's note type specified in note-type-rows 2nd column: 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. Last column: 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.

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:

1832015432

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 1630367269
This guy is a wizard. This doodad saved my butt.
The instructions above totally worked for me; just make sure that you change the default deck in config to one of your actual decks. Also, to reiterate instructions: after making the destination folder and pointing to it in config, make a folder inside the destination folder for each tag you want the program to make a spreadsheet for.
Thanks a ton, dude!
on 1630161989
Please explain better how to user this.

8/28/2021 still too confusing to use.
on 1624933128
Great add-on while I was using Anki 2.1.25. Now it is no longer compatible with newer Anki versions (2.1.44). When I use it now, I get the following:

Anki 2.1.44 (b2b3275f) Python 3.8.6 Qt 5.14.2 PyQt 5.14.2
Platform: Mac 10.16
Flags: frz=True ao=True sv=2
Add-ons, last update check: 2021-06-27 23:51:54
Add-ons possibly involved: ⁨Anki Excel Sync⁩

I hope it gets updated one day as it is an extremely useful tool!
on 1619901135
great, it took my time to understand how to use it, but once i get it, it saved lots of time.
one of my favourite add ons.
on 1607529578
Please make available for Version 2.1.35...
Comment from author
Works now!
on 1597707957
Works great!!!
on 1589107534
Круто, надеюсь, сработает
on 1587849019
Seems great so far! I'm looking at writing a python script to add some audio file names to notes via excel, and this is the exact thing I needed as the inbetween :)
on 1587812910
Looks great, but got a little problem.
Import Anki -> Excel works fine. But using Excel -> Anki shows an error
raise Exception("ERROR: No deck exists with name %s"%decknm)
Exception: ERROR: No deck exists with name default

I'm using this configuration. What is my mistake? Help is greatly appreciated..

{
"_directory": "D:\\Anki_Excel",
"autosync_on_close": false,
"autosync_on_launch": false,
"col-width": [
6,
60,
60,
20
],
"detailed-log": true,
"log": true,
"new-deck": "default"
}
Comment from author
Looks like you don't have any deck named 'default'. Perhaps change that to "Default"?
on 1587216141
Super! Thanks a lot! For users, go to "https://github.com/BlueGreenMagick/sync-excel-with-anki/blob/master/screenshot/excel%20format.png" since the explanations are more clear to configure it (especially for the folders to create)
on 1584847773
This add on is great, it saves me a lot of time in card making, and one optimization suggestion is, can you specify which deck to put each note in the Excel ? Because now I could just put all my notes into the default deck, and then open the browser to manually change some of my notes into the another deck. Because in Anki, different decks correspond to different decks options. So I think it's important to add this . I hope it's admissible. Thank you.
on 1584628421
workflow porn <3
on 1584083055
There were times when it worked a little differently than I expected, but it's very convenient once I get used to using it.
on 1577595773
So far so good - works well.

Important tip: create a new directory to use as the target for this sync app. If your first Anki -> Excel sync is to an existing directory that already contains other non-related files, the app will remove all of those files (including recursively from any subdirectories) without prompting or warning, and without using the system Recycle Bin. I had about a thousand work-in-progress photoshop, premiere, and python files purged out of my "D://Working" directory, much to my unpleasant surprise. A weekly system backup meant I only lost a few days of work, but best to avoid that pain entirely.

Apart from that, seems like a huge time saver!
Comment from author
Sorry for that! V1.1 added a confirmation window before deleting other excel files.

Glad you find the add-on useful.
on 1576253010
Haven't tried. but great idea. Could use it with google sheet or not?
Comment from author
Only .xlsx files can be used. You will need to download google sheet in excel file.
on 1574361140
havent got the time to try it, but the concept is too dope
on 1571368292
thank you