Google Sheets Google Translate: How to Translate Cells

To translate text in Google Sheets, enter a formula such as =GOOGLETRANSLATE(A2,"auto","es") in an empty cell. It translates the text in A2 into Spanish; replace es with another supported language code to choose a different target language.

How Google Translate works in Sheets

GOOGLETRANSLATE is a Google Sheets function that sends text to Google’s translation service and returns a translated result in the cell containing the formula. It is useful for translating labels, short notes, product descriptions, survey responses, and other text stored in a spreadsheet. It does not replace the source text: the original stays in its cell, while the translation appears wherever you put the formula.

For example, if A2 contains Good morning, entering =GOOGLETRANSLATE(A2,"en","es") in B2 returns Buenos días. You can also ask Sheets to identify the source language automatically by using auto, as in the opening example. Automatic detection can help when a column contains text in more than one language, though short or ambiguous text can be difficult to identify correctly.

The function needs an internet connection because translation is performed through Google’s service rather than entirely inside the spreadsheet. As a result, it may take a moment to return an answer, especially when you have many translations to calculate.

Formula syntax and language codes

The function’s syntax is GOOGLETRANSLATE(text, [source_language, target_language]). The text argument can be a cell reference or text entered directly in the formula. The source and target language arguments use language codes, not the full language names. In a formula, text and language codes need straight quotation marks.

=GOOGLETRANSLATE(A2,"en","fr") translates the text in A2 from English to French.
=GOOGLETRANSLATE(A2,"auto","de") detects the source language and translates into German.
=GOOGLETRANSLATE("Thank you","en","ja") translates the typed phrase from English into Japanese.

Common codes include en for English, es for Spanish, fr for French, de for German, and ja for Japanese. Google’s supported language list can change, so check Google Translate’s language options if a code is rejected or if you need a less common language. A spreadsheet’s locale is a separate setting: changing the sheet’s locale affects regional conventions such as dates and number formats, but it does not set the translation language in this formula.

Translate a column or a list of cells

For a simple list, keep the original text in one column and place the formula in the next. Suppose the source text starts in A2. Enter =GOOGLETRANSLATE(A2,"auto","es") in B2, then use the fill handle at the corner of B2 to copy the formula down the rows you need. The reference adjusts as it fills: the next row refers to A3, then A4, and so on. This layout makes it easy to compare each source entry with its translation.

Keep the translation formula in a separate output column rather than writing over the source. That lets you review both versions, correct the original when needed, and change the target language without losing the source material. For a second target language, add another column and use a different target code, such as fr for French.

If you have a very large list, translate a manageable range first and check that the results are useful before filling thousands of rows. Each formula requires a result from the translation service, and a large number of requests may take time or produce temporary errors. Avoid assuming that a formula will process an entire column in one operation; filling a formula down a defined set of rows is a straightforward way to see and control what is being translated.

Keep translations current or save fixed results

A formula-based translation is linked to its source cell. If you edit the text in A2, the translation formula that refers to A2 can update to reflect the changed text. This is handy for a working list, but it also means the output is not a permanent, human-approved translation. Review the translated wording before using it in customer-facing material or a final document.

When you want to keep a translation as a fixed value, copy the result cells and choose Edit > Paste special > Values only in Google Sheets. The pasted text no longer depends on the formula or its source cell. Keep a copy of the original formula-based sheet if you may need to regenerate translations later. Pasting values is also useful before sharing a static snapshot, although it does not make the translation itself more accurate.

For collaborative review, you can leave the source and formula results in separate columns and add a further column for an editor’s approved wording. This makes it clear which text is machine-translated and which text has been checked or revised by a person.

Translation quality and important limitations

Machine translation is a useful first pass, not a guarantee of exact meaning. A phrase can have several meanings, and a short cell often gives the service little context. For example, a single word such as charge could refer to a fee, an electrical property, or an instruction to rush forward. A longer sentence or a surrounding description may make the intended meaning clearer, but the result should still be checked when precision matters.

Pay particular attention to names, brand terms, abbreviations, measurements, jokes, and industry-specific language. A translation may alter capitalization, choose an unintended sense, or produce wording that sounds unnatural to a fluent reader. A spreadsheet function also does not judge whether a translation suits a particular audience or legal, medical, or technical context.

For a quick internal overview, an automatic translation may be enough to understand the general subject of a list. For published copy, instructions, contracts, safety information, or other high-impact text, have a qualified person review the wording. Preserve the original text so reviewers can check meaning rather than having to reconstruct what the source said.

Common problems and ways to troubleshoot

If the formula displays an error instead of a translation, check the formula structure first. Confirm that the referenced cell exists, the language codes are enclosed in straight quotation marks, and the arguments are separated by commas. If your spreadsheet uses a locale that expects different formula separators, Sheets may display a locale-specific format; follow the syntax it accepts in that file. Also make sure the source cell contains text rather than being empty.

Unexpected language: Replace auto with the known source code, such as en, when the text is short or could be detected incorrectly.
Code not accepted: Verify the code against Google Translate’s available languages rather than typing a language name in its place.
Blank or unhelpful result: Check the source cell for spaces, empty content, or text that lacks enough context to translate sensibly.
Slow results or temporary errors: Try a smaller group of rows and allow the sheet time to calculate before copying the formula further.
Formula appears as text: Check that the cell is not being treated as plain text, then re-enter the formula beginning with an equals sign.

For help identifying the source language, Google Sheets also has DETECTLANGUAGE. With text in A2, =DETECTLANGUAGE(A2) returns a language code when it can identify one. Detection is not a substitute for checking the content, and very short text may not provide enough information for a dependable result.

Costs, privacy, and suitable uses

GOOGLETRANSLATE is a built-in Google Sheets function, so a user does not need to install a translation add-on simply to use the formula. It does rely on Google’s online translation service, however. It is not an offline translation tool, and users should not assume that an arbitrarily large spreadsheet can be translated instantly or without service limits. If a formula is being used at scale, check current Google product guidance and test the workflow with a small sample.

Because the text is processed by an online service, consider what the cells contain before using the function. Follow your organization’s rules for confidential, personal, customer, or regulated information, and do not send sensitive text to an external service unless you are authorized to do so. For routine public-facing labels or non-sensitive working data, the formula can be convenient; for restricted data, ask the relevant administrator or privacy contact about approved tools.

Alternatives and how Sheets differs from Excel

If you only need to translate a few phrases, you can use Google Translate separately and paste the reviewed result into the sheet. That can be simpler when context is important or when you want to choose among alternative translations. For repeated updates across rows, the Sheets formula is more convenient because it links a result to its source cell.

Google Sheets’ GOOGLETRANSLATE is not a standard Excel worksheet function. In Excel for Microsoft 365 on Windows, do not expect to enter the same formula and receive a translation. Excel users generally need a different, supported workflow, such as translating text outside the workbook or using an organization-approved add-in or service. The exact options depend on the Excel version and account. If a file moves between Sheets and Excel, verify formulas after conversion; a Sheets-specific function may not work in Excel.

For a spreadsheet that will be maintained by multiple people, decide whether live formulas or fixed approved text are more appropriate. Formulas are useful for drafts and changing lists. Fixed values, paired with the original text and a review process, are often easier to manage when translations must remain consistent in a released document.

Frequently Asked Questions

What is the Google Sheets formula for Google Translate?
Use =GOOGLETRANSLATE(A2,"auto","es") to translate the text in A2 into Spanish while asking Sheets to detect the source language. Replace es with the target language code you need.

Can Google Sheets translate an entire column?
You can translate a list by putting a formula beside the first source cell and filling it down through the rows you need. Keeping the source and translated text in separate columns makes results easier to check.

Can I translate from a language I do not know?
Yes. Use auto as the source-language code, for example =GOOGLETRANSLATE(A2,"auto","en") to request English. Automatic detection may be uncertain for brief or ambiguous text.

Does Google Sheets automatically translate text when I paste it?
No. Pasting text does not by itself translate it. Enter a GOOGLETRANSLATE formula in a cell, or translate the text with another tool and paste the result.

Can I use GOOGLETRANSLATE in Microsoft Excel?
GOOGLETRANSLATE is a Google Sheets function, not a standard Excel worksheet function. Excel users need another translation workflow, and should check that any add-in or service is approved for their account and data.

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.