Sorry to go off-topic, but:
yogert909 Wrote:Another thing I would love to see is a way to export learning data to excel. The graphs in anki are ok, but there are a few metrics that I would love to be able to analyze myself. So, why not give us access to the raw data in an easily accessible format like xls or csv and let us go to town with it.
I haven't forgotten about this!
Today's mini-project has been an experimental web interface to extract all your review information from your collection.anki Anki database into a CSV file.
Try it out at
http://fasiha.github.io/fuzzy-anki/ using the second set of inputs, titled "View Reviews", to set a couple of options and upload your Anki collection database.
Please note: this is a client-side Javascript application, so you're not uploading your Anki database to anyone (other than yourself...), and your privacy is not at risk.
I recommend putting a limit until you really want to export
everything because for my collection of 12'000 reviews, Chrome took ~30 seconds.
I included the card's underlying facts (its "note") as a JSON string in the last column even though that significantly adds size/noise to the file because with that, you have a complete review database you can import into Python/Excel/whatever (if you insist on not keeping it in Javascript

) and not need anything else from the Anki collection.
The file you download will have a weird name and no extension because I'm using Blobs, since I want this to work for power-users with many more reviews than me. It's just a UTF-encoded CSV file. I expect Mac/Linux to be able to open it automatically in your spreadsheet app, but in Windows/Excel, I found it was insufficient to add a ".csv" extension because Excel wouldn't auto-detect UTF-8 encoding and mess up my kanji. I found I needed to start with an empty sheet, go to Import Text Data, select this file, set it to be "Delimited" mode with the "comma" delimiter, and instruct it to use UTF-8 (65001, near the bottom of its list)---yes, the year is still 2014 Microsoft

.
I wanted to add some visualizations (I made these in Python/Matplotlib last year
https://twitter.com/fasihsignal/status/3...1304741889 and with D3.js one can make way cooler ones) but getting just the CSV going has taken enough of the night.
Sorry I don't have more documentation, I'll update the Github readme and fill things out a bit more with this reviews browser later.
Edited: 2014-08-28, 4:57 am