24 8
Contact Author Sign in to rate

Export in CSV format

<10kB. Updated 2019-01-22.
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 The proper way to import exported csv into Excel on Windows: 1. New file 2. Data tab -> “From Text/csv file”. 3. Choose "Delimited" as "," and encoding as "UTF-8" Last supported version of Anki is 2.1.54. Please use export option "Notes in Plain Text (.txt)". You can import resulted file as a simple tsv file into Spreadsheet. But you have to import the tsv file via "From Text/csv file" option if you use Microsoft Excel. Numbers and Google Sheets import it with no problem. You also have to disable "New import/export handling (beta)" option settings for use in 2.1.54 version of Anki.

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:

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

on 1672744794
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
on 1671127834
CJK Unified Ideographs are not supported. Cannot export as no html version.
on 1643175864
いくつかのタグを単語と一緒に引っ張ってくるので使えない
on 1640316004
Would be useful if it could ignore html
on 1637713541
Plugin worked properly. Thank you.
on 1631370539
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.
on 1628711929
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
on 1625064691
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])
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.
on 1624877242
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
on 1621058485
Simply works!
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 :)