No Comments

Automatically Translate Vocabulary Lists into Any Language

Posted August 22, 2019 by Nick LaFave under General

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

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

Here’s an example where I translated a word located in cell A2 from English (en) to Spanish (es). =googletranslate(A2,”en”,”es”)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.
Translate into over 100 Languages

You can find the codes for all languages supported by Google Translate in this list:

Original content here is published under these license terms: X License Type:Non-commercial, Attribution, Share AlikeLicense Abstract:You may copy this content, create derivative work from it, and re-publish it for non-commercial purposes, provided you include an overt attribution to the author(s) and the re-publication must itself be under the terms of this license or similar.License URL:’t Miss a Pick – Follow Us
Nick LaFave

Add your Biographical Info and they will appear here.

Interesting essay samples and examples on:

You might also like
Tags: , , ,

More Similar Posts

Leave a Reply

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

Fill out this field
Fill out this field
Please enter a valid email address.
You need to agree with the terms to proceed