What TRANSLATE does
TRANSLATE sends text to Microsoft Translation Services and returns a translation. Put it beside a source description to keep the original and translated wording together for review.
You can specify both languages or use automatic detection for supported source languages. Language arguments use codes such as "fr" for French and "en" for English. Check Microsoft's supported language table when choosing another code.
Practical examples
Translate a Spanish description into English
Put Caja de cartón reciclado. in A5:
=TRANSLATE(A5,,"en")FormulaThe empty second argument requests source-language detection, while "en" selects English. In Excel for Mac 16.114 (build 16.114.26101123), the service returned Recycled cardboard box. on November 11, 2026. The translation preserves the source meaning; wording and punctuation may vary on later runs.
Specify French when the source is known
Put Sac en coton biologique. in A6:
=TRANSLATE(A6,"fr","en")FormulaThe same test returned Organic cotton bag. Here "fr" tells the service to read the input as French. This is useful when you already know the source language, particularly for short descriptions that might otherwise be ambiguous.
Common mistakes and notes
An omitted target uses the system language
Specify the target explicitly when you want the same intended output language on different computers. Leaving both language arguments out doesn't necessarily request English. The defaults are documented in Microsoft's TRANSLATE reference.
A plausible translation still needs review
Short labels and mixed-language text can be ambiguous. DETECTLANGUAGE can put a detected code in a separate review column, but that code isn't proof that the service understood the intended meaning. Keep the source text nearby.
Service and input errors need different checks
Microsoft expects text input and documents problems with overlong text, non-text inputs, invalid or unsupported language codes, and throttled requests. Numeric inputs don't necessarily produce an error: in the same Excel test, =TRANSLATE(123,"en","fr") returned the text 123. That conversion doesn't make numbers useful language samples. Supply the text you intend to translate.
Check one clear sample before filling a large range, verify the language codes, and retry later if requests are throttled. The function page doesn't state a fixed request quota or maximum character count.
IFERROR can turn an error into a review label after you've inspected the underlying problem. It doesn't verify a translation or make an unavailable service work.
Keep a reviewed snapshot when wording must stay fixed
The function uses a service whose responses can change. For a finished handoff, review the translations and preserve a separate values-only copy with the original text and review date. The formulas remain useful for rerunning future changes.