ExcelExcel Microsoft 365+
TRANSLATE function in Excel
Translates a text from one language to another
=TRANSLATE(text, [source language], [target language])TRANSLATE syntax and parameters
Three arguments, one required.
- textstringRequired
- source languagestringOptional
- target languagestringOptional
TRANSLATE examples
Formulas you'll actually reuse.
A German review translated into English:
=TRANSLATE(A2, "de", "en")Auto-detect the source language and translate into Spanish:
=TRANSLATE(A2, , "es")
TRANSLATE in Google Sheets
No direct equivalent — here's the way around.
Try TRANSLATE in the playground
Edit the example — nothing to install.
Preloaded with the TRANSLATE formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Excel gets this done.
- ARRAYTOTEXTReturns an array of text values from any specified rangeTextNo Google Sheets equivalent
- CHARReturns the character specified by the code numberTextGoogle Sheets
- CLEANRemoves all nonprintable characters from textTextGoogle Sheets
- CODEReturns a numeric code for the first character in a text stringTextGoogle Sheets
- CONCATCombines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.TextGoogle Sheets
- CONCATENATEJoins several text items into one text itemTextGoogle Sheets