What Is the GOOGLETRANSLATE Function?
GOOGLETRANSLATE translates text from one language to another directly inside a Google Sheets cell, powered by Google Translate. You provide the text (or a cell reference), specify the source and target languages, and the translated result appears instantly. It is remarkably useful for localizing product descriptions, translating survey responses, or working with multilingual datasets without leaving your spreadsheet.
Syntax
=GOOGLETRANSLATE(text, [source_language], [target_language])
| Parameter | Description |
|---|---|
| text | The text to translate, or a cell reference containing the text. |
| source_language | Optional. Two-letter language code of the original text (e.g., "en" for English). Use "auto" to detect automatically. Defaults to "auto". |
| target_language | Optional. Two-letter language code for the output language. Defaults to the spreadsheet's locale language. |
Language codes follow the ISO 639-1 standard: "en" (English), "es" (Spanish), "fr" (French), "de" (German), "ja" (Japanese), "zh" (Chinese), "ar" (Arabic), "pt" (Portuguese), and many more.
Basic Examples
Translating a Text String
=GOOGLETRANSLATE("Good morning", "en", "fr")
Result: Bonjour
Translating Cell Contents with Auto-Detection
| A | B (Formula) | B (Result) | |
|---|---|---|---|
| 1 | Original | Translation | Translation |
| 2 | Danke schoen | =GOOGLETRANSLATE(A2, "auto", "en") | Thank you very much |
| 3 | Gracias | =GOOGLETRANSLATE(A3, "auto", "en") | Thank you |
Setting the source language to "auto" lets Google detect the input language, which is handy when your data contains mixed languages.
Translating Product Descriptions to Multiple Languages
| A | B (Formula) | C (Formula) | |
|---|---|---|---|
| 1 | English | Spanish | French |
| 2 | Wireless mouse with ergonomic design | =GOOGLETRANSLATE(A2,"en","es") | =GOOGLETRANSLATE(A2,"en","fr") |
One source cell, multiple translation columns. This is a fast way to draft multilingual product listings.
Advanced Examples
Dynamic Target Language from a Dropdown
Create a dropdown in cell E1 with language codes (en, es, fr, de, ja), then use it as the target:
=GOOGLETRANSLATE(A2, "en", E1)
Now changing the dropdown instantly retranslates the entire column. This works well for building a simple translation preview tool within a spreadsheet.
Bulk Translation with ARRAYFORMULA
=ARRAYFORMULA(GOOGLETRANSLATE(A2:A50, "en", "es"))
Note that GOOGLETRANSLATE does not always play nicely with ARRAYFORMULA. If it fails, the reliable workaround is to write the formula in cell B2 and drag it down to B50 manually. Google Sheets may also throttle bulk translation requests, so extremely large batches (hundreds of cells) may return errors temporarily.
Pairing with DETECTLANGUAGE
If you want to log the detected language alongside the translation:
=DETECTLANGUAGE(A2)
This returns the language code of the text in A2 (e.g., "es" for Spanish text). You can use this in a helper column to verify that auto-detection is working correctly before translating.
Common Mistakes
- Expecting professional-grade translations. GOOGLETRANSLATE uses machine translation. It works well for short phrases, product names, and general content, but it should not be trusted for legal documents, medical text, or nuanced marketing copy without human review.
- Hitting rate limits on large datasets. Translating hundreds or thousands of cells at once can trigger temporary errors. Google throttles requests to prevent abuse. If you see
#VALUE!errors appearing in bulk, wait a few minutes or split the work across multiple sheets. - Using incorrect language codes. Chinese Simplified is "zh-CN", not "zh". Brazilian Portuguese is "pt-BR", not "pt" (though "pt" usually defaults to Brazilian Portuguese). Check the ISO 639-1 list if translations seem wrong or return errors.
SheetAI Tip
Don't want to memorize this syntax? With SheetAI, just type what you need in plain English and the formula is generated for you. Install SheetAI to try it free.