Export in CSV format
<10kB. Updated 2019-01-22. Only supports Anki 2.1.x.
As add-ons are programs downloaded from the internet, they are
malicious. You should only download add-ons you trust.
To download this add-on, please copy and paste the following code
into Anki 2.1:
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
All Anki 2.1.x Add-Ons
thanks. so useful
One question, though - I am getting <div> tags as such after I export:
d<div>CTRL+d</div>,forward half a window
u<div>CTRL+u</div>,backwards half a window
Not a biggie - a quick search and replace would sort it out. I was just wondering what I was doing wrong.
Your anki deck fields contain html tags. The addon just exports a data as is.
it does what it says!
I think it's doing just what it says it will do, so the problem I had with a test probably has to do with the nature of .csv instead of the add-on. When I opened the .csv file as a spreadsheet, the first fields displayed as I expected, each in a different column. However, the middle fields contain varying number of words, and the result is that later fields land in various columns--and instead of being in their own column, sometimes they're in the same column with the contents of a middle field. Maybe you could put something in the description about how to use this to get the notes into a spreadsheet with each field in its own column (if that's possible)?
It's hard to say anything without information about OS and application you use for working with csv. But if you use Excel on Windows I recommend to use import csv option.
1. New file
2. Data tab -> “From Text/csv file”.
3. Choose "Delimited" as "," and encoding as "UTF-8"
Or you have to convert file encoding to UTF-8 BOM
this add-on is awesome. thanks so much!
OK but I miss export media files... :(
it isn't working with arabic
can i have helping?
Excellent! Thank you for making this. Minor issues with export of vowels with umlauts (e.g. Ä -> √Ñ), but this is easy to fix in the exported file with find and replace.
Removes the Mental Burden of first converting to notes in plane text then using excel to convert in csv format.
the default export format is UTF-8, which will make Chinese displayed as garbled in Excel.
1. Change the suffix "CSV" of the exported CSV file to "TXT"
2. Open the txt file with Notepad
3. in Notepad - file - save as - then change code "UTF-8" to "ANSI"
4. Change the suffix from "TXT" to "CSV" , and it will display normally
You can also use Notepad++ on Windows which has option to convert csv file encoding without changing file extension. On MacOS just use Numbers. It works pretty well.
Works great. Thank you.
Works great. Just remember that this add-on is accessed through the File->Export menu.
Very useful, thanks.
Problem with line breaks but thats something one can edit
I works well when exporting notes with Chinese characters! (For people who can not see Chinese characters, please make sure your editor displays csv files in UTF-8 format.)
a very useful add-on,
thank you very much ,
Chinese OK. excel OK.
just works :-)
Does not work with Chinese characters.
It really worked :)