Excel's TRANSLATE Function: How to Convert Text Across 100+ Languages in Your Spreadsheet

Before 2025, translating text in Excel meant copying cells into Google Translate, pasting results back, and repeating that process for every row. For a 200-row product catalog, that's roughly 90 minutes of copy-paste work.

Excel's TRANSLATE function handles that same catalog in about 3 seconds.

How the TRANSLATE Function Works

Microsoft added TRANSLATE and its companion function DETECTLANGUAGE to Excel 365 in late 2024, with general availability in early 2025. Both functions use Microsoft Translation Services (the same engine behind Bing Translate and Microsoft Translator) and require an internet connection to work.

The syntax is straightforward:

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

Parameters:

• text (required): The cell reference or text string you want to translate
• source_language (optional): Two-letter language code like "en" for English or "ja" for Japanese. If you leave this blank, Excel auto-detects the language
• target_language (optional): Two-letter language code for the output language. If omitted, Excel translates to your system's display language

Basic examples:

• =TRANSLATE(A2, "en", "es") translates English text to Spanish
• =TRANSLATE(A2, "de", "en") translates German text to English
• =TRANSLATE(A2, , "fr") auto-detects the source language, translates to French
• =TRANSLATE("Hello world", "en", "pt") translates a literal string to Portuguese

Common Language Codes

Here are the codes you'll use most often:

Excel supports over 100 languages through Microsoft Translation Services. For the complete list, check Microsoft's Translator language support documentation.

The DETECTLANGUAGE Companion Function

DETECTLANGUAGE identifies what language a cell contains:

=DETECTLANGUAGE(text)

It returns a language code like "en", "es", or "ja". This is useful when you're working with datasets where text comes in multiple languages and you need to sort, filter, or route translations accordingly.

Practical combo: Use DETECTLANGUAGE in column B to identify languages, then use TRANSLATE in column C to convert everything to one standard language.

5 Practical Use Cases

1. Translating Product Descriptions for International Listings

E-commerce teams managing listings across multiple marketplaces can translate product titles and descriptions directly in their master spreadsheet.

Setup:

• Column A: Original product description (English)
• Column B: =TRANSLATE(A2, "en", "es") for Spanish marketplace
• Column C: =TRANSLATE(A2, "en", "de") for German marketplace
• Column D: =TRANSLATE(A2, "en", "fr") for French marketplace

One formula per column, dragged down. A 500-product catalog gets translated into three languages in under a minute.

Important caveat: Machine translation works well for straightforward product descriptions. For marketing copy, brand taglines, or anything requiring cultural nuance, treat the TRANSLATE output as a first draft and have a native speaker review it.

2. Processing Multilingual Customer Feedback

Support teams receiving feedback in multiple languages can standardize everything into one language for analysis.

Setup:

• Column A: Raw customer feedback (mixed languages)
• Column B: =DETECTLANGUAGE(A2) to identify the source language
• Column C: =TRANSLATE(A2, , "en") to translate everything to English

This lets you run text analysis, keyword extraction, and sentiment review on the entire dataset without manual translation.

3. Building Multilingual Reports for Global Teams

Finance or operations teams distributing reports to offices in different countries can add translated summary rows or create parallel columns.

Example: A quarterly performance summary with key metrics in English alongside translations for the Tokyo office (=TRANSLATE(A2, "en", "ja")) and the Sao Paulo office (=TRANSLATE(A2, "en", "pt")).

4. Cleaning Imported Datasets with Mixed Languages

When you merge data from multiple regional sources, you often end up with a mix of English, Spanish, German, and other languages in the same column. DETECTLANGUAGE helps you identify which rows need translation, and TRANSLATE standardizes them.

Workflow:

1. Add a helper column: =DETECTLANGUAGE(A2)
2. Filter for rows that aren't in your target language
3. Translate only those rows: =IF(DETECTLANGUAGE(A2)<>"en", TRANSLATE(A2, , "en"), A2)

This formula checks if the text is already English. If it is, it keeps the original. If not, it translates.

5. Quick Reference Glossaries for International Projects

Project managers working across borders can build term glossaries directly in Excel. List your key terms in column A, then add columns for each language your team uses. One formula per column handles the entire glossary.

Performance and Limitations

What works well:

• Short to medium text (product names, descriptions, feedback comments)
• Common language pairs (English to/from Spanish, French, German, etc.)
• Straightforward factual content

What to watch for:

• Internet required: TRANSLATE calls Microsoft's cloud service. No connection means #VALUE! errors
• Rate limits: Translating thousands of cells simultaneously may cause temporary slowdowns. Process in batches of 200-500 rows
• Accuracy varies by language pair: Translations between major languages (English, Spanish, French, German) are strong. Less common language pairs may produce rougher results
• No formatting preservation: TRANSLATE returns plain text. Bold, italic, or other formatting from the source cell isn't carried over
• Excel 365 only: This function doesn't exist in Excel 2021, 2019, or earlier

Combining TRANSLATE with Other Excel Features

With CONCATENATE or TEXTJOIN: Build bilingual labels: =A2 & " / " & TRANSLATE(A2, "en", "es")

With conditional formatting: Highlight cells where the detected language doesn't match your expected language to catch data entry errors.

With Power Query: Use TRANSLATE on imported data before loading it into your data model. This is especially useful for datasets pulled from international APIs or web sources.

For AI-powered approaches to data automation in spreadsheets, including how Copilot Agent Mode can handle translation workflows as part of larger tasks, check out our guide to Excel's Agent Mode.

If you're interested in how AI tools beyond Excel handle language and translation tasks, How Do I Use AI covers the broader landscape of AI-powered productivity tools.

Getting Started Today

The fastest way to test TRANSLATE:

1. Open Excel 365 (web or desktop)
2. Type a sentence in cell A1
3. In cell B1, enter =TRANSLATE(A1, , "es")
4. Press Enter

If you see the Spanish translation appear, you're set. If you get a #NAME? error, your Excel version doesn't support TRANSLATE yet. Check for updates or switch to Excel for the web, which gets new functions first.

Start with a small dataset. Translate 10-20 rows, verify the quality, then scale. For business-critical translations, always have a native speaker review the output before publishing or sending to clients.