Translate Excel files
Translate .xlsx, .xlsm, .xltx and .xltm workbooks up to 50 MB into several languages in one job. Formulas, number formats and sheet order stay as they were.
Excel workbooks (.xlsx, .xlsm, .xltx and .xltm) are accepted up to 50 MB. Every sheet is read, the plan tells you which sheets and columns hold the words, and you get a workbook back with the same sheets, the same cell addresses and the same formulas.
What is translated, and what is left alone
| Translated | Left as it was |
|---|---|
| Text cells in the sheets and columns you name | Formulas: a cell containing one is never a candidate |
| Several languages at once, as new columns beside the source | Numbers, dates, prices and number formats |
| Sheet names, sheet order and cell addresses |
Cell styles, merged cells and column widths are kept. A translated cell is written as plain text, so a bold or coloured word inside a single cell loses that inline formatting.
What you can ask
Adds one column per language next to the source.
Translate the description column on the Catalog sheet into French, German and Spanish, as new columns next to it. Leave the sku and price columns unchanged.
Translates only what is missing, so a reviewer sees both languages on one row.
Translate the English column into Italian. Keep the Italian cells that are already filled in.
Scopes the plan by sheet name.
Translate only the Help sheet into Portuguese. Do not touch the other sheets.
Returns just the rows that were written.
Translate the text column into French and return only the rows you changed.
Keeps identifiers readable and untouched.
Translate the labels into German. Leave cells that contain product codes, formulas or only numbers exactly as they are.
Good to know
- Several languages in one job. Excel can take several target languages at once, each in its own column.
- Existing target columns. When part of a target column is already filled, the plan translates only the missing cells. It may write them into a column it names, such as an added completed column, rather than into the empty cells themselves, so read the plan to see where the result goes.
- Output filter. Available. Ask for “only the rows you changed” to get a smaller workbook back.
- Variants.
.xlsm,.xltxand.xltmare read like.xlsx. The old.xlsand the binary.xlsbare refused: save them as.xlsxfirst. - Ceiling. 50 MB. A large workbook is processed in windows and reassembled.
- Long cells. A single value above 50,000 characters cannot be translated as one unit.
Related
- CSV and TSV, and OpenDocument for ODS spreadsheets.
- Preparing a spreadsheet export
- All file formats