Formula translator

Translate an Excel formula between languages

Microsoft localizes function names — SUM in English, SUMME in German, SOMME in French. Paste a formula on either side, configure the options, and the translator converts function names, swaps argument separators, and shows a round-trip verification. Press Ctrl+K to focus the input from anywhere.

Source language Source formula

Target language Target formula Verification (round-trip back to source)

Options

Auto-swap separator , ↔ ;

Translate error values #N/A ↔ #NV

Target Excel version

Recent translations

Last 10 (saved locally — clear browser data to reset)

Try a sample

Click a sample to load it

EN: =SUM(A2:A10) DE: =SUMME(...) FR: =RECHERCHEV(...) ES: =SI(...) IT: =CERCA.X(...) PT: =SOMASES(...) NL: =ALS.FOUT(...) PL: =JEŻELI(...)

What's new in this translator

Six features beyond a plain word-swap

🔍 Auto-detect

Source language

Click Auto-detect and the engine guesses the source language by counting which language's function names match.

📋 Bulk mode

Multiple formulas

Paste several formulas, one per line — each line translates independently. Toggles a taller textarea.

🔗 Share URL

Send a link

One click copies a URL with the formula and languages encoded — open it on any device to resume.

📊 Compatibility

Excel version check

Set the target Excel version. The translator flags functions that won't work — XLOOKUP isn't in 2016, for instance.

⚠ Errors

Localized #N/A

Optional toggle translates #NV ↔ #N/A ↔ #N/D. Most Excel versions accept both forms but downstream parsers may not.

📚 History

Last 10 saved locally

Recent translations are saved in your browser. Click any item to reload it. No server, no account.