GOOGLETRANSLATE Function in Google Sheets

Translate text from one language to another using the GOOGLETRANSLATE function.

GOOGLETRANSLATE Function

The GOOGLETRANSLATE function in Google Sheets is used to translate text from one language to another.

Syntax

GOOGLETRANSLATE(text, [source_language], [target_language])
  • text: The text you want to translate. This is a required parameter.
  • source_language: (Optional) The language code of the text. If not provided, Google will auto-detect it.
  • target_language: (Optional) The language code to translate the text into. The default is “en” for English.

Example

  1. Translate Text

Translate “Hola” from Spanish to English:

=GOOGLETRANSLATE("Hola", "es", "en")

This will output “Hello”.

Notes

  • Use ISO 639-1 language codes for the source and target languages.