TRANSLATE Function
Translates text from one language to another.
Category
Text
Available in
Microsoft 365
Returns
Text
Overview
TRANSLATE sends text to Microsoft's translation service and returns it in the language you choose — right in the cell.
Language codes are short: "en" English, "fr" French, "es" Spanish, "de" German, "ja" Japanese. Leave the source out and Excel detects it.
Syntax
=TRANSLATE(text, [source_language], [target_language])
Arguments
| Argument | Required? | What it does |
|---|---|---|
| text | Yes | The text to translate. |
| source_language | Optional | The language code of the original. Leave out to auto-detect. |
| target_language | Optional | The language code to translate into. Defaults to your Office language. |
Examples
Example 1 — Translating feedback to English
Turn non-English feedback into English for the weekly review.
| A | B | |
|---|---|---|
| 1 | Feedback | English |
| 2 | Merci pour la livraison rapide | Thanks for the fast delivery |
| 3 | El pedido llegó tarde | The order arrived late |
=TRANSLATE(A2, , "en") Explain
Example 2 — Product names for a French catalogue
Translate English names into French.
=TRANSLATE(A2, "en", "fr") Explain
Common mistakes
- Machine translation. Check anything customer-facing with a fluent speaker — product names and idioms can come out oddly.
- Results can change. The service improves over time, so a recalculation may give slightly different wording. Paste as values to freeze a translation.
Notes
- Needs Microsoft 365 and an internet connection.
- Related functions: DETECTLANGUAGE.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.