=GPT_TRANSLATE() — AI translation in Google Sheets
=GPT_TRANSLATE() translates cell content with an LLM. Unlike GOOGLETRANSLATE(), it keeps tone, handles idioms, and can follow instructions (“keep brand names in English”) — which is why teams use it to localize catalogs and marketing copy in bulk.
Syntax
=GPT_TRANSLATE(text, [target_language], [source_language])
| Parameter | Required | Description |
|---|---|---|
text |
yes | Text or cell to translate. |
target_language |
no | Defaults to English. |
source_language |
no | Auto-detected when empty. |
Examples
Translate a product description in A2 to German:
=GPT_TRANSLATE(A2, "German")
Localize a whole catalog: put languages in row 1 (B1=Spanish, C1=French…) and drag both ways:
=GPT_TRANSLATE($A2, B$1)
Try it
Copy the template or install GPT for Sheets. Recipe: bulk translation template.