The hidden problem with translating Excel

When you copy-paste a spreadsheet into Google Translate or DeepL, three things break: formulas turn into translated text, cell references shift, and conditional formatting disappears. The result is a worksheet that looks right but no longer calculates anything.

This matters most for finance, logistics, and HR teams who share workbooks across regions. A monthly forecast that suddenly shows =SUMA(A1:A10) instead of =SUM(A1:A10) is worse than no translation at all.

What a layout-preserving translator does

A proper Excel translator recognizes three layers:

  • Static text — column headers, labels, comments. These get translated.
  • Formulas — anything starting with =. These stay untouched.
  • Formatting — cell colors, borders, conditional rules. These get carried over.

The tool walks each cell, decides whether the content is a formula or a value, and only sends translatable content to the language model.

Step-by-step with DocTranslate

  1. Open DocTranslate and click Upload.
  2. Drop your .xlsx or .xls file. Files up to 50 MB are supported.
  3. Pick the source language (or use Auto-detect).
  4. Pick the target language. DocTranslate covers 100+ languages.
  5. Click Translate. Most workbooks finish in under 30 seconds.
  6. Download the translated .xlsx. Open it — formulas still work, formatting is preserved.

When this falls short

A few edge cases to know about:

  • Macros (.xlsm files) — VBA code is not translated. The macro itself runs the same, but UI strings inside the macro stay in the source language.
  • External references — links to other workbooks ([other.xlsx]Sheet1!A1) are kept as-is. If the target file has a translated name, those links break.
  • Custom number formats — currency symbols and date orders follow the source locale. You may want to manually adjust to the target locale afterwards.

Bottom line

For most spreadsheets — budgets, inventory lists, HR rosters, project trackers — a layout-preserving translator turns a 30-minute manual job into a 30-second one without breaking anything. Test it on a copy first, then trust it for the rest of the workbook.