Modified 09 April 2019 by Kate Lagan

Translate text from one language into another with this simple formula in Google Sheets

Whether you’re a student studying a new language or a tourist encountering new words, the Google Translate formula in Google Sheets provides you with an easy access list of what you know, or want to know.

To get started simply enter a word in one language in a cell, and then use the formula =GOOGLETRANSLATE(cell with text, “source language”, “target language”) in another cell to 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.

Here’s an example, translating English words into Spanish: =GOOGLETRANSLATE(A2, “en”,”es”)

This formula works for all languages supported by Google Translate. You’ll just need to know the 2-letter code for the language, which you can find in this list.