Google Sheets GOOGLETRANSLATE Function: How It Works

Google Sheets includes a built-in GOOGLETRANSLATE function for translating text in a cell. For example, if A2 contains English text, enter =GOOGLETRANSLATE(A2,"en","es") in another cell to request a Spanish translation; replace the language codes to suit your source and target languages.

What the GOOGLETRANSLATE function does

GOOGLETRANSLATE returns a machine-translated version of text. You can provide a typed phrase, a quoted string, or a reference to a cell. The result appears in the cell containing the formula, while the original text stays where it is. That makes the function useful for translating lists, product descriptions, short messages, survey responses, and other text stored in a sheet.

The function translates text rather than the spreadsheet itself. It does not translate sheet names, formatting, comments, charts, or every label in a workbook. Nor does it guarantee a publication-ready translation: word choice can depend on context, tone, and the source text. Treat the result as a draft when accuracy or nuance matters.

Arguments and language codes

The function takes the text to translate and language codes for the source and target. The source code can be set to "auto" to ask Google Sheets to detect the language. For reliable results, specify the source language when you know it, and always specify the target language you want. Common codes include "en" for English, "es" for Spanish, "fr" for French, "de" for German, and "ja" for Japanese.

For example, with the phrase in A2, this formula requests French and allows automatic source-language detection: =GOOGLETRANSLATE(A2,"auto","fr"). If you omit the source language, Sheets can detect it when a target language is supplied. Using explicit codes is easier to audit in a shared workbook and helps avoid a mistaken language guess for short or ambiguous text.

Language codes are not the same as country names. If a particular regional variant matters, check which codes the translation service accepts for that language rather than assuming that a country abbreviation will work. Translating a phrase from a language that cannot be detected reliably is a good reason to set the source code yourself.

Translate one cell in Google Sheets

Put the source text in a cell, such as A2.
Select a different cell for the translation, such as B2.
Enter =GOOGLETRANSLATE(A2,"en","es") and press Enter.
Check that the result is in the intended language and that the source text was identified correctly.

You can also translate a phrase typed directly into the formula. For instance, =GOOGLETRANSLATE("Good morning","en","fr") requests a French translation of that phrase. A cell reference is usually more practical because you can edit the original text without rewriting the formula. Keep the source and translated text in separate columns so a reviewer can compare them.

Translate a list or an entire column

For a list, place the source text in one column and put a formula beside the first entry. If the source text is in A2, enter =GOOGLETRANSLATE(A2,"en","es") in B2. Then select B2 and drag the small square at the lower-right corner of the cell down the column, or copy B2 and paste it into the destination cells. Sheets adjusts the relative reference as the formula is copied: the next row will refer to A3, then A4, and so on.

It is sensible to test a few representative rows before filling a long list. Check short phrases, longer sentences, names, abbreviations, and any text with specialized vocabulary. Keep a heading above each column, such as “English source” and “Spanish draft,” so other editors understand which text is original and which is generated.

A copied formula translates each row separately; it does not make a permanent translation record independent of the source. If the source text changes, the formula can return a new translation. If you need to preserve a reviewed version, copy the translated cells and use Edit > Paste special > Values only in Google Sheets to replace formulas with their current results. Keep a copy of the formulas elsewhere if you may need to regenerate the translations.

Automatic language detection and translation quality

Automatic detection is convenient when a column contains text in different languages, but it is not infallible. A single word may be shared across languages, and names, codes, very short labels, or misspellings may not provide enough context. For a known, consistent source language, specifying it directly usually makes the formula easier to understand and reduces uncertainty.

Machine translation can also choose a meaning that does not fit your use. For example, a word may refer to a financial institution in one sentence and a riverbank in another. A product name may be translated as an ordinary word, while a slogan may lose its intended humor. Review the output where meaning, tone, cultural context, or terminology is important. For public-facing or regulated material, use a qualified human reviewer rather than treating a formula result as final approval.

Formatting is another practical limit: the function returns translated text, not a styled copy of the source cell. It will not preserve bolding within part of a sentence or recreate a layout. If a cell contains several sentences, the function requests a translation of the text as a whole, but it cannot know your preferred terminology unless that meaning is clear from context.

Common errors and how to troubleshoot them

If a formula does not work, check its structure first. The text argument must be available, the language codes must be supported, and the quotation marks around codes must be straight double quotes. A typical formula is =GOOGLETRANSLATE(A2,"en","es"). If you typed a language code without quotation marks, Sheets may interpret it as a name or reference instead of text.

Formula parse error: Check commas, parentheses, and quotation marks. Spreadsheet locale settings can affect formula separators; if Sheets rejects commas, check the file’s locale and use the separator expected by that locale.
Unexpected language: Confirm the source and target codes, then replace "auto" with the known source code if detection may be ambiguous.
Blank result: Check whether the referenced source cell is empty or contains only spaces. A blank input does not provide text to translate.
Error or delayed result: Confirm that the source cell contains ordinary text and that your connection is available. A service-dependent formula may fail or take time to recalculate; try again later if the issue appears temporary.

For a cleaner list, avoid filling translation formulas far below the last source entry. Otherwise, empty rows can contain formulas with empty results, making the sheet harder to filter or maintain. If your source data is imported or frequently edited, periodically check that the translated column still corresponds to the correct source rows.

Costs, availability, and alternatives

GOOGLETRANSLATE is a built-in Google Sheets function, not a separate translation add-on that you need to install. There is no separate fee attached to entering an ordinary formula, although account access, service availability, and usage limits can depend on Google’s current terms and systems. Google does not promise that a large batch of formulas will always calculate instantly, so avoid designing a time-critical workflow around unlimited translation requests.

For a handful of phrases, Google Translate’s website can be easier: you can inspect a translation, compare alternatives, and adjust the wording before putting it back in the sheet. For a repeated table workflow, the Sheets function is more convenient because it keeps the result beside its source and can update when the referenced text changes. If you need specialized terminology, a glossary-based workflow or human translation may be more appropriate than either automatic option.

The function is specific to Google Sheets. An Excel workbook will not generally calculate GOOGLETRANSLATE as a native Excel function. Supported Microsoft 365 versions of Excel have a separate TRANSLATE function, but availability and syntax should be checked for the particular Excel version and account. Do not assume a Sheets formula can be moved unchanged into Excel.

Privacy and safe use

Text used in a translation formula is processed through Google’s online services, so consider the information in the cells before using the function. Do not translate confidential customer details, employee records, health information, passwords, or other sensitive material unless your organization’s rules and applicable Google account terms allow that use. A cell reference does not make its contents private simply because the formula is inside a spreadsheet.

For shared workbooks, make clear who can see the source and translated columns, and review sharing permissions before distributing the file. If a translation is only a draft, label it accordingly. These steps help prevent readers from mistaking an automatically generated result for an approved translation.

Frequently Asked Questions

Can Google Sheets automatically translate a whole column?
It can translate each populated row when you copy a formula down beside the source data. The function is not a one-time command that translates every cell in a sheet automatically; each result needs a formula or another configured workflow.

Can GOOGLETRANSLATE detect the source language?
Yes. Use "auto" as the source-language argument and provide a target language, as in =GOOGLETRANSLATE(A2,"auto","fr"). Detection may be uncertain for short, ambiguous, or misspelled text.

Does GOOGLETRANSLATE work offline?
The formula relies on Google’s online translation service, so it needs an internet connection to request or refresh a translation. A previously calculated value may remain visible temporarily, but offline editing should not be relied on to generate current results.

Can I translate a cell without changing the original?
Yes. Put the formula in another cell and refer to the source cell, such as =GOOGLETRANSLATE(A2,"en","es") in B2. The original in A2 remains unchanged.

Does the function preserve formatting or translate formulas?
No. It returns translated text; it does not copy cell formatting or translate the structure of a spreadsheet. If a cell reference evaluates to text, the function can translate that text, but it is not a tool for converting formulas, layouts, or an entire workbook.

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.