Translate an Excel formula
A formula from a French colleague does not work in your English Excel: function names change, and semicolons replace commas. Everything is translated at once, in both directions.
What this tool does
- More than three hundred functions, from SUM to XLOOKUP, in both directions.
- Argument separators, decimals, array constants {1,2;3,4} and error values (#VALUE!, #NAME?).
- TRUE and FALSE, structured references ([#This Row]); sheet names and texts left untouched.
- The formula's spaces and line breaks kept.
What it does not do: TEXT format codes (dd/mm/yyyy, jj/mm/aaaa) are not translated: this is flagged. An unknown function is left as it is, and named.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Explain a formula : An inherited formula spelled out step by step, with its pitfalls.
- Find the right formula : What you want to do, your cells: the formula is written, ready to paste.
- Workbook health check : Size, phantom rows, styles, links, errors, hidden content: all of it, with one-click fixes.
- Formula audit : Errors, hard-coded values, formulas that stand out: what to check in a model.
- Slim down a workbook : Phantom rows, thousands of styles, copied formatting: the extra weight, removed.