GOOGLETRANSLATE in Google Sheets: Languages and Defaults
Translate text with GOOGLETRANSLATE in Google Sheets, set source and target codes explicitly and review automatic detection, system-language defaults and wording variation.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =GOOGLETRANSLATE("Hola, ¿cómo estás?","es","en") requests Spanish-to-English translation. Google’s published example displays Hello how are you?; current wording or punctuation may vary.
Syntax and defaults
=GOOGLETRANSLATE(text, [source_language], [target_language])
According to the Google GOOGLETRANSLATE reference:
| Argument | Meaning | Omitted behavior |
|---|---|---|
| text | Literal text or cell containing text | Required |
| source_language | Language code such as en, es or ko; or auto | auto |
| target_language | Destination language code such as en or ja | System language |
If the source argument is omitted, the target argument must also be omitted. To detect the source while choosing a destination, explicitly supply "auto" as the second argument.
The square brackets above describe optional arguments; they are not characters to type in a formula. Quoted codes identify languages, while a cell reference can supply the code as text.
Worked example: translate a review queue
Create this small synthetic dataset:
| Row | A: source text | B: source code | C: target code |
|---|---|---|---|
| 2 | Hola, ¿cómo estás? | es | en |
| 3 | Bonjour | fr | en |
| 4 | Gracias | es | en |
In D2, enter and fill down:
=GOOGLETRANSLATE(A2,B2,C2)
Expected meanings are Hello, how are you?, Hello, and Thank you. The first meaning is corroborated by Google’s linked read-only published example; the other two are independently checked language examples. Exact capitalization, punctuation or word choice is a service output and was not measured in a native session.
For row 2, the published Google example specifically displays “Hello how are you?” for that Spanish input. It is evidence of the intended translation contract, not a promise that the current service will preserve that exact string forever.
Automatic source detection with an explicit target
To translate the French greeting in A3 to English while asking the service to detect the source:
=GOOGLETRANSLATE(A3,"auto","en")
Expected meaning: Hello. This keeps the target stable across users whose system languages differ.
By contrast:
=GOOGLETRANSLATE(A3)
uses automatic source detection and the system language as the destination. There is no single universal expected translated string for that call without establishing the relevant system language. The function reference does not identify that default as the spreadsheet’s number/date locale; do not assume those settings are interchangeable.
Advanced application: an editable translation target
Put en in F1 and keep a known source code in column B. Use:
=GOOGLETRANSLATE(A2,B2,$F$1)
Fill down. The absolute reference keeps the same destination for every row while the source text and code move with the row. Changing F1 to es would request Spanish output for all rows; it does not change the originals in column A.
For a deliberate blank-row guard:
=IF(A2="","",GOOGLETRANSLATE(A2,B2,$F$1))
An empty source cell is intended to display an empty result rather than become a translation task. Keep corrections in a separate review column so refreshes do not overwrite a human-approved final wording.
A useful layout is original text, source language, automatic draft, reviewed wording and review status. Only the draft column needs the translation formula. This preserves the distinction between a machine suggestion and text someone has approved for use.
Translation quality and troubleshooting
Short greetings are useful smoke tests, but they do not prove reliable handling of technical terms, jokes, names or context-dependent expressions. Check numbers, negation and the intended audience before relying on a translation.
If the output is in an unexpected language, inspect the target argument first. If the meaning is wrong, verify the source code and provide a complete sentence rather than a fragment. An incorrect explicit source code can be less helpful than a correct known code or deliberate automatic detection.
The individual reference does not establish a complete supported-language matrix, precise per-call character limits, quotas or all native error tokens. These are therefore not asserted. A spreadsheet error should remain distinguishable from an untranslated or already-correct string; suppressing every error with an empty value can hide unfinished work.
Availability and verification
GOOGLETRANSLATE is currently documented for rolling Google Sheets. A formula with the same spelling in an exported workbook is not proof that another product can execute Google’s translation service. Original introduction date and first or last numbered releases were not established.
NOT_TESTED_IN_GOOGLE_SHEETS. Google’s individual documentation and its public example were inspected on October 17, 2026. Original translation meanings and reference logic were independently reviewed, not submitted to a translation API or executed in Sheets. No screenshot is claimed.
Related published guides: IF, TRIM, CONCATENATE and TEXTJOIN.