# 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.

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: translate.google.com/#el/en/ 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.

Share and Enjoy

### Related posts:

• That’s awesome man! Really loved this idea, because I’m a little lazy to create anki decks!

Completely not related, but let me share something really nice with you

Elementary OS

Creat OSX-like OS, based on linux

thank you!

• Hi, good job 🙂
Do you know, how to add a voice to the cards in the same way?

• Often thought of doing this; thanks for showing me an example.

• @Arvo: I don’t know of an automatic way to add a voice, but you can manually add sounds to Anki cards.

• Arvo, I have looked for this also, and haven’t found much. 🙁 IF you do find a method, let us know here, OK?

• I finally found a good method to at least get the sounds. Now if I could just get Anki to let me import them…does anyone know how to make it work? I get cygwin errors (which is strange considering I don’t have cygwin installed on my computer) when I try.
Here’s the method: