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.
| Formula | Excel shows | Case |
|---|---|---|
=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 .