How to Translate an Excel File and Keep the Formulas Working

To translate an Excel file and keep it working, translate the text in the cells of the XLSX file itself instead of copying it out. Formulas, numbers, dates and formatting stay where they are, and only the words change. This guide covers how to prepare the workbook, the things to check once it’s translated, and the quickest way to get it done.

Why Not Copy and Paste the Cells?

Pasting a column into a translation box and back works for a dozen cells. For a product catalog or a price list it means thousands of cells, and one row pasted out of line puts every description next to the wrong product, which nobody notices until a customer does. Translation tools also like to reformat numbers, decimal separators and product codes on the way through. Translating the file itself skips all of that: each translated text goes straight back into the cell it came from, and cells holding numbers and formulas are never touched.

How to Prepare an Excel File for Translation

A few minutes in Excel before you send the file saves most of the fixing afterwards.

1. Unhide what needs translating, hide what doesn’t. Hidden rows, columns and sheets are left out by default. That makes hiding a quick way to skip internal columns such as SKUs, supplier notes or the source language you’re keeping. Rows hidden by a filter or a collapsed group count as hidden too, so clear filters and expand groups before you upload. If hidden content does need translating, unhide it or switch it on for the file in Taia.
2. Keep one piece of text per cell. A sentence split across two cells is translated as two fragments, and the halves often stop making sense in the other language. Merge them into one cell, and use Alt+Enter (on Windows) for a line break inside a cell.
3. Don’t build text with formulas. A formula such as ="Total for "&A2 keeps its words in the original language, because formulas aren’t translated. Put the words in their own cell and refer to it instead.
4. Leave codes and numbers in their own cells. “Size M, 250 ml” in one cell is fine, but an article number or a price typed into a description is text, and it goes to the translator along with the words.
5. Leave room for longer text. German often runs 20 to 30% longer than English. Turn on Wrap Text for description columns, or plan to widen them afterwards.
6. Delete comments nobody needs. Comments on cells are translated along with the text, and they count toward the word count.
7. Decide about sheet names, text boxes and SmartArt. Sheet tab names, text in shapes and text boxes, and SmartArt are left as they are by default. Switch them on for the file in Taia if they carry words a reader will see.

Things to Check After Translation

• Column widths and row heights. Look for cells where the longer translation is cut off or spills into the next column.
• Charts. Chart titles and labels are translated along with the cells. Check that they still fit.
• Formulas that compare text. A formula that checks for a word, such as =IF(B2="Yes",...), still looks for the original word after the cell says “Ja” in German. Check lookups and conditions that match on text.
• Fonts. A font without the characters a language needs falls back to another one. Check languages with their own alphabet, such as Greek, Russian, Chinese or Arabic.

How to Translate an Excel File with Taia

Taia is an online translation platform that reads Excel files directly, so you upload an XLSX and download a translated XLSX.

1. Upload the .xlsx file at translate.taia.io and pick your target languages. One project can take as many languages as you need.
2. Choose what gets translated. The gear next to the file lets you include hidden rows, columns and sheets, sheet tab names, text in shapes and text boxes, and SmartArt. How the file options work
3. Choose AI or a professional translator. AI gives you a first draft of the whole workbook in minutes, which you or someone on your team can then review. For price lists, product data and anything customer-facing, a professional linguist can translate and review it instead.
4. Download the translated XLSX and give it a final look in Excel.

What it takes care of for you:

• Formulas and numbers stay put. Text in cells, comments and charts is translated. Formulas, numbers, dates, cell formatting and the order of your sheets come back exactly as they were, so the workbook still calculates.
• Only text is counted. Cells holding numbers, dates or formulas never reach the word count, so only text uses credits or goes into a quote.
• Your terminology carries over. On Pro, a glossary and a translation memory keep product names and recurring descriptions the same in every file, which matters in a catalog where the same phrase appears on hundreds of rows. More on that in catalog translation.
• AI and people in one place. Start with AI, and order professional translation on the same platform when a workbook needs it.

How Much Does It Cost?

Excel files are included on every plan, including Free, with 5,000 credits a month (5,000 words with Standard AI). Basic is €9/month for 20,000 credits (20,000 words with Standard AI). Pro is €39/month for 100,000 credits (100,000 words with Standard AI), adds all 204 languages, translation memory and glossary, and also takes older .xls files, macro-enabled .xlsm workbooks and Excel templates. Professional translation is billed per word from €0.06, with no subscription. Taia handles 65+ formats, including Word and CSV (from Basic) if your content also lives there.

Frequently Asked Questions

Can I translate an Excel file for free?

Yes. Excel files are included on Taia’s Free plan, with 5,000 credits a month (5,000 words with Standard AI). You get a translated XLSX back, not just the text.

Can I use Excel’s own Translate tool or Google Translate?

Yes. For a quick read of a few cells that’s often enough. What you don’t get is a say in what gets translated (hidden rows, sheet names, text boxes), a glossary and translation memory that keep your terms the same in every file, or a person who can review the result in the same place.

Will my formulas still work after translation?

Yes. Formulas are never translated or changed, so a SUM or a VLOOKUP calculates exactly as before. The one thing to watch is a formula that matches on a word, such as =IF(B2="Yes",...), because the cell it checks now holds the translated word.

Are numbers and dates translated?

No. Cells that hold numbers, dates or formulas are left exactly as they were and aren’t counted in the word count. A number typed as text, such as a product code inside a description, is sent for translation with the words around it.

Are hidden sheets, rows and columns translated?

Not by default. Hidden rows, columns and sheets come back untranslated and aren’t counted. You can switch them on for a file in Taia before you start.

Are sheet tab names translated?

Not by default. Sheet names stay as they are unless you switch on Include sheet tab names for the file. Text in shapes, text boxes and SmartArt works the same way.

Can I translate only some columns?

Yes. Hide the columns you want to keep in the original language before you upload the file. Hidden content is left out by default, so their cells aren’t translated or counted. Comments are still translated even in hidden columns, so delete the ones you don’t need.

Can I upload an old .xls file?

Yes, on Pro and Enterprise. Macro-enabled .xlsm workbooks and Excel templates are Pro too. On Free and Basic, open the file in Excel and save it as .xlsx first.

How much does it cost to translate an Excel file?

With Taia, AI translation of Excel files is included on every plan, from Free (5,000 credits a month, or 5,000 words with Standard AI) to Pro at €39/month for 100,000 credits (100,000 words with Standard AI). Professional translation is billed per word from €0.06, with no subscription.