maratoolExcel Formula Translator
All 375 Excel function names in English, Portuguese, and Spanish. Search in any language, click to copy — fix #NAME? errors from translated formulas.
Showing all 375 functions. Click any name to copy it.
What is Excel Formula Translator?
The Excel Formula Translator is a searchable table of all 375 Excel function names in English, Portuguese (pt-BR), and Spanish. Excel translates function names with the interface language — =SUM() becomes =SOMA() in Portuguese and =SUMA() in Spanish — so a formula copied from an English tutorial throws #NAME? on a localized installation. Type a name in any of the three languages to find its equivalents, and click to copy.
How to use
- Type a function name in any language — English, Portuguese, or Spanish.
- The table filters instantly to matching functions across all three languages.
- Click any name to copy it, then paste it into your formula.
Frequently asked questions
Why does my Excel formula show a #NAME? error?
Excel localizes function names. Typing =SUM() in a Portuguese installation fails because the function is called SOMA there. Translate the name and the formula works. Watch the logicals too: TRUE/FALSE become VERDADEIRO/FALSO in Portuguese and VERDADERO/FALSO in Spanish.
What is VLOOKUP in Portuguese and Spanish?
VLOOKUP is PROCV in Portuguese (Brazil) and BUSCARV in Spanish. The modern XLOOKUP is PROCX and BUSCARX.
Do I need to translate formulas when opening a foreign spreadsheet?
No. Excel stores formulas in a language-neutral format and displays them in your installation language. Translation is only needed when typing or pasting formula text from a tutorial or forum in another language.
Do these translations work in Google Sheets?
Mostly yes. Google Sheets uses nearly the same localized names as Excel for the classic functions, though some newer functions differ between the two apps.
Last updated
Powered by maratool