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

ArgumentRequired?What it does
textYesThe text to translate.
source_languageOptionalThe language code of the original. Leave out to auto-detect.
target_languageOptionalThe 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.

AB
1FeedbackEnglish
2Merci pour la livraison rapideThanks for the fast delivery
3El pedido llegó tardeThe order arrived late
B2: =TRANSLATE(A2, , "en"), filled down — results from Excel for Microsoft 365
=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.
Kyle Stott

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.