How to Translate Text in Google Sheets with GOOGLETRANSLATE

To translate text in Google Sheets, enter a formula such as =GOOGLETRANSLATE(A2,"auto","es") in an empty cell, replacing A2 with the cell that contains your text and es with the target language code. The function returns a machine translation in the formula cell, so you can keep the original text and translate a whole column without leaving your spreadsheet. You need a Google account, a sheet open in a web browser, and an internet connection.

What You’ll Need

A Google account with access to the Google Sheets file. You can use a file you own or one shared with you, provided you have permission to edit it.
The original text in one or more cells, ideally with a column heading and one item per row.
The target language, and its language code. For example, use en for English, es for Spanish, fr for French, or ja for Japanese.
An internet connection. GOOGLETRANSLATE uses Google’s translation service, so it may not return a result while offline.

No add-on or separate translation software is required. Because the text is processed by an online service, follow your organization’s data-handling rules and avoid translating sensitive information in a sheet unless you are permitted to do so.

Step-by-Step

Open your spreadsheet and organize the source text. In a web browser, go to Google Sheets and open the file. Put the original text in a single column, such as column A, with a heading in A1 and the first item in A2. One sentence or short entry per row is easiest to review and fill down. Keep the source column intact: putting translations in a separate column makes it possible to compare the result with the original and correct errors later.
Choose the target language and code. Decide which language the output should use before entering the formula. Google Sheets uses language codes rather than a menu of language names in the function. Common codes include en for English, es for Spanish, fr for French, de for German, it for Italian, pt for Portuguese, and ja for Japanese. If you are unsure of a code or need a particular regional variant, check Google’s current language-code list rather than guessing.
Click the cell where the translation should appear. If the original text is in A2, click B2. Add a heading such as “Spanish translation” in B1 if you want the columns to be easy to identify. Do not put the formula over the source text; a formula in the same cell would replace what you typed there.
Enter the translation formula. With the text Hello in A2, enter this formula in B2: =GOOGLETRANSLATE(A2,"auto","es"). It asks Sheets to detect the source language automatically and translate the contents of A2 into Spanish; for Hello, the expected result is Hola. Press Enter to calculate it. The first argument is the text or cell reference, the second is the source language, and the third is the target language. The target must be a language code, not the word “Spanish.”
Specify the source language when you know it. Automatic detection is convenient for mixed or unfamiliar source text, but naming the source can help when entries are short, contain names, or could belong to more than one language. For example, if A2 contains Good morning in English and you want French, enter =GOOGLETRANSLATE(A2,"en","fr") in B2. The expected result is Bonjour. Keep the target code as the last argument; swapping the source and target changes the direction of translation.
Translate the remaining rows. After B2 returns a result, select B2 and move the pointer to the small square at the cell’s lower-right corner, called the fill handle. Drag it down alongside the source entries. Sheets adjusts the relative reference, so the next row uses A3, then A4, and so on. You can also copy B2, select the destination range in column B, and paste. Check a few rows, especially the first and last, to confirm that each result corresponds to the source text beside it.
Keep empty source rows empty, if needed. Filling a formula down past the end of your list can produce unnecessary results or errors for blank cells. With the source text in A2, enter =IF(A2="","",GOOGLETRANSLATE(A2,"auto","es")) in B2, then fill down. If A2 is empty, this formula returns a blank; if A2 contains Hola, it translates the text and returns Hello in English only if you change the target code from es to en. For a Spanish target, a Spanish source word may remain or be translated according to the language service’s result.
Review the translations before using them. Read the output beside the original and check names, numbers, dates, punctuation, tone, and context. A formula can provide a useful draft, but it does not guarantee a natural or correct translation. For public-facing, legal, medical, safety, or other consequential text, have a qualified person review the result before relying on it.

Google Sheets formulas recalculate as their inputs change, so editing a source cell can update its translated result. If you need to preserve a translation exactly as it appears at a particular moment, copy the translated cells and use Edit > Paste special > Values only. This replaces the formulas in the selected destination cells with their current displayed values, so keep a copy of the formulas if you may need them again.

Common Mistakes

Using a language name instead of a code. The function expects codes such as en and es, not “English” or “Spanish.” Check the code for the language you want and use it in the third argument.
Putting the arguments in the wrong order. The format is text, source language, target language. The source may be auto, but the destination needs to be explicit. If the output is in the wrong language, inspect the second and third arguments first.
Replacing the original text. Typing a formula into the source cell overwrites its contents. Put formulas in another column and retain the original as a reference.
Assuming a literal translation preserves meaning. Idioms, jokes, product names, abbreviations, and specialized terms can be translated awkwardly or incorrectly. A fluent reviewer may be necessary when accuracy or tone matters.
Filling down without checking references. A copied formula should point to the source cell on the same row. If you see repeated translations, check that the source references advance instead of being fixed to one cell.
Expecting the result to be permanent. A formula result can change when the source changes or the function recalculates. Paste values only when you deliberately need a fixed snapshot.

Tips

Use clear headings. Label the original and translated columns with the language names. This reduces the chance of editing the wrong column, especially when a sheet contains several translations.
Translate in manageable pieces. For long paragraphs, split text at sensible sentence or paragraph boundaries. Smaller entries are easier to compare, correct, and trace back to the source. Avoid splitting a phrase in the middle if its meaning depends on the surrounding words.
Use automatic detection selectively. The auto source setting is useful when the language is unknown, but very short words, codes, or names may be ambiguous. If every row is in the same known language, use its code as the source argument.
Keep a review column. Add a column for reviewer notes or a status such as “Needs review” and “Approved.” This helps separate an initial machine translation from a checked, publishable version.
Test a few entries first. Before filling a large range, translate representative examples, including a question, a longer sentence, and any specialized vocabulary. Confirm the target language and quality, then extend the formula if the results are suitable.
Consider the spreadsheet locale. The examples here use commas between formula arguments. Some Google Sheets locales use semicolons as separators. If Sheets reports a formula parse error despite correct references and codes, check the file’s locale under File > Settings and use the separator expected by that sheet.
Remember that Excel is different. GOOGLETRANSLATE is a Google Sheets function, not a standard Excel worksheet function. Opening the file in Excel will not make this formula an Excel translation feature; use a method supported by the application you are working in.

Troubleshooting

The cell shows a formula parse error. Make sure the formula starts with =, has balanced parentheses, and uses straight quotation marks around text arguments. Confirm the commas are appropriate for the spreadsheet’s locale; if that locale expects semicolons, replace the argument separators accordingly. Also check that the function is spelled GOOGLETRANSLATE with no spaces.

The cell returns an error or no translation. Check that the first argument refers to a cell containing text, and that the source and target codes are recognized. Use a short, plain-text test entry to see whether the issue is tied to the content. If a simple test also fails, confirm the browser is online and reload the sheet. A temporary service or connectivity problem may prevent the result from appearing; try again later rather than repeatedly editing a working formula.

The output is in the wrong language. Read the formula from left to right: first the source text, then its language code or auto, then the destination code. For example, "en","fr" means translate from English to French. A short phrase may be detected as a different language, so set the source code explicitly when you know it.

Every row shows the same translation. Click two or three result cells and inspect their formulas. If each one references A2, the formula may have been copied as fixed text or may contain an absolute reference. For a normal fill-down, the formulas should refer to A2, A3, and A4 in their respective rows. Copy the working formula in the first result row and fill it down again.

Some entries are blank or oddly translated. Check whether the source cell is actually empty, contains only spaces, or includes line breaks or unusual formatting characters. Try copying the text into a plain cell and translating a shorter, cleaner version. If the translation itself is grammatically unnatural, that may reflect ambiguity or the limits of machine translation rather than a spreadsheet error; rephrase the source or ask a fluent speaker to review it.

The result changes after you have reviewed it. The output is formula-driven, not a locked translation. If you need to retain an approved version, copy the result and paste values only into a separate final column or document the approved wording elsewhere. Keep the original and, if useful, the formula column so the fixed text remains traceable.

Frequently Asked Questions

Can Google Sheets translate an entire column?
Yes. Put a translation formula in the first result row, then use the fill handle or copy and paste it down the column. Check that each filled formula refers to the source cell on its own row.

Can I let Google Sheets detect the source language?
Yes. Use auto as the source-language argument, as in the example above. Automatic detection can be unreliable for very short text, names, or mixed-language entries, so specify a source code when you know it.

Can I translate text into English from another language?
Yes. Use the original text as the first argument, its language code or auto as the second, and en as the target code. For example, a Spanish source can use "es","en".

Does GOOGLETRANSLATE work in Microsoft Excel?
No. It is a Google Sheets function. Excel does not support it as a standard worksheet formula, so choose a translation option available in the version of Excel or another tool you use.

Can I edit the translated words directly?
You can replace a formula with typed text, but that removes the automatic link to the source. If you want to retain both, keep the formula result in one column and put human edits or approved wording in another.

Is the translation suitable for official or sensitive material?
Do not assume an automatic result is authoritative. Follow your organization’s privacy requirements before sending text to an online service, and have a qualified translator review material where a mistake could have serious consequences.

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.