Automatically Translate Vocabulary Lists into Any Language

Translate Any List of Words Instantly in Google Sheets

Google-Translate-Different-Alphabet

More than a great tool for foreign language teachers, it’s a must-have resource for nearly all educators, especially since most of us teach ELL, ESL, ESOL students. Enter words in one column and use a simple formula to translate them to a different language in another column. It will even use the correct letters when translating to languages with different alphabets.

How To Translate a Word

  1. Select the cell where you want the word to appear.
  2. Type the following formula:
    • =googletranslate(original word location,”original language code”,”translated language code”)

Google Translate Formula
Here’s an example where I translated a word located in cell A2 from English (en) to Spanish (es).
=googletranslate(A2,”en”,”es”)


How to Translate Google Sheets


Translate an Entire Column

Thankfully you don’t need to type the formula for each row.

  • Select the cell that contains your formula.
  • Click and drag the blue box (“fill handle”) in the bottom right corner of the cell.
  • Continue dragging the fill handle down to all rows you want to be translated.

Google Translate Formula Bulk Fill

Translate into over 100 Languages

You can find the codes for all languages supported by Google Translate in this list: https://cloud.google.com/translate/docs/languages

Translate into over 100 Languages


Don't Miss a Pick - Follow Us
Facebooktwittergoogle_pluspinterestyoutubeinstagrammail
Nick LaFave

Add your Biographical Info and they will appear here.

Leave a Reply

Your email address will not be published. Required fields are marked *