Practice free

TRANSLATE function

TRANSLATE translates text between languages using an online service and returns the translated text. It needs internet access, and the text leaves your machine, so avoid confidential data.

Example

=TRANSLATE("Hello","en","fr")

Expected result: n/a Not yet checked in desktop Excel

Syntax

TRANSLATE(text, [source_language], [target_language])

Arguments in [square brackets] are optional.

text (required)
The text to translate.
source_language (optional)
Language code of the text; auto-detected if omitted.
target_language (optional)
Language code to translate into; defaults to your system language.

Returns: The translated text.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=TRANSLATE("Hello","en","es") #UNKNOWN_CODE_2051 English to Spanish
=TRANSLATE("Hello","en","zz") #VALUE! Bad language code
=ERROR.TYPE(TRANSLATE("Hello","en","es")) #UNKNOWN_CODE_2051 Which error code
=IFERROR(TRANSLATE("Hello","en","es"),"err") #UNKNOWN_CODE_2051 Caught by IFERROR

Watch out for

  • Needs internet access.
  • The text leaves your machine, so avoid confidential data.

Where it works

Excel
TRANSLATE is only in Excel for Microsoft 365 and Excel for the web. Microsoft 365 only; uses an online service.
Google Sheets
Done with a different function: `GOOGLETRANSLATE`. GOOGLETRANSLATE(text, source, target).

Part of Text functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .