Automatically Translate Vocabulary Lists into Any Language

Translate Any List of Words Instantly in Google Sheets


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

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:

Translate into over 100 Languages

Don't Miss a Pick - Follow Us
Nick LaFave

Add your Biographical Info and they will appear here.