Back to functions
Text2026-11-111 related article

TRANSLATE Function in Excel

Translate text into a chosen language using Microsoft Translation Services.

Syntax

TRANSLATE(text, [source_language], [target_language])
Table of Contents

Arguments

text

Required

The text or reference to a cell containing text to translate.

source_language

Optional

The source language code. If omitted, automatic detection is used for supported source languages.

target_language

Optional

The target language code. If omitted, the system language is used.

What it returns

Returns translated text from Microsoft Translation Services.

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")
Formula

The 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")
Formula

The 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.

Related functions

Related articles

Deep dives, troubleshooting guides, and practical examples that use TRANSLATE.

Official documentation