Export in CSV format
<10kB. Updated 2019-01-22.
The author has shared 1 other
item(s).
Description
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:
- 2.1.0-2.1.54 (Updated 2019-01-22)
To download this add-on, please copy and paste the following code into Anki 2.1:
1478130872
If you were linked to this page from the internet, please open Anki on your computer, go to the Tools->Add-ons menu item, then click on Get Add-ons and paste in the code.
All Anki 2.1.x Add-Ons Contact Author
Reviews

Thank you for the add on.
It worked until a few days ago, but now the option of exporting in the menu does not appear. Only the default options are shown.
Versión 2.1.55 (01caec2a)
Python 3.10.8 Qt 6.4.1 PyQt 6.4.0
It worked until a few days ago, but now the option of exporting in the menu does not appear. Only the default options are shown.
Versión 2.1.55 (01caec2a)
Python 3.10.8 Qt 6.4.1 PyQt 6.4.0

CJK Unified Ideographs are not supported. Cannot export as no html version.

いくつかのタグを単語と一緒に引っ張ってくるので使えない

Would be useful if it could ignore html

Plugin worked properly. Thank you.

Does not handle unicode characters correctly. I saw the same problems as others. It's fine with ASCII but if you've got anything not ASCII this will not work.

Instead of exporting to different columns, it exports everything in a single column.
Also, it can't export Portuguese characters, such as: à; ã; ó; ...
(I wanted to contact the author instead of leaving this review, but I couldn't find how...)
Anki 2.1.45
Windows 10
Also, it can't export Portuguese characters, such as: à; ã; ó; ...
(I wanted to contact the author instead of leaving this review, but I couldn't find how...)
Anki 2.1.45
Windows 10

Cant install. throws error with importing or double click..
Anki 2.1.44 (b2b3275f) Python 3.8.6 Qt 5.14.2 PyQt 5.14.2
Platform: Windows 10
Flags: frz=True ao=False sv=2
Add-ons, last update check: 2021-06-29 18:33:20
===Add-ons (active)===
(add-on provided name [Add-on folder, installed at, version, is config changed])
===IDs of active AnkiWeb add-ons===
===Add-ons (inactive)===
(add-on provided name [Add-on folder, installed at, version, is config changed])
Anki 2.1.44 (b2b3275f) Python 3.8.6 Qt 5.14.2 PyQt 5.14.2
Platform: Windows 10
Flags: frz=True ao=False sv=2
Add-ons, last update check: 2021-06-29 18:33:20
===Add-ons (active)===
(add-on provided name [Add-on folder, installed at, version, is config changed])
===IDs of active AnkiWeb add-ons===
===Add-ons (inactive)===
(add-on provided name [Add-on folder, installed at, version, is config changed])
Comment from author
I've just checked addon on Anki 2.1.44 at Windows and it works pretty well. Please provide more useful information. Like Anki log or exception description.

Works great, unfortunately something adds quotes " to my <img src="xxx.jpg">, creating "<img src=""xxx.jpg"">". The bug multiplies itself, creating further instances up to """<img src=""""xxx.jpg"" ""="""">""" so something seems buggy with exporting the <img> html tag. Could be Anki, could be the plugin, idk
Comment from author
This is normal behaviour described in csv specification RFC 4180
https://en.wikipedia.org/wiki/Comma-separated_values
> If double-quotes are used to enclose fields, then a double-quote in a field must be represented by two double-quote characters.
Excel or Numbers can import it without any problems
https://en.wikipedia.org/wiki/Comma-separated_values
> If double-quotes are used to enclose fields, then a double-quote in a field must be represented by two double-quote characters.
Excel or Numbers can import it without any problems

Simply works!

Nice!

thanks. so useful

Awesome add-on.
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
Any ideas?
Not a biggie - a quick search and replace would sort it out. I was just wondering what I was doing wrong.
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
Any ideas?
Not a biggie - a quick search and replace would sort it out. I was just wondering what I was doing wrong.
Comment from author
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)?
Comment from author
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
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?
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.
Temporary solution:
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
默认导出的CSV编码格式是UTF-8,用EXCEL打开它会,中文会显示为乱码。
临时解决办法:
1. 把导出的CSV文件后缀"csv"改为"txt"
2. 用记事本打开这个TXT文件
3. 记事本-文件(左上角)-另存为-把编码"UTF-8"改为"ANSI"
4. 再把后缀从"TXT"改为"CSV",即可正常显示
Temporary solution:
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
默认导出的CSV编码格式是UTF-8,用EXCEL打开它会,中文会显示为乱码。
临时解决办法:
1. 把导出的CSV文件后缀"csv"改为"txt"
2. 用记事本打开这个TXT文件
3. 记事本-文件(左上角)-另存为-把编码"UTF-8"改为"ANSI"
4. 再把后缀从"TXT"改为"CSV",即可正常显示
Comment from author
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.

very handy!

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
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 ,
O(∩_∩)O~~
thank you very much ,
O(∩_∩)O~~

Chinese OK. excel OK.

works perfectly

just works :-)

Does not work with Chinese characters.

It really worked :)