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.
[To see how to translate text in Google Docs, see this post]