Home / Excel formula translator

Excel formula translator

Paste an Excel formula in one language and get it in another, with the right function names and separator. Includes a function dictionary.

Translate formulas

Separators (they depend on regional settings)

Choosing a language sets its usual separators, but Excel uses the ones from the computer's regional settings. In {…} arrays with a decimal comma, columns are separated by «\» or «.» depending on the country. If your Excel uses different ones, change them here.

Source Target

Function dictionary

Names taken from the PhpSpreadsheet language files (MIT licence) and checked against two other sources; the Catalan ones come from ONLYOFFICE. A dash means we have no reliable name in that language; the asterisk marks recent functions. In the Chinese, Japanese and Korean versions of Excel, functions are written in English.

Advertisement
Reserved space for Google AdSense ad (Bottom Banner)

How to translate an Excel formula into another language

The formula is analysed piece by piece in your browser: only function names and separators change, and everything else (text, sheets, cells and names) is kept. It also tells you what a function is called in another country's Excel.

  1. Paste one or more formulas, one per line. The source language is detected automatically, but you can choose it.

  2. Choose the target language and, if your Excel uses different ones, adjust the separators.

  3. Check the warnings and press Copy result. In the dictionary you can look up any function and download the full table.

Why use JapalTools?

Your files never leave your device

Everything happens in your browser. Documents are never uploaded to any server, so you can use it with payslips, contracts or ID documents.

Free, no sign-up and no watermarks

You don't need an account or to leave your email, and nothing is added to the result.

Works on any device

Computer, tablet or phone, with an up-to-date browser (Chrome, Edge, Firefox or Safari). Nothing to install.

Advertisement
Reserved space for Google AdSense ad (In-content)

Frequently asked questions

English, Spanish, Catalan, Brazilian and European Portuguese, French, Italian, German, Dutch, Swedish, Danish, Norwegian, Finnish, Polish, Czech, Hungarian, Russian and Turkish: 18 languages in which Excel translates function names. The Catalan names come from ONLYOFFICE (some are the same as in Spanish): check them if your Excel shows different ones. In Chinese, Japanese, Korean and most other languages Excel uses the English names, so just choose “English”.

Function names, TRUE and FALSE, the classic errors (#N/A, #VALUE!, #DIV/0!…) and the argument, decimal and array separators. Text in quotes, sheet names, cell references, defined names and table references are left exactly as they are.

It is left as it is and the tool warns you with its name so you can check it by hand. This happens with custom functions (macros or named LAMBDAs) and with some recent functions for which we do not have a reliable name in every language.

Excel takes the argument and decimal separators from the system's regional settings, not from the Excel language. If your computer uses different ones, change them under «Separators»: the translation is redone instantly.

No. Table references are copied unchanged, including specifiers such as #Headers or #This Row, which also change with the language: check them if your formula uses them. It does not convert R1C1-style references either.

No. The document is processed in your own browser and is not sent to JapalTools or anyone else. When you close the page, no copy remains outside your device.

Vectorizing…