GOOGLETRANSLATE

Translates text from one language into another.

Sample Usage

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

GOOGLETRANSLATE(A2,B2,C2)

GOOGLETRANSLATE(A2)

Syntax

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.

Examples

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

true
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.

Search
Clear search
Close search
Google apps
Main menu
4950868506039073610
true
Search Help Center
true
true
true
true
true
35
false
false