Google Sheets Google Translate Formula: How to Use It

In Google Sheets, translate text with GOOGLETRANSLATE. With the text in A2 and a Spanish translation wanted in B2, enter =GOOGLETRANSLATE(A2, "en", "es"); for the English word “Hello,” the result is typically “Hola.”

What the GOOGLETRANSLATE formula does

GOOGLETRANSLATE sends text in a cell or typed directly into a formula to Google Translate and returns a translated result in the formula cell. It is useful for simple translations within a spreadsheet, such as translating product labels, survey responses, or short notes. It does not change the original text: keep the source in one column and put the formula in another if you want both versions.

The function’s syntax is GOOGLETRANSLATE(text, [source_language, target_language]). The text argument is the content to translate. The source language identifies the language of that content, and the target language identifies the language you want back. For predictable results, specify both language codes rather than relying on automatic detection.

text: A cell reference such as A2, or text entered inside quotation marks.
source_language: A language code such as en for English. Use auto to ask Google to detect the source language.
target_language: A language code for the language you want, such as es for Spanish or fr for French.

The square brackets in the syntax description indicate optional arguments in the function reference. In ordinary use, include a target language, and include a source code or auto so the formula clearly states what it is translating from.

Choose language codes carefully

Language names in the formula are represented by codes, not by their English names. Common examples include en for English, es for Spanish, fr for French, de for German, it for Italian, ja for Japanese, and ko for Korean. Use the codes accepted by Google Translate; regional varieties may have more specific codes, so check Google’s language list if a code is rejected or if the regional choice matters.

Automatic detection can be convenient when a column mixes languages, but it is not infallible. A short entry such as “no,” a name, or an abbreviation may not provide enough context to identify a language reliably. If every source cell is meant to be in the same language, naming that language explicitly generally makes the sheet easier to understand and reduces uncertainty.

Translate a cell or a fixed phrase

For a reusable sheet, refer to the cell that contains the source text. With English text in A2 and a French translation wanted in B2, enter =GOOGLETRANSLATE(A2, "en", "fr") in B2. If A2 contains “Good morning,” the result is typically “Bonjour.” When A2 changes, the formula can recalculate and return a translation of its new contents.

You can also translate a fixed phrase without referring to a cell. With no particular cell layout required, enter =GOOGLETRANSLATE("Thank you", "en", "es") in an empty cell; the result is typically “Gracias.” A cell reference is more practical for a list that changes, while a quoted phrase is useful for a quick lookup or a fixed label. In either case, the output is a formula result, not a manually editable translation: typing over the result replaces the formula.

Translate a column and handle blank rows

To translate many entries, put the source text in one column and the first translation formula in the neighboring column. With source text in A2:A and the first result in B2, enter =GOOGLETRANSLATE(A2, "en", "es") in B2, then use the fill handle at the corner of the cell to copy the formula down. Sheets adjusts the relative reference for each row, so the next formula refers to A3, then A4, and so on.

If the source column has blank rows, an IF formula can leave the corresponding result empty instead of asking for a translation of an empty cell. With text in A2 and the result in B2, enter =IF(A2="", "", GOOGLETRANSLATE(A2, "en", "es")) in B2 and fill it down. For example, if A2 is blank, B2 remains blank; if A2 contains “Good morning,” B2 returns the usual Spanish translation “Buenos días.”

Before filling a formula through a large sheet, try it on a few representative rows. This helps reveal unexpected source languages, very long entries, or special content that needs a different workflow. Keep the original column intact so someone reviewing the sheet can compare each translation with its source.

Use the formula in a practical workflow

A clear spreadsheet layout makes translated data easier to review and maintain. For example, use separate columns for the original text, the source language if it varies, and the translated text. Add a header to each column, and avoid placing translations over source values. If your source and target languages vary from row to row, you can put the language codes in cells and refer to those cells in the formula.

With source text in A2, a source code in B2, a target code in C2, and the result in D2, enter =GOOGLETRANSLATE(A2, B2, C2) in D2. For instance, if A2 is “Hello,” B2 is en, and C2 is fr, the result is typically “Bonjour.” This arrangement lets you change a language code without rewriting the formula, though it also means a mistyped code in B2 or C2 can affect the result. For a simple one-language list, fixed codes in the formula are easier to audit.

For important material, consider adding a review column where a fluent speaker can check wording, tone, and context. A formula is helpful for producing a draft across many rows, but it does not tell you whether a translation is appropriate for a specific customer, region, or situation.

Common errors and ways to troubleshoot

If Sheets displays a formula parse error, first check that the formula begins with an equals sign, that quotation marks are straight, and that each parenthesis is closed. Some spreadsheet locale settings use semicolons rather than commas to separate arguments. If a comma-based example does not parse in your sheet, check the locale and use the separator expected by that sheet. Do not replace the commas inside quoted text; those are part of the text itself.

Check the language codes. Use a supported code rather than a full language name, and make sure the source and target are not accidentally reversed.
Check the source cell. A blank, error, or unexpected value in the referenced cell can produce an unexpected result.
Try a longer sample. Automatic detection is less dependable for very short words, abbreviations, and names.
Wait or retry if a result fails temporarily. The function depends on an online service, so network availability or service limits can affect calculation.
Check how the formula was copied. When filling down, confirm that each row points to its own source cell and not to an unintended fixed reference.

If a formula works for one row but not another, compare the source values and language codes in those rows. A problem may be tied to a particular entry rather than the formula structure. For a large batch, splitting the work into smaller groups and checking results as they appear can make it easier to spot issues.

Translation quality, privacy, and limitations

Machine translation is a useful starting point, not a guarantee of an exact or culturally appropriate translation. Meaning can depend on context, grammar, wordplay, industry terms, and regional usage. A short product name may be better left unchanged, while a customer-facing instruction may need a human reviewer. Google Translate can also revise how it translates a phrase over time, so a formula result should not be treated as a permanent, approved wording unless your team has checked and recorded it.

The function requires an internet connection because it relies on Google’s translation service; it is not a way to translate offline. Avoid putting confidential, personal, regulated, or otherwise restricted material into a translation workflow unless your organization’s rules and the applicable Google service terms permit it. For sensitive information, ask the responsible privacy or security contact about approved tools and handling practices.

Recalculation can also matter in a working sheet. If source text changes, the translation may update, and service availability or limits can affect results. For a document that needs a stable, reviewed version, make a copy of approved translations as values after review, while preserving an original working sheet if formulas need to remain available.

Google Sheets versus Excel and other options

GOOGLETRANSLATE is a Google Sheets function; it is not a standard Excel worksheet function. If you open a sheet in Excel, this formula will not behave as a native Excel formula. Excel users need a different translation workflow, such as an approved Microsoft or third-party tool, or a manually reviewed translation table. The right choice depends on your software, privacy requirements, and whether translation must happen automatically inside the grid.

Within Google Sheets, a translation formula is convenient for repeated short text and a quick first pass. For polished marketing copy, legal wording, safety instructions, or large projects where terminology must be consistent, a human translator or a dedicated translation-management workflow may be more appropriate. A manually maintained glossary can also help reviewers use consistent terms even when the formula supplies an initial draft.

Frequently Asked Questions

What is the Google Sheets formula for Google Translate?
Use =GOOGLETRANSLATE(text, "source", "target"), replacing the placeholders with a cell reference or text and supported language codes. For example, with English text in A2 and a Spanish result wanted, use =GOOGLETRANSLATE(A2, "en", "es").

Can Google Sheets detect the source language automatically?
Yes. Use auto as the source code, such as =GOOGLETRANSLATE(A2, "auto", "fr") when A2 contains text to translate into French. Detection may be unreliable for short or ambiguous text.

Can I translate an entire column at once?
Enter the formula for the first row and fill it down alongside the source data. Check a few results before applying it to a large list. Separate source and result columns so the original text remains available.

Why is GOOGLETRANSLATE not working in my sheet?
Check the formula syntax, argument separators, language codes, and referenced cells. The function needs an online connection, and temporary service or calculation limits can also interrupt results.

Does GOOGLETRANSLATE work in Microsoft Excel?
It is a Google Sheets function, not a built-in Excel worksheet function. An Excel workbook will need another translation method rather than relying on this Sheets formula.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.