21 1
Sign in to rate

Export in CSV format

<10kB. Updated 2019-01-22. Only supports Anki 2.1.x.
The author has shared 1 other item(s).

Description

Anki add-on which adds "Notes in CSV format" option to Export desc dialog. Ported from https://ankiweb.net/shared/info/346589289 to anki 2.1. https://gist.github.com/nillsondg/4c198c4313d3d59c43440eda480d7c34

Download

As add-ons are programs downloaded from the internet, they are potentially 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:

1478130872

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

Reviews

on 1618488600
Nice!
on 1609245093
thanks. so useful
on 1608912341
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.
Comment from author
Your anki deck fields contain html tags. The addon just exports a data as is.
on 1606769224
it does what it says!
on 1604237431
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
on 1603587508
this add-on is awesome. thanks so much!
on 1601708674
OK but I miss export media files... :(
on 1601071354
it isn't working with arabic
can i have helping?
on 1588239998
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.
on 1587155856
Removes the Mental Burden of first converting to notes in plane text then using excel to convert in csv format.
on 1576483283
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",即可正常显示
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.
on 1576462323
very handy!
on 1574625851
Works great. Thank you.
on 1571742911
Works great. Just remember that this add-on is accessed through the File->Export menu.
on 1569336577
Very useful, thanks.
Problem with line breaks but thats something one can edit
on 1566384841
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.)
on 1561193654
a very useful add-on,
thank you very much ,
O(∩_∩)O~~
on 1560175226
Chinese OK. excel OK.
on 1560088976
works perfectly
on 1558781202
just works :-)
on 1557678764
Does not work with Chinese characters.
on 1553438044
It really worked :)