If a Google Translate formula is not working in Excel, the main issue is that Excel does not include a built-in GOOGLETRANSLATE function. That function belongs to Google Sheets; in Excel, typing it usually produces a #NAME? error, and changing commas, language codes, or cell references will not make it available.
Why Google Translate formulas fail in Excel
Excel and Google Sheets have different sets of worksheet functions. Google Sheets provides GOOGLETRANSLATE, while Microsoft Excel for Microsoft 365 on Windows does not provide an equivalent function with that name. A formula that works in a Google Sheets file is not automatically supported when the file is opened in Excel.
For example, Google Sheets can translate text in A2 from English to French with =GOOGLETRANSLATE(A2,"en","fr"). That is a Google Sheets formula, not an Excel formula. If you enter it in Excel, Excel cannot resolve the function name and will commonly show #NAME?. The same applies if you paste it into a cell in an Excel workbook stored on OneDrive or open in a browser: the storage location does not turn Excel into Google Sheets.
Regional settings can change whether Excel formulas use commas or semicolons between arguments, but that is not the cause here. A separator change can help with a supported Excel function that is being parsed incorrectly. It cannot add a function Excel does not have. Likewise, changing the source and target language codes will not fix an unsupported function name.
What Excel’s Translate feature can do
Excel includes a Translate command in many Microsoft 365 installations, but it is a tool for translating selected text, not a worksheet function that calculates translations down a column. In Excel for Microsoft 365 on Windows, select a cell or text, then choose Review > Translate. The Translator pane opens, where you can choose the source and target languages and view a translation. The available controls can vary with the installed Office build and connected experiences.
This option is useful for occasional translations or short lists. It does not behave like a formula: it will not automatically translate every row, recalculate when the source text changes, or fill new translations as you add rows. If the translation needs to become cell content, use the controls offered in the pane if available, or copy the result and paste it into the desired cell. Check the result before replacing the original text.
- Windows: In Excel for Microsoft 365, look under Review for Translate. If the command is missing, update Office and check whether connected experiences are enabled by your organization.
- Mac: Excel for Mac has a Review tab, but the command’s availability and interface can differ by version and account. If Translate is absent, use a browser-based translation service or an approved translation workflow instead.
- Excel for the web: The ribbon and available translation features can differ from desktop Excel. If you cannot find the command, do not assume a worksheet formula is available; use a supported online tool and paste the reviewed result back.
Check the error before changing your workbook
The error message can help distinguish an unsupported function from an ordinary cell-reference problem. In this case, the key question is whether the function exists in Excel at all. If Excel displays #NAME? for GOOGLETRANSLATE, it is generally reporting an unrecognized function name, not a failure to reach Google’s translation service. Excel is not sending that formula to Google.
Before troubleshooting further, check these points:
- Confirm that the file is actually open in Microsoft Excel, rather than Google Sheets. The application name and ribbon make this clear.
- Check whether the formula was copied from a Sheets guide or another workbook. A function supported in one spreadsheet app may not be supported in another.
- Do not treat a change from commas to semicolons as a translation fix. It only addresses argument separators for functions Excel recognizes.
- If you used Excel’s Review > Translate command, check your internet connection, selected languages, and any organization settings that restrict online connected features.
- Keep the original text in a separate column. Translation can change meaning, and overwriting the source makes it harder to review or correct.
Translate a small number of cells manually
For a handful of entries, Excel’s Translate pane or a trusted translation website is usually the simplest route. Put the original text in one column and the reviewed translation in another. For instance, keep customer comments in column A and place approved translations in column B. This layout makes it possible to compare the source and translation, correct terminology, and retain an audit trail.
For a larger but still manageable list, copy a limited batch into a translation tool, preserve row order, and paste the results into a new column. Avoid pasting a whole data table into a public website if it includes names, account details, confidential material, or other sensitive information. Check that line breaks and punctuation have not shifted the alignment between source and translated rows.
Machine translation is useful for understanding general meaning, but it is not a guarantee of a publication-ready or legally reliable translation. Product names, abbreviations, idioms, technical vocabulary, and short phrases without context are particularly likely to need review. For customer-facing or regulated material, have a qualified person check important translations.
Options for translating many rows automatically
If translations must be generated repeatedly or for hundreds of rows, use a supported translation service rather than trying to make Excel run a Sheets-only function. One route is the Google Cloud Translation API. It is a separate Google Cloud service, not the consumer Google Translate website and not an Excel formula. It requires a Google Cloud project and suitable credentials; usage may incur charges under the service’s current pricing and account terms.
A developer or administrator can connect an approved API workflow to Excel using tools such as Power Query or a controlled application. The setup depends on authentication, the service’s current API requirements, data volume, and how results should be stored. Do not paste a private API key into a worksheet that will be shared: workbook readers may be able to see it. Use an organization-approved method for storing credentials, and test with non-sensitive sample text first.
Microsoft’s translation services may also be available through Microsoft cloud products and organizational workflows. Availability, setup, pricing, and permissions depend on the specific service and tenant. Ask an administrator or developer to confirm the correct supported connector and data-handling rules rather than relying on an unverified formula found online. Excel’s WEBSERVICE function is not a general-purpose replacement for an authenticated translation API, and a copied web request can stop working when a provider changes its service.
Choose the right alternative
The best choice depends on how often you translate, how much text is involved, and how sensitive the content is. A one-off translation does not need an automated connection, while a recurring process should be designed so that it can be maintained and reviewed.
- Occasional text: Use Excel’s Review > Translate command where available, or use an approved translation website and paste the result into a separate column.
- Work already done in Google Sheets: Use the Sheets function there, then export or download the finished file as an Excel workbook if needed. Recheck the workbook after export; Sheets-specific formulas may not remain functional in Excel.
- Recurring business process: Ask an administrator or developer to assess an official translation API and an approved automation method. Include authentication, usage costs, failure handling, and human review in the design.
- Confidential or high-stakes content: Follow your organization’s privacy rules and use an approved service. Arrange qualified review when a mistranslation could have serious consequences.
Moving a workbook between services is not a reliable way to make an unsupported formula work. A formula may calculate in Sheets but appear as an unsupported formula or a value in Excel, depending on how the workbook is exported and opened. If the workbook must be maintained in Excel, choose a workflow that is explicitly supported in Excel or store reviewed translations as values.
Privacy, reliability, and translation quality
Translation tools usually need to process the text being translated. Excel’s Translator feature relies on online connected functionality, and API-based translation sends text to the selected provider. Before using either option for work data, check the service and your organization’s policies. Do not assume that a workbook being saved locally means text sent to an online translation tool stays local.
Automated translations can also vary with context. A single word such as “charge” may mean a fee, an accusation, or an electrical property. A service translating one cell at a time may not know the surrounding paragraph or the organization’s preferred terminology. For consistent output, provide context where the chosen service supports it, maintain a glossary for recurring terms, and review a sample before translating a large batch.
Keep source text unchanged and record which translation method was used if the results will be reused. For important documents, treat machine output as a draft. Review numbers, dates, names, units, negations, and instructions especially carefully; a fluent-sounding sentence can still contain a consequential error.
Frequently Asked Questions
Does Excel have a GOOGLETRANSLATE function?
No. GOOGLETRANSLATE is a Google Sheets function, not a built-in function in Excel for Microsoft 365. Excel’s Review > Translate command is a separate interactive tool, not a formula.
Why does GOOGLETRANSLATE return #NAME? in Excel?
Excel does not recognize the function name, so it reports an unrecognized name. The error is not normally caused by a missing internet connection or an incorrect language code. Use a supported translation method instead.
Can I use a Google Sheets formula in an Excel workbook?
Not as a working Excel formula if Excel does not support that function. You can calculate translations in Google Sheets and then transfer reviewed results, but check the workbook after exporting because Sheets-specific formulas may not work in Excel.
Can Excel translate an entire column automatically?
The Review > Translate feature is intended for selected text, not automatic formula-based translation of a whole range. For a large recurring workload, use an approved API or automation workflow, or translate in batches and review the results.
Is there a free Google Translate formula for Excel?
There is no built-in free Google Translate formula in Excel. Google Sheets has its own translation function, while Google Cloud Translation is a separate API service with its own setup and current pricing terms. Check those terms before building an automated process.
Related
- Find and Replace Tab Names in Excel: What Actually Works
- Excel Fill Down Shortcut: Use Ctrl+D to Copy a Column
- Fill an Excel Column With Weekday Dates Automatically
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel TEXT Function for Dates: Format Dates as TextUse Excel’s TEXT function to display a date in a chosen written format: if A2 contains the date…
- Excel IFS Between Two Dates: Formulas and ExamplesTo check whether a date falls between two dates in Excel, put an AND test inside IFS: IFS(AND(date>=start,date<=end),result,TRUE,other_result).…
- Smartsheet SUMIF Examples for Everyday ReportsIn Smartsheet, SUMIF adds values in a sum range only when corresponding cells meet one condition. For example,…
- Excel EOMONTH Formula: Find the Last Day of a MonthUse Excel’s EOMONTH function to return the last day of a month: enter =EOMONTH(start_date, months), replacing the arguments…
- What-If Analysis in Excel: A Step-by-Step GuideTo add what-if analysis in Excel, open the Data tab and choose Forecast > What-If Analysis, then select…
- Excel ISBLANK Function Example: Formulas and TipsIn Excel, use =ISBLANK(A2) to test whether cell A2 is genuinely empty; it returns TRUE if the cell…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.