Quick Navigation

TRANSLATE Function

Excel 2016+, Excel for Microsoft 365

Summary

The Excel TRANSLATE function leverages Microsoft Translator services to convert text from one language to another directly within your spreadsheets. This powerful tool eliminates the need for external translation applications and enables seamless multilingual data processing.

Syntax

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

Parameters

Parameter	Type	Required	Description
text	`Text`	Yes	The text string or cell reference to translate
source_language	`Text`	No	Source language code (optional - auto-detected)
target_language	`Text`	No	Target language code (optional - uses system language)

Using the TRANSLATE Function

TRANSLATE transforms your Excel workflow by providing instant language conversion capabilities. Perfect for international business reports, multilingual customer data, global marketing materials, or any scenario requiring cross-language text processing within spreadsheets.

Common TRANSLATE Examples

Basic English to Spanish Translation

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

Translates English text in A1 to Spanish

Auto-detect Source Language

=TRANSLATE("Bonjour le monde", , "en")

Auto-detects French and translates to English

Default Target Language

=TRANSLATE(B2, "de")

Translates German text in B2 to system default language

Frequently Asked Questions

Excel automatically detects the source language for most common languages. Specify manually for short texts or less common languages.

Use standard 2-letter ISO codes (en=English, es=Spanish, fr=French, de=German). Full list available in Microsoft Translator documentation.

Text length is limited per cell. Reduce content size if you encounter quota errors.

Common Errors and Solutions

Text too long

Cause: Cell contains too many characters

Solution: Shorten text or split into multiple cells

Non-text value

Cause: Cell contains numbers/dates instead of text

Solution: Ensure text argument contains valid text strings

Invalid language code

Cause: Using unsupported or incorrect language codes

Solution: Verify codes against Microsoft Translator supported languages

Quota exceeded

Cause: Daily translation limit reached

Solution: Wait 24 hours or reduce translation volume

Notes

Service-backed function - requires internet connection
Translation quality powered by Microsoft Translator AI
Supported languages may change over time
Best for professional/business translation needs

Compatibility

Available in: Excel 2016, Excel for Microsoft 365

Not available in: Excel 2013 and earlier, Excel Online (limited), Excel for Mac (limited)

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2016+, Excel for Microsoft 365