Translate Google Sheets to English: Formulas, Steps and Tips

To translate text in Google Sheets into English, enter a formula such as =GOOGLETRANSLATE(A2,"auto","en") in an empty cell, replacing A2 with the cell that contains the text. The formula translates that cell’s contents; it does not change the original text or automatically translate the entire spreadsheet.

What “Translate Google Sheets” Can Mean

People asking how to translate Google Sheets to English may mean one of two different things: translating the text stored in the spreadsheet, or changing the language of the Google Sheets menus and controls. These are separate tasks. A formula can translate cell contents, while the language of the interface is controlled through Google account preferences.

It is also useful to distinguish translation from changing a spreadsheet’s locale. Locale affects conventions such as date formats, number formats, and currency display. For example, a date or decimal separator may look different after a locale change, but the words in a cell are not translated. If a sheet contains Spanish descriptions and you need English descriptions, use a translation method rather than changing the locale.

Translate One Cell with GOOGLETRANSLATE

In Google Sheets in a web browser, GOOGLETRANSLATE is the built-in function for translating text. It takes the text to translate, its source language, and its target language. The source can be set to auto so Sheets attempts to identify it; the target code for English is en.

Assuming the text to translate is in A2 and you want the English result in B2, enter:

=GOOGLETRANSLATE(A2,"auto","en")

If A2 contains “Guten Morgen,” the result is “Good morning.” The source cell remains unchanged, and the translated result appears in B2. This is helpful when you want to review the translation alongside the original rather than overwrite source material.

If you already know the source language, specifying it can reduce ambiguity. With Spanish text in A2 and the English result desired in B2, use:

=GOOGLETRANSLATE(A2,"es","en")

Here, es is the language code for Spanish. Other common codes include fr for French, de for German, ja for Japanese, and pt for Portuguese. Language codes generally use the standard two-letter form. If you are unsure of a code, check Google’s function documentation rather than guessing, particularly for languages with regional variants.

Translate a Column or a List of Entries

For a list, keep the source text in one column and put the formula in the adjacent column. For example, with source sentences in A2:A100, enter the formula below in B2, then fill it down through the rows that contain text:

=GOOGLETRANSLATE(A2,"auto","en")

Each copied formula adjusts its reference: the next row translates A3, then A4, and so on. To fill down, select B2 and drag the small square at the lower-right corner of the selected cell. If the neighboring source column is continuous, double-clicking that square often fills the formula down to match the adjacent data. Check the last few rows afterward, since blank rows or gaps can affect how far it fills.

To keep empty source cells visually empty, with source text in A2 and the output in B2, use this version and fill it down:

=IF(A2="","",GOOGLETRANSLATE(A2,"auto","en"))

This checks whether A2 is blank before requesting a translation. For a very large sheet, work in manageable batches and review the results before relying on them. A large number of repeated translation requests may take time or encounter temporary service limits; avoid assuming that a formula error means the source text itself is invalid.

Keep a separate column for translated text so the source remains available.
Use a clear header such as “English translation” to distinguish output from original content.
After filling down, check that the formulas point to the corresponding row rather than all pointing to the first source cell.

Detect a Source Language or Choose It Yourself

Automatic detection is convenient when a column contains several languages, but it is not infallible. Very short entries, names, abbreviations, isolated numbers, and words shared by multiple languages provide little context. In a list of one-word labels, for example, automatic detection may not have enough information to identify the language reliably.

Google Sheets also has the DETECTLANGUAGE function. With a sample of text in A2, enter this in another cell:

=DETECTLANGUAGE(A2)

For a clear French phrase such as “Bonjour,” the function should return fr. Detection is a clue, not a guarantee that the translation will be correct. If you know the source language from the person or system that supplied the data, using its code in GOOGLETRANSLATE is often more dependable than relying on detection for every row.

For mixed-language spreadsheets, decide whether the source language is consistent before filling a formula down. If the rows contain different languages, auto detection can be practical. If a group of rows all comes from one language, specifying that language makes the workflow easier to audit and can help avoid unexpected interpretations.

Keep the Original Data and Make Results Permanent

A formula result is calculated output, not an independent translation record. The displayed English text can change if the source cell changes or if the function recalculates. For review work, preserve the original column and add the translation in a new one. This makes it possible to compare wording, spot omissions, and return to the source if an English phrase seems unclear.

When you are satisfied with the translations and want to keep the current wording without formulas, copy the translated cells and paste their values into a destination range. In Google Sheets, use Edit > Paste special > Values only. This replaces formulas in the destination with their current displayed results. If you want to preserve the formulas too, keep a separate copy of the sheet or paste values into another column.

Translation formulas do not automatically preserve every aspect of a document’s meaning or layout. A cell’s text is translated, but the function does not rewrite text inside an image, interpret a chart, or decide how to translate a product code. It also does not guarantee that a translated phrase will fit the original column width. After translation, inspect wrapped text, row heights, formulas that depend on the source column, and any labels embedded in charts or drawings.

Translate the Sheets Interface, Not Cell Contents

If the menus, buttons, or settings are in another language, translating cells will not change them. Change the language preference associated with your Google Account instead, then reload Google Sheets if the interface does not update immediately. The exact labels in account settings can change over time, but look for the account’s language preference, not a spreadsheet formula.

Changing the spreadsheet locale is a different option. In the sheet, open File > Settings and review the General settings, including Locale. Choose a locale when you need dates, numbers, or currency conventions to match a region. Do not expect this setting to translate cell text or to change the language of the Google Sheets interface.

When the sheet is shared, these choices can matter to other people. A locale change affects how the spreadsheet interprets and displays certain values, whereas an individual’s account language is generally a preference for that person’s Google interface. Before changing locale in a shared working file, consider whether collaborators rely on its existing date and number conventions.

Accuracy, Privacy, and Common Problems

Machine translation is useful for understanding and sorting ordinary text, but it can miss tone, idioms, specialized terminology, and context that spans several cells. A translation of a customer comment, a legal clause, a medical instruction, or a product safety warning should not be treated as an authoritative version without appropriate human review. Even a fluent-sounding result can shift a key distinction.

Check proper names, addresses, amounts, dates, measurements, negations, and technical terms especially carefully. For example, “not approved” and “approved” differ by one small word, and an incorrect translation could matter more than a visibly awkward sentence. If a term must be translated consistently, create a small glossary and compare the output against it instead of assuming that separate formula results will use the same preferred wording.

Formula parse error: Confirm the function name, parentheses, and quotation marks. Depending on the spreadsheet’s locale, Sheets may expect semicolons rather than commas between arguments. If a comma-separated example does not parse, try the separator used by other formulas in that file.
Unexpected source language: Replace auto with the known two-letter source code and check whether the text actually contains enough context.
Temporary failure or missing result: Check the internet connection, try again later, and test a smaller range. Avoid filling thousands of formulas repeatedly while a service issue is occurring.
Blank cells or formula-looking text: Check whether the source cell is genuinely empty and whether the content is stored as text. The blank-check formula above can keep empty rows tidy.

Consider data sensitivity before sending content to any online translation service. Do not put confidential, regulated, or personal information into a translation workflow unless its use is permitted by your organization’s rules and applicable requirements. For sensitive material, ask the relevant privacy or security contact what tools are approved.

Alternatives and When to Use Them

For a small amount of text, you can copy it into Google Translate in a browser and paste the result back into the sheet. This offers a quick way to inspect a sentence or compare possible wording, but it is manual and can be awkward for long tables. Keep a record of which source row each result belongs to so that translations do not become misaligned.

For routine, repeatable work inside a Google spreadsheet, GOOGLETRANSLATE is usually the simplest starting point: it keeps the source and result together and can be filled down. For content where accuracy, tone, or liability matters, use a qualified human translator or have a knowledgeable reviewer check the translation. Automated output is not a substitute for professional review when the consequences of an error are significant.

Organizations processing many records may consider a translation API or an approved translation platform, but that is a separate setup from a Sheets formula. Such options can require configuration, permissions, and billing; check the provider’s current terms and pricing before using them. Google Sheets’ GOOGLETRANSLATE function does not require you to write an API integration, but it should not be treated as an unlimited bulk-processing service.

Excel differs here: GOOGLETRANSLATE is a Google Sheets function, not a standard Excel function. If you move the file to Excel, do not expect those formulas to calculate there. Keep translated values, use an available translation tool in your chosen application, or select a workflow specifically supported by that application.

Frequently Asked Questions

Can Google Sheets translate an entire sheet at once?
There is no need to replace the original sheet to translate its text: add a translation column and fill a GOOGLETRANSLATE formula down the rows. Review the results and paste values if you need fixed text. This approach does not translate words inside images, charts, or other non-cell content.

What is the formula to translate a cell into English?
If the source text is in A2, use =GOOGLETRANSLATE(A2,"auto","en") in the destination cell. Replace auto with a source language code, such as es for Spanish, when you know the language.

Can I translate English back into another language?
Yes. Keep the text in the first argument, then use the source and target language codes in that order. For English in A2 and Spanish as the desired output, use =GOOGLETRANSLATE(A2,"en","es").

Will translating a cell overwrite the original?
No. The formula displays its result in the cell where you enter it. Put that formula in a different column to retain the source. Overwriting can happen only if you deliberately replace the source cell or paste values over it.

Why does GOOGLETRANSLATE return an error?
Check the language codes, formula separators, and source cell first. A locale may require semicolons instead of commas. A temporary connection or service problem can also interrupt results, so test one cell and retry before rebuilding the sheet.

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.