How to Translate an Excel File Without Breaking Formulas

To translate an Excel file without breaking it, translate only the text in the cells and leave formulas, numbers and cell references exactly as they are. The safest way is a document translator that opens the XLSX file and swaps the text in place, so you get the same workbook back. Copying columns into a translation box and pasting them back works for a few cells, but it's slow and easy to misalign. The one thing most people miss: formulas that compare against text can stop working after translation, so check those before you start.

This guide covers what should and shouldn't be translated in a spreadsheet, the common ways translation breaks a workbook, and how to check the result.

What should be translated in a spreadsheet (and what shouldn't)

A spreadsheet mixes words people read with values the workbook calculates with. Only the first group should change.

Usually translate:

Column headers and row labels
Descriptive text in cells (product descriptions, notes, comments)
Chart titles and axis labels
Sheet names, if nothing refers to them (more on that below)

Leave alone:

Formulas (=SUM(B2:B20), =VLOOKUP(...)). The function names and cell references must stay intact.
Numbers, dates and currency values. A translator should never rewrite 1,250 or 03/04/2026.
Codes and IDs: SKUs, invoice numbers, postcodes, email addresses, URLs.
Values other cells look up (see the next section).

Note that you don't need to translate function names. Excel shows them in the language of your Excel installation (for example SUMME instead of SUM in German Excel) and converts them automatically when the file is opened elsewhere. The formula stored in the file stays the same.

The trap: formulas that match on text

This is how translated workbooks most often break, and it's easy to miss because nothing looks wrong at first.

Imagine a formula like:

=IF(C2="Paid", D2, 0)

The word "Paid" is inside the formula. If the translator changes the cell C2 from "Paid" to "Pagado" but (correctly) leaves the formula alone, the comparison no longer matches, and every row quietly returns 0.

The same thing happens with:

Lookups (VLOOKUP, XLOOKUP, INDEX/MATCH) that search a column for a text value.
COUNTIF / SUMIF with text criteria, such as =COUNTIF(E:E, "Open").
Drop-down lists (data validation) whose allowed values are a list of words.
Pivot tables and filters that group by a text category.
Formulas that name another sheet (='Sales 2026'!B4). If the sheet is renamed during translation, the reference has to change with it.

How to handle it:

Before translating, search the workbook for formulas containing quotes (Ctrl+F, look in Formulas, search for ").
Decide, column by column, whether those "key" values should stay in the original language (often the simplest option) or be translated everywhere, including inside the formulas.
If you translate them, update the formulas and drop-down lists to the new words, then recalculate.

Option 1: Translate cells inside Excel

Excel has a built-in Review > Translate pane for selected text; Microsoft lists it for Microsoft 365 subscribers and Office 2021, with an internet connection. It's handy for a few labels, but Microsoft notes that in Excel there's no Insert button: you copy the translation and paste it back yourself. For anything beyond a handful of cells, that gets slow.

Option 2: Translate the whole XLSX file

A document translator that understands the XLSX format can translate the whole workbook in one go and hand back an XLSX with:

the same sheets, columns and cell formatting,
the same formulas and numbers,
translated text in the cells and headers.

That's what DropTranslate's Excel translator does. It translates the text in your cells and leaves numbers and formulas as they are, so you download the same workbook, translated. It still can't know which of your words are "keys" that other formulas depend on, so do the check above first.

Before you translate: prepare the workbook

Make a copy and translate the copy. Keep the original for reference and for comparison.
Remove what you don't need: hidden sheets with old data, scratch columns and unused ranges all cost time (and, with most tools, credits).
Turn text formulas into values where it makes sense. If a column is built with =A2&" "&B2, consider copying it and using Paste Special > Values, so the translated text doesn't get rebuilt from untranslated parts.
Check merged cells and fixed column widths. Longer translations may need wider columns or wrapped text.

After you translate: check these

Totals and key results match the original. If a total changed, a text-matching formula is the usual suspect.
Drop-down lists still offer valid values, and existing cells still pass validation.
Pivot tables refresh without errors.
Charts show translated titles and labels.
Column widths: text such as German or Portuguese headers may now be cut off.
Number and date formats: the values should be untouched; switch display formats only if your readers expect local ones.

Translating product lists and CSV exports

If your spreadsheet is a product catalogue or a marketplace export, the same rules apply: translate titles and descriptions, and leave SKUs, prices, barcodes and category IDs alone. For plain CSV files, make sure the file is saved as UTF-8, so accented letters and non-Latin scripts survive the round trip.

Frequently asked questions

Will translating my Excel file change my numbers?

It shouldn't. A good spreadsheet translator only touches text. Still, compare a few totals before and after, especially if your formulas compare against words.

Can I translate just one column?

Yes. Either copy that column into a new workbook and translate that file, or use the Review > Translate pane for a few cells. Translating a separate copy keeps the rest of your workbook untouched.

Do I need to translate Excel function names like SUM or IF?

No. Excel displays function names in the language of the Excel installation and converts them automatically. Translating them by hand breaks the formula.

What about Google Sheets?

Download the sheet as Microsoft Excel (.xlsx), translate that file, and upload the result back to Google Drive.

Summary

Translate the text, never the formulas or numbers. Before you start, find formulas that match on words (IF, lookups, COUNTIF, drop-downs) and decide whether those values stay in the original language. Translate a copy of the XLSX in one go, then check totals, drop-downs and pivots. For other file types, see how to translate a document.

Drop your spreadsheet into DropTranslate and get the same workbook back, translated.