Living in a new country where a different language is spoken is something that I can barely fathom. Doing it as a child just blows my mind. Our schools are often ill-equipped to support these kiddos, but they often do have one powerful tool that can help: compassionate teachers.
One of these compassionate teachers once came to me looking to create a tool to support an ELL (English Language Learner) student. His idea was to organize important English vocabulary words and their translations to the student’s native language into a spreadsheet. After he came to me with this idea, I started exploring options. What I discovered was really exciting! There’s a Google Translate formula in Google Sheets!
Enter a word in one language in a cell, and then use the formula =GoogleTranslate(text, source_language, target_language) in another cell to automagically translate it! You can even drag the fill handle at the bottom of the formula cell down to apply this formula to more than one cell.
This formula appears to work for all languages supported by Google Translate, of which there are more than 100! It even outputs the results with the correct letters and alphabet–not just our ABC English letters. You’ll just need to know the 2-letter code for the language, which you can find in this list.
Check out how to do it in the animation below!