Clear search
Close search
Google apps
Main menu


Translates text from one language into another.

Sample Usage

GOOGLETRANSLATE("Hello World","en","es")




GOOGLETRANSLATE(text, [source_language, target_language])

  • text - The text to translate.

    • The value for text must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.
  • source_language - [ OPTIONAL - "auto" by default ] - The two-letter language code of the source language, e.g. "en" for English or "ko" for Korean, or "auto" to auto-detect the language.

    • If source_language is omitted, target_language must also be omitted.
  • target_language - [ OPTIONAL - system language by default ] - The two-letter language code of the target language, e.g. "en" for English or "ja" for Japanese.

See Also

DETECTLANGUAGE: Identifies the language used in text within the specified range.


Translates text in the specified range from the source language into the target language.

Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.

Was this article helpful?
How can we improve it?