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.

Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Clear search
Close search
Google apps
Main menu