Translate Language in Google Sheets

In a previous post I discussed Google Sheets’ ability to detect a written language using the DETECTLANGUAGE function. You can also use the GOOGLETRANSLATE function to translate between languages directly in your spreadsheet.

Here’s the syntax:

GOOGLETRANSLATE(text, [source_language, target_language])

The text parameter can be a string literal such as “hello world” or a reference to a spreadsheet range, while the source_language and target_language parameters are the two-character ISO language codes such as es for Spanish.

These two parameters are optional; if omitted, source_language is set to auto, forcing Google Sheets to try to detect the language, while omitting target_language causes translations to be made into the system language in use.

Click image to enlarge

Click image to enlarge

[To see how to translate text in Google Docs, see this post]