21
1
Export in CSV format
<10kB. Updated 2019-01-22. Only supports Anki 2.1.x.
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.
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.
Reviews
on
Nice！
on
thanks. so useful
on
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.
on
it does what it says!
on
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
on
this add-on is awesome. thanks so much!
on
OK but I miss export media files... :(
on
it isn't working with arabic
can i have helping?
can i have helping?
on
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
Removes the Mental Burden of first converting to notes in plane text then using excel to convert in csv format.
on
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.
on
very handy!
on
Works great. Thank you.
on
Works great. Just remember that this add-on is accessed through the File->Export menu.
on
Very useful, thanks.
Problem with line breaks but thats something one can edit
Problem with line breaks but thats something one can edit
on
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
a very useful add-on,
thank you very much ,
O(∩_∩)O~~
thank you very much ,
O(∩_∩)O~~
on
Chinese OK. excel OK.
on
works perfectly
on
just works :-)
on
Does not work with Chinese characters.
on
It really worked :)