How to Translate an Excel File to English (Tested Methods)

Quick Answer

There's no single "translate this entire file" button in Excel. For text in cells, use the TRANSLATE function (Microsoft 365) or the Review-tab Translator column by column. For free bulk translation, route the file through Google Sheets. To translate a whole workbook while preserving layout, a dedicated file-translation tool is usually the cleanest option — though it means uploading your file to a third party.

How We Tested These Methods

We tested these methods on a sample workbook of 96 rows across multiple sheets, in English, Spanish, French, German, Japanese, and Chinese, checking whether each method translated all content, preserved formatting, and handled multiple sheets.

How to Translate a Whole Excel File to English

There's no one-click "translate entire file" in Excel, so the right approach depends on how much content you have, how important formatting is, and which tools you have access to. The three main routes:

1. Microsoft Translator (Review tab) or the TRANSLATE function for translating selected cells or columns
2. Google Sheets for free, formula-driven bulk translation
3. A dedicated online Excel translator tool when you need the full file translated with formatting preserved

Method 1 — Microsoft Translator / TRANSLATE Function

To translate content within Excel, you have two Microsoft-backed options.

The Review-tab Translator handles selected text. Note, per Microsoft's documentation, that this tool has no insert button — you copy the result back manually:

1. Select the cells you want to translate.
2. Go to the Review tab and click Translate.
3. Set the From language (or auto-detect) and To as English.
4. Copy the translated text from the pane into your sheet.

Microsoft 365 users can also translate whole columns with a formula like =TRANSLATE(A2, , "en"), repeated across each column and sheet.

Method 2 — Translate via Google Sheets

Google Sheets offers a free, formula-based way to translate in bulk, which you can bring back into Excel:

1. Upload your Excel file to Google Drive and open it as a Google Sheet.
2. In an empty column, use =GOOGLETRANSLATE(A1, "auto", "en") to translate column A into English.
3. Drag the formula down, and repeat for each column you need.
4. Download the sheet back as Excel (File → Download → Microsoft Excel).

Method 3 — Dedicated Online Excel Translator Tool

When you need the entire file translated with the layout kept intact, a dedicated document-translation tool is often the cleanest option. These services let you upload an Excel file, choose your target language, and download a translated copy that mirrors the original structure. Our own tool, ExcelTranslator.ai, is one such option; here are its concrete details so you can judge whether it (or any tool) fits your needs:

• Supported file formats: XLS, XLAM, XLSM, XLSX, XLTM, XLTX, and CSV.
• What's preserved: Original layout, formatting, formulas, merged cells, and cell styles are kept intact after translation.
• Selective translation: You can exclude specific columns, rows, or sheets — useful for keeping IDs, codes, or reference data untranslated — and define a custom glossary for consistent terminology.
• File handling / privacy: Files are uploaded for processing, retained for 14 days, then automatically deleted. You can also delete them immediately at any time.
• Pricing: Pay-as-you-go based on text volume ($0.50 per 1,000 tokens, with automatic volume discounts; $5 minimum). A free preview of part of the file is available before you pay.
• Not suitable for: Embedded images aren't translated (text inside images is billed at 2× when it is). As with any cloud tool, weigh uploading highly confidential data.
• How it differs from Excel's built-in TRANSLATE: It translates the whole file at once while preserving layout, rather than working cell by cell, and adds glossary support, selective exclusion, and handling for larger files.

How to Change the Display Language of Excel

A quick but important distinction: translating your data is not the same as changing Excel's interface language. If your menus and buttons are in another language and you want them in English, that's a settings change, not a translation:

1. Go to File → Options → Language.
2. Under Office display language, add English and move it to the top.
3. Click Set as Preferred, then restart Excel.

This changes Excel's interface (menus and help), not the content in your cells. To translate the actual data, use one of the methods above.

Best Excel Translator Tools Compared

When choosing a dedicated tool, weigh these factors:

There's no single "best" tool for everyone — it depends on your file size, how much formatting matters, and your privacy requirements. For a one-off, lightly formatted file, the free Google Sheets method may be all you need. For client-facing workbooks where layout matters, a paid tool that preserves formatting can be worth the cost.

How to Keep Formatting After Translation

• Translate values, not whole files, when layout is critical. Use formulas in a parallel column so originals stay intact, then swap in the translations.
• Watch text length. Translated text is often longer or shorter than the original, which can break column widths and merged cells. Adjust after translating.
• Keep a backup. Always translate a copy, never your only version.
• Use a tool that explicitly preserves formatting if your workbook has complex styling, charts, or images — formula methods won't carry these over.

Frequently Asked Questions

Sources and Update Notes