Translate Excel formulas between language versions
Excel Formula Translator changes localized function names and formula syntax so a formula from one Excel language version can be read in another. Enter a formula, choose the source and target languages, and copy the result without uploading a workbook.
It helps when a forum answer, spreadsheet template, or colleague uses another Excel language. References, ranges, operators, strings, and nested functions stay intact; only the parts Excel localizes are changed.
A local translation loop you can inspect
The translator reads function identifiers and Excel error values in your browser. It maps source-language names to canonical English names, then writes the target-language names from the bundled dictionary. The page does not calculate your workbook or send its contents to a server.
Separators are handled in a separate syntax step. Automatic mode follows the source and target locale conventions. Manual options preserve separators or switch between commas and semicolons. Quoted strings and array constants stay unchanged.
35 language variants across four Excel versions
The language selector includes Basque, Catalan, Croatian, Czech, Danish, Dutch, English, Estonian, Finnish, French, Galician, German, Greek, Hungarian, Indonesian, Italian, Japanese, Kazakh, Korean, Latvian, Malaysian, Norwegian, Polish, Brazilian and European Portuguese, Romanian, Russian, Slovak, Slovenian, Spanish, Swedish, Thai, Turkish, Ukrainian, and Vietnamese.
The bundled source starts with 487 Office 365 function rows and adds source-backed differences for Excel 2013, Excel 2010 SP1, and Excel 2010. Some languages have no localized function column, so their function names remain in English. Available separators, error values, and CELL/INFO arguments can still be translated. Coverage notes identify version and source limits instead of treating an unchanged function as a guaranteed match.
Translate a formula in five practical steps
Keep the formula visible, make the language choice explicit, and review the result before pasting it into Excel.
Paste a formula
Enter one function or a complete formula in the source field. Nested expressions, cell references, sheet names, quoted text, and operators stay in the same formula string.
Choose version and languages
Choose the Excel version, source language, and target language. One version dictionary applies to both languages. Use Swap to reverse the direction.
Review separator options
Automatic mode follows the locale pair. Choose No change, commas to semicolons, or semicolons to commas when you need to control the syntax.
Translate locally
Press Translate to run the bundled dictionary and scanner in your browser. Unknown functions stay visible and appear in the warning list.
Copy or verify
Copy the target formula into Excel, or select Verify to translate it back to the source language and compare it with the original.
What the translator changes
Translation is deliberately narrow: change localized tokens, preserve spreadsheet logic, and make unsupported parts visible.
Nested formulas
Nested functions are matched as tokens. This keeps SUM separate from SUMPRODUCT and leaves text inside quoted strings unchanged.
=IFERROR(INDEX(A:A,MATCH(B2,C:C,0)),"")Separators
Excel installations commonly use commas or semicolons between function arguments. The translator changes separators only in argument positions, not inside quoted strings or array constants.
=SUM(A1,B1) → =SUMME(A1;B1)Errors
Localized errors such as #VALUE!, #REF!, and #N/A are translated when the selected language has a matching value. Missing entries stay unchanged and appear as limitations.
=IFERROR(A1/B1,"#VALUE!")CELL and INFO
CELL and INFO can use localized text arguments. The translator changes known literal arguments and safely preserves unknown or dynamic arguments.
=CELL("address",A1)Useful when Excel formulas cross borders
Forum answers
Translate an English formula from a forum or documentation page into the function names used by a German, French, Spanish, or another Excel installation.
Shared templates
Check a formula before putting it in a workbook that will move between teams, countries, or localized desktop installations.
Training and documentation
Show the same Excel idea in several language versions while keeping references and business logic visible in one formula.
Troubleshooting
Use reverse verification to see whether a translated formula can return to the source text without losing a function or separator.
Common translation questions
The function name stays unchanged
A function may keep its English name, be unavailable in the selected version, or lack older-version evidence in the bundled source. Read the coverage note and warning list.
Excel rejects the result
Check the target Excel language and argument separator. If your installation uses a different Windows list separator, choose an explicit separator mode and try again.
Verification reports a mismatch
Compare the original and round-trip formulas. A mismatch may mean an unsupported function, a localized argument without a source entry, or a change made outside the translator.
A formula is malformed
Check paired parentheses, quotation marks, and array braces. The translator preserves the source and reports the syntax boundary instead of guessing how to repair it.
Your formula stays in this browser
The translator is a static browser application. It reads your formula, uses its bundled data, and renders the result on your device. It does not upload workbooks, save formula text to local storage, or call the original Excel-Translator service.
Excel version, language, separator, and theme preferences may be saved in this browser. Formula text is not persisted. Keep important workbook formulas in your own approved storage. When working with sensitive material, also review browser extensions and device policies.
- Browser processingNo formula API request
- No workbook uploadText input only
- No formula storagePreferences only
Excel Formula Translator FAQ
Clear answers about languages, separators, privacy, accuracy, and workbook boundaries.
Does the translator upload my formula?
No. The formula translation runs in the browser from bundled data. There is no workbook upload or formula API request in the normal workflow.
How many languages are supported?
The selector contains 35 language variants. Twenty-three non-English languages include localized function-name data. The others translate available separators, error values, and CELL/INFO arguments while keeping function names in English.
Does it calculate or validate my workbook?
No. This is a text translator, not a spreadsheet calculation engine. It does not open workbooks, evaluate formulas, or verify the values produced by Excel.
Why did a function remain unchanged?
The function may keep its English name, be unavailable in the selected Excel version, be absent from the bundled source rows, or be ambiguous. The result includes a warning when the translation is partial.
Can it change commas to semicolons?
Yes. Automatic mode follows the selected locale pair, and the advanced options let you preserve separators, replace commas with semicolons, or replace semicolons with commas.
What does Verify do?
Verify translates the target formula back into the source language and compares the result with the original formula. It reports a match, mismatch, or unavailable status when the translation is partial.
Does the site support Excel workbooks?
No. The MVP accepts formula text only. Workbook uploads, VBA, macros, formula calculation, and data validation are outside the translator workspace.
Can I use the result in Excel?
Copy the target formula into Excel configured for the selected language and separator convention. Always check it in the destination workbook before relying on it.