import data from anki deck

[schapira]

Is there a way to import my already exist anki deck?

[Zelo-S]

Lol I was wondering the same too. So I wrote a bit of a python script to read stuff using Pandas, and tried to write to sheets using the pygsheets thing, but it seems that updating even a small batch of terms for a single column doesn't give any output. You could consider generating something like this using python:

=JOIN("","ài",CHAR(10),"---",CHAR(10),"love")

and then pasting into Google Sheets to automatically format for both Google Sheets(recognizes CHAR(10)) as new line, and the Ulangi script will recognize the "---" as a new definition.
It's very janky, but worth a try. If anyone would request, lest the developer is already working on this functionality, I might give it a try to write a full out utility function.

*edit: I think one problem is that Anki flashcard sets really are wide and varied in terms of formatting. You'll likely need a separate application by itself to properly process the definitions of Front and Back...

[matthewhilton]

I've come across the same issue, I've got anki decks from Deckmill https://deckmill.com/

Turns out .apkg files are just a zip of a SQlite database along with the media files. So far I can easily read the SQLite database and then output the data to copy and paste into the Google sheets sync, but not sure if its possible to sync the audio yet (Maybe the Ulangi devs have some pointers as I think it might need a bit of work on the sheets sync to sync audio as well)

Currently its just a python script but I think I will turn it into a small react app and host it on vercel so you can do it easily from web, mobile, etc...

[matthewhilton]

Update - have written a small webapp to read the anki decks (.apkg) and display the original / translation for copying. You can then copy this into the google sheet to sync to Ulangi

App is here: https://ulangi-anki-import.vercel.app/
Source is here: https://github.com/matthewhilton/UlangiAnkiImport