Document Editing Problems

How to Translate an Entire Excel Worksheet in Microsoft 365

Maira Mehtab Sep 21, 2026 868 views

Question details

The user needs a method to translate an entire worksheet or table into another language while keeping the original cell layout and formatting intact.

Product: Microsoft Excel 365
Device & OS: not provided
Scenario: Translating large tables or full spreadsheets for multilingual audiences without manually translating cell by cell.
Observed behavior: Excel's built-in Translator currently only supports translating selected text and lacks a direct option to translate and replace an entire worksheet or table simultaneously.

Before you start

Create a duplicate copy of your Excel workbook before attempting any translation workarounds to ensure your original data, formatting, and formulas are safely preserved.

Solution 1Recommended

Use Microsoft Word as a Translation Intermediary

Since Excel lacks whole-sheet translation, copying your table to Microsoft Word allows you to leverage Word's full document translation feature, then paste it back.

This method is highly effective for keeping cell formatting intact, as Word and Excel share similar table structuring capabilities.

Copy the Excel table

Select the entire table or data range in your Excel worksheet that you want to translate and press Ctrl+C to copy it.

Paste into Microsoft Word

Open a blank Microsoft Word document and press Ctrl+V to paste the copied table.

Translate the document in Word

Navigate to the 'Review' tab on the Word ribbon, click 'Translate', and select 'Translate Document'. Choose your target language and click translate.

Paste back into Excel

Highlight and copy the newly translated table in Word. Return to your Excel worksheet and paste it using the 'Match Destination Formatting' option to retain your original layout.

Solution 2

Translate Using Google Translate or DeepL

Upload your entire workbook to an external, web-based translation service to translate all text at once while maintaining the .xlsx file format.

Seamless Spreadsheet Translation

Use WPS Spreadsheets for Easy Document Translation

WPS Office provides highly compatible spreadsheet tools equipped to handle your multilingual data efficiently. It supports all standard Microsoft Excel formats and streamlines document localization tasks.

1. Open your workbook: Launch WPS Spreadsheets and open your .xlsx workbook.
2. Access review tools: Navigate to the 'Review' tab on the top ribbon to explore the available proofing and localization tools.
3. Translate content: Use the built-in translation utilities to convert your required text into the desired target language.
4. Save the file: Save your translated workbook directly, ensuring all your original formatting is kept perfectly intact.

Fully compatible with Microsoft Excel (.xlsx) formatsBuilt-in smart tools to aid multilingual workflowsPreserves complex cell layouts and formatting effortlesslyLightweight, fast, and free to use as an everyday Office suite

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't Excel have a whole-worksheet translation feature?

Microsoft 365 Excel currently focuses its translation capabilities on selected text or individual cells to ensure accuracy. Whole-sheet replacement is not natively supported yet, so users must rely on Word or external tools.

Will I lose my Excel formulas when using Google Translate for documents?

Yes, it is possible. When uploading a workbook to external services like Google Translate, standard text is translated, but complex formulas, charts, or macros may be converted to plain values or removed entirely. Always keep a backup of your original file.

How can I submit a feature request to Microsoft for Excel translation?

You can submit feedback directly within the Excel application by clicking 'Help' on the ribbon, selecting 'Feedback', and clicking 'I have a suggestion' to request a whole-worksheet translation feature.

Document & File Issues