🔤 Converters

Excel Formula Translator (PT ↔ EN)

Translates Excel formulas between English and Portuguese function names, error values and argument separators, leaving strings and refs intact.

Formula to translate

Direction

Target app

Also swap the argument separator (; ↔ ,) and the decimal mark of numbers

Translated formula

What gets changed

Function names in both directions, including nested calls: SUM/SOMA, VLOOKUP/PROCV, COUNTIF/CONT.SE and 190+ more pairs.
Error values (#N/A ↔ #N/D, #VALUE! ↔ #VALOR!) and the booleans TRUE/VERDADEIRO and FALSE/FALSO.
Text inside quotes, sheet names and cell references stay exactly as they are.
Functions outside the dictionary are kept untouched and listed so you can check them.

Translating Excel formulas between English and Portuguese

You find the answer on a forum, paste =VLOOKUP(A2,Sheet1!$A:$C,3,FALSE) into a Brazilian copy of Excel and get #NOME? back. That installation only knows PROCV, and it expects semicolons between arguments instead of commas. On a formula with three nested functions, retyping every name by hand is where the mistake creeps in: one argument always slips through.

This page splits the formula into pieces before replacing anything, so it can tell a function name apart from text inside quotes, from a reference like $A$1 or from a sheet name. The dictionary carries more than 190 pairs, from SUM and SOMA up to MAXIFS and MÁXIMOSES, plus the booleans TRUE and VERDADEIRO and the error values #N/A and #N/D. Quoted text is never touched.

The part people miss is the decimal mark. Taking =SE(A1>1,5;B1;C1) into English is not just swapping semicolons for commas: the 1,5 has to become 1.5 first, otherwise Excel reads three arguments and refuses the formula. The separator option handles both at once. Functions missing from the dictionary are left untouched and shown in a separate list, so you can check them one by one.

Frequently asked questions

Is the result ready to paste into the sheet?

It is. The output keeps the leading equals sign when the input had one, and uses the argument separator of the target language. Only the functions flagged as outside the dictionary need a look, since they come out exactly as you typed them. Nothing leaves your machine: the translation runs inside the browser.

Why was one of my functions left alone?

Either the name is not in the dictionary, or it is not a function at all. Defined names, add-in macros and newer Microsoft 365 functions without a mapped pair stay as they are and show up in the unrecognised list. An identifier only counts as a function when the next character is an opening parenthesis.

Does Excel not translate formulas on its own?

It translates what is already stored in the workbook, because the file keeps each function under an internal code and the interface renders it in its own language. Text copied from a website or an email arrives as raw text, without that code. That is exactly when manual translation, or this page, becomes necessary.

Related Tools

📄

CSV to JSON

Convert CSV to JSON. The first row becomes object keys, the rest become array items. Supports separators , ; and \t. Auto-detects numbers and booleans. Everything in your browser.

📮

Brazilian Address Parser

Splits pasted Brazilian addresses into street, number, unit, neighborhood, city, state and postal code fields, with CSV and JSON export.

Binary Code Translator

Convert text to binary code (0s and 1s) and vice versa. Supports any ASCII character. Processed in the browser.