Anki Chrome

  1. Google Chrome - Download the Fast, Secure Browser from Google Google uses cookies to deliver its services, to personalize ads, and to analyze traffic. You can adjust your privacy controls anytime.
  2. Go to, click Anki Web button, login with your email address and password, click Get Shared Decks decks button in the left bottom corner of the window, then in popular categories click English. Choose from the available decks and click on the name of the deck.

Anki is a great open source flashcard app that can be used to learn anything.

Chromebooks originally couldn't run any local apps: So you had to rely on Ankiweb (see the Anki FAQ here) and 'chrome apps' - but these are is no Anki in this format and these were never full applications as you know them from windows. Around 2016 Chromebooks started to support Android software. So in theory you can run AnkiDroid. Get the best deals for anki vector at We have a great online selection at the lowest prices with Fast & Free shipping on many items! Chrome Anki Quick Adder. This chrome extension provides the ability to create Anki cards directly from Google Chrome on your Anki Desktop. Features x Ability to create Anki cards directly from Google Chrome on your Anki Desktop. x Drop-down with all your tag for auto-complete feature. x create card from chrome Menu Extension icon.

This Gist is a full end to end example of how to:

  • export Anki decks from Anki
  • import Anki decks into MySQL
  • edit Anki decks using MySQL
  • export Anki decks from MySQL
  • import Anki decks back into Anki (including creating new Note Types and Cards)

While this Gist uses Korean language decks as examples, this Gist is not about Korean language decks, but about advanced Anki deck editing applicable to any Anki decks of any domain.


The top two Anki decks for Korean are:

  • Korean Grammar Sentences by Evita ('the Grammar deck')
  • Korean Vocabulary by Evita (the 'Vocab' deck)

While both are excellent, the Vocab deck doesn't have the audio, sentences or notes found in the Grammar deck.

Grammar deck fields:

Vocab deck fields:

This Gist shows how an enriched vocab deck with fields from both decks can be created.

Options for editing Anki decks

The Anki Browser

Anki has a built-in browser that can be used to edit decks. It may be very powerful, but can be difficult to understand and use.


Anki decks have the file ending .anki2 but are really just SQLite files, so they can be edited using any SQLite client. However, SQLite has limited functionality compared to eg MySQL.

Raw text

Anki decks can be exported to tab separated raw text files which can subsequently be imported into more or less anything.

(In Anki) File Export. Notes in plain text. Select the deck to be exported. Export. Select location. Save.

The exported file will have a line for each note, and every line will have a tabs separating the fields. Eg, since the fields of the notes in the Grammar deck are Korean, Translation, Alternative Translation, Audio and Notes, the exported Grammar file looks like this:


MySQL is a great option for editing Anki decks. Installing and setting up MySQL is beyond the scope of this Gist, see

Editing Anki deck using MySQL

Import deck into MySQL

NOTE If you at any point screw up any of the schemas or tables created as part of this Gist, don't worry. The steps in this section are so few you can just drop the schema or table and start over.

In order to import the decks into MySQL, first, a schema must be created.

After logging in to MySQL:

Then, tables for each deck must be created.

NOTE MySQL have different charsets and collations, different combinations of which may or may not be able to handle different languages. If the appropriate charset and collation is not specified, MySQL will default to simpler charsets and collations that are not able to handle eg Korean, which means any Korean imported into such tables will become garbled nonsense characters.

The grammar table will have the same columns as the fields in the grammar deck.

The vocab table will have the same columns as the fields in the vocab deck.

The vocab_full table will have the same columns as the fields in the vocab deck + columns for the fields in the grammar deck.

Now that there is a schema with tables in MySQL, the decks can be imported. (NOTE MySQL will infer the desired table by the import file name)

Anki Chromebook Download

In the terminal:

Now, all the power of MySQL is available to edit the decks.

Enriching the Vocab deck

The basic thing we want to do is pull data from the grammar table into the vocab table. A naive JOIN might look something like this:

The problem with the above JOIN is it will match eg the vocab.english content 'yes' on grammar.translation 'yesterday'. A better JOIN might look something like this:

The above JOIN will respect word endings.

NOTE that there are still many other, potentially much better, JOINs or other operations that could be used to enrich the vocab deck, eg JOINs that use more intelligent text matching than merely single word matching, scripts that that scrape example sentences and audio off Naver or some other source etc. (any suggestions greatly appreciated, please comment!)

However, since even this relatively naive JOIN gives OK results, we will stick to it for now. Run an INSERT: (it will take a while to run, don't worry if it seems like it freezes, it will finish eventually)

NOTE that we're getting just 589 rows out of this join, many rows which are duplicates:

This is fine for my purposes as I care more about exposure to sentences than any individual word.

Remove rows with no audio (Optional)

Turns out there is no need to do this, as there are already no rows without audio.

Export vocab_full to file

Anki Chrome Extension

In the terminal:

Importing deck back into Anki

Add Note Type for new deck

(In Anki) Tools Manage Note Types Add <pick a Clone> OK <new note type name> OK will create a new Note Type. Select <new note type> Fields Add fields such that fields reflect the vocab_full columns (in the same order)

Import new deck

(In Anki) Create Deck <new deck name> Open <new deck>

(In Anki) File Import <select file to be imported> Open will bring up the Import dialogue. Before clicking Import, make sure:

  • the Type is the newly created Note Type
  • the Deck is the newly created Deck
  • the Fields map to each other correctly

then Import.

NOTE While the expected result of the Import is that the notes are imported into the selected Deck, there is a bug in Anki that results in the notes being imported into the 'Default' deck. To fix this

(In Anki) Browse Select the 'Default' deck in the left of the browser Select all the notes Change Deck and move the notes to the desired deck.

Fix cards for new deck

(In Anki) Browse Select the new deck in the right of left browser Cards

Front Template:

Anki Chrome


Back Template:


Phew! The new deck should now be ready to start studying.


  • Since the enriched Vocab deck ended up containing only 589 rows, many of which are duplicates, it would be nice to use other sources than the Grammar deck for enriching, eg a script could be written that scrapes example sentences and audio off Naver or some other source.

  • Other potential improvements? Comment!

Speech to text / Voice input / Dictation for making Anki flashcards

I am a medical student & I will show you how to dictate basic (simple Q & A) Anki flashcards real fast using free tools. You can use any computer with any operating system.

🡺 To use Google’s dictation, you MUST use Chrome browser 🡺 To use Microsoft’s dictation use any browser, any OS, any computer. Don’t buy Office 365. Chromium browser derivatives work best. 🡺 Apple’s dictation can be used only on Apple devices, with ANY spreadsheet software or within Anki app itself. (Use MacOS 10.15 or above for best results)

What you’ll need –

  • 1) A Linux / BSD / Mac / Chromebook / Raspberry Pi / Windows computer. (I recommend Word online + Chromium browser for Raspberry Pi. Some chromebooks support Ankidroid, but you might not be able to import flashcards you dictate (.csv files), without the computer app, not sure though, I don’t have a chromebook. Let me know if it works & I will update the post accordingly.)
  • 2) Microphone, preferably external.
  • 3) A broadband connection. (Connect your computer using LAN cable for faster voice input thanks to low latency, minimal signal attenuation & full duplex nature of wired technology)
  • 4) Install Google Chromebrowser to dictate in google docsOR Install any Chromium derivatives to dictate in Word Online / OneNote (Firefox didn’t work for me. Word online couldn’t access the microphone even when I granted permissions manually. I haven’t tested other browsers) OR Configure keyboard shortcut that activates Mac’s dictation (System Preferences ➜ Keyboard ➜ Dictation ➜ Shortcut)
  • 5) Install LibreOffice / use Google Sheets
  • 6) Install Anki

Let’s make some basic anki flashcards. Basic is the simplest of them all, that’s what I always use & feel comfortable with.

Flashcard Content Creation using Google Docs / Word Online / OneNote Online –

  • 1) Word Processor – Open chrome & open Google DocsOR open any browser (preferably Chromium & it’s derivatives) & open Word Online / OneNote Online with word Online being more practical, I will only talk about it from now on OR open any offline Word Processor (Only Mac users have this choice, Win 10 had a crappy dictation, may have improved)
  • 2) Open a newblank document
  • 3) Click ‘Insert’ & inserta table with 2 columns & as many rows as you like, it doesn’t matter, you’ll know why. Left column is for questions, right for answers. (If you wish to use tags, you’ll need a third column such that column 1 is Questions, 2 is Answers, 3 is Tags. YouTube has videos on more such tips & it’s beyond the scope of this article.)
  • 4) Dictate – Place the cursor in the first cell on the left & press Ctrl+Shift+S or click tools ➜ voice typing on Google sheetsOR Click on Microphone icon on right upper side in Word OnlineOR Use keyboard shortcut that you configured, to activate Mac’s dictation
  • 5) Start speaking, that’s it! Press Tab button to navigate to the adjacent cell, Tab again for next row and so on.
  • 6) When you run out of cells, just press tab & continue as usual. New row of cells will automatically appear upon pressing tab, that’s why the number of rows you initially added doesn’t matter.
  • 7) When you’re done, simply copy the entire table, Ctrl+A & Ctrl+C on Google Sheets / other word processor OR Press Ctrl+A thrice / select entire table with a mouse & Ctrl+C on Word Online.

The LibreOffice Calc / Spreadsheet part –

  1. Open Libreoffice Calc / Google Sheets (avoid excel online, seems no .csv support)
  2. Press Ctrl+V / Paste, content you created in Google Docs / Word Online / OneNote Online will appear here
  3. For Libreoffice, press Ctrl+S, save in .csv format ➜ in the next step don’t change anything, the default character set is UTF-8. Click ok.
  4. For Google Sheets, click File ➜ Download ➜ .csv

The Anki Part –

Anki can import .csv files as flashcards.

  1. Open Anki, click ‘import file’
  2. Import the .csv file that you just created
  3. Choose the card type ‘basic’
  4. Choose the deck / subdeck where you want the newly created cards to go. By default it’s ‘Default’ so change that if necessary.
  5. Click ‘Import’, That’s it!!

Anki Chromebook

Just get a hang of it. It’s super simple & very fast. Don’t be intimidated by the instructions. Text input is the most time consuming part & this method intends to make the process much faster.

If you find this helpful & if you think that your friends might as well love it, you may download & print the QR code below & stick it in your classroom or wherever appropriate.

Anki Chrome Plugin

Please use the contact form below ONLY if you have any ideas or suggestions to improve this method, have found a better method or if there is something that you really can’t figure out. Thanks.