How to Translate in Excel Using a Formula (Tested Methods)

Quick Answer

On Microsoft 365, use the TRANSLATE function, optionally paired with DETECTLANGUAGE for mixed-language data. There's also a WEBSERVICE-based workaround for older Excel versions, but it's fragile, Windows-only, and not an official translation method — we cover it as advanced and not recommended for most people.

How We Tested These Formula Methods

We tested formula-based translation on a sample workbook of 96 rows in English, Spanish, French, German, Japanese, and Chinese, checking single cells, full columns, auto-detection, and behavior on long text.

Can You Translate Text with an Excel Formula?

Yes. There are two formula-based routes:

1. The TRANSLATE function (with optional DETECTLANGUAGE), built into Microsoft 365, which calls Microsoft's translation service. This is the recommended approach.
2. A WEBSERVICE + FILTERXML workaround for older perpetual-license versions (2019, 2021, and earlier) that don't have TRANSLATE. This is an advanced workaround with real downsides.

Both require an internet connection, since translation happens on an external service. Pick the method that matches your version — and read the warnings on the second one.

Recommended: The TRANSLATE Function (Microsoft 365)

If you're on Microsoft 365, this is by far the easiest and most reliable path. The syntax:

=TRANSLATE(text, [source_language], [target_language])

A working example translating English in A2 to Spanish:

=TRANSLATE(A2, "en", "es")

To auto-detect the source, leave the middle argument empty (keep both commas):

=TRANSLATE(A2, , "es")

Because it's a real formula, you can copy it down a column and every row translates its own text. Language codes are codes in quotes: "en", "es", "fr", "de", and so on. One tested caveat: "zh" for Chinese returned #VALUE! in our Excel for Mac test, while "zh-Hans" or a blank source worked — so if a language errors, try auto-detect.

For Mixed-Language Columns: Add DETECTLANGUAGE

When a column contains more than one language, automatic detection is convenient but not always easy to audit. The DETECTLANGUAGE function lets you see which language Excel detected before you translate:

=DETECTLANGUAGE(A2)

You can then translate with auto-detect into your target language:

=TRANSLATE(A2, , "en")

Both are official Microsoft 365 functions, which makes this combination more dependable than third-party workarounds.

Advanced (Not Recommended): WEBSERVICE + FILTERXML

Older versions of Excel don't have TRANSLATE, but they do have WEBSERVICE (which fetches data from a URL) and FILTERXML (which extracts a value from the response). In principle you can combine them to call an online translation endpoint and pull back the translated text. Many SEO articles present this as a clean trick, but it carries real risks, so we list it as advanced and not recommended for most users.

The general idea:

1. WEBSERVICE sends your text and language pair to a translation URL and retrieves the raw response.
2. FILTERXML parses that response and returns just the translated string.

Why we don't recommend it for most people:

• It's not an official Excel translation method. It relies on third-party or unofficial endpoints that can change format or disappear, breaking your formulas.
• It's Windows-only. Per Microsoft's documentation, WEBSERVICE relies on Windows features and won't return results on Mac, even though it may appear in the Mac function gallery. It's also only available in Excel 2013 and later.
• It's unsuitable for sensitive data. Sending company files, customer data, or private content through an unofficial endpoint is a privacy risk.
• It hits limits. WEBSERVICE returns a #VALUE! error if the result exceeds the cell limit (32,767 characters) or the URL exceeds 2,048 characters, and free endpoints often rate-limit requests.

If you're on an older Excel and translate only occasionally, it may be "good enough" for personal, non-sensitive use. For anything beyond that, the more reliable options are Microsoft 365's TRANSLATE, Google Sheets' GOOGLETRANSLATE, Power Query, or a dedicated translation tool.

Step-by-Step: Building Your Translation Formula

Using the recommended TRANSLATE function:

1. Click the cell where you want the translation.
2. Type =TRANSLATE(.
3. Click the cell containing your source text (e.g., A2).
4. Type a comma, then the source language code in quotes — or leave it blank to auto-detect.
5. Type a comma, then the target language code in quotes, e.g., "es".
6. Close the parenthesis and press Enter.

The cell now shows the translated text and recalculates if the source changes.

Copying the Formula Down a Column

1. Enter the formula in the first row of your output column (say B2, referencing A2).
2. Select that cell.
3. Double-click the fill handle (the small square at the cell's bottom-right corner), or drag it down over your range.

Excel copies the formula to each row, adjusting the reference so every row translates its own entry.

Limitations of Formula-Based Translation

• Internet required. Both methods call an online service.
• Machine translation quality. Fine for everyday text, unreliable for legal, medical, or nuanced content without human review.
• Rate limits and quotas. Large datasets in one session can trigger throttling and silent failures.
• No formatting. Formulas translate plain text only — not charts, images, or cell formatting.

When you need to translate an entire file rather than individual cells, a formula isn't the right tool.

→ See our guide on translating an entire Excel file to English for that scenario.

Frequently Asked Questions

Sources and Update Notes