How to Automatically Generate Vocabulary Flashcards with Google Translate and Anki

I learned a great technique from Dale on how to automatically translate lists of vocabulary words with Google Translate. I’ve created a video tutorial of the process and embedded it below.

For best results, I recommend turning the video quality up to the highest setting (720pHD) and watching it full-screen.

Here are the tools mentioned in the video:

An example usage of the Google translate function is: =GoogleTranslate(A1,"it","en") which would translate cell A1 from Italian into English.

Google Translate language codes

Language codes

If you don’t know the language code for a certain language, just go to Google translate and select the two languages you want. Then look at the URL in the language codes will be in the URL. For example, translating Greek to English would give you this URL: which would tell you that the language code for Greek is “el”.

After dragging the Google Translate function down the column, export the file as CSV and import it into Anki or whatever flash card program you use.

If you have any questions, leave a comment below. Don’t forget to follow the new YouTube channel.