Netmend

Excel formula translator

VLOOKUP = PROCV = BUSCARV = RECHERCHEV = SVERWEIS. Translate a whole formula, separators included, between 6 languages.

6 languagesFixes , vs ; separators55 functionsFree, no sign-up

Translate an Excel formula

Found a formula in an English tutorial but your Excel is in Portuguese, Spanish, French, German or Italian? Paste it here. We swap the function names and the separators (, → ; and 1.5 → 1,5), which is why copied formulas usually fail.

Sheet names and cell references are not translated. Google Sheets accepts English function names in any language, but uses your locale's separators.

Excel function names in 6 languages

The 55 functions small businesses use most. Search in any language.

EnglishPortuguês (PT)EspañolFrançaisDeutschItalianoWhat it does

Names are for Microsoft Excel desktop and Excel for the web. Portuguese is the Portugal version (Brazil differs for a few names, e.g. UNIQUE). Spotted a wrong name? Email us and we fix it the same day.

Stuck with a spreadsheet? We fix it.

Spreadsheet fix
$25 per sheet, launch price

Broken formulas, a lookup that won't work, a messy export to clean, a simple invoice or stock template. Fixed price after we see the file. 48h.

Send your file for a quote
Cheat sheet PDF + practice workbook
$5 one-time

This table as a printable 2-page PDF in 6 languages, plus an .xlsx with 20 small-business exercises (VAT, invoices, stock, dates) and answers. Pay once on Gumroad, not on this site.

Buy the Excel cheat sheet ($5)

Buy the cheat sheet + workbook

Buy the Excel cheat sheet ($5)

Opens the Gumroad product page ($5, one-time). Questions: dayinportugal@gmail.com.

Privacy. This page does not send or store anything. If you buy, you pay on Gumroad (portugaldiary.gumroad.com), under Gumroad’s checkout and privacy terms. For questions about the product, contact Pedro Carvalho (Netmend), dayinportugal@gmail.com. You can complain to the Portuguese data protection authority (CNPD).

FAQ

What is VLOOKUP in Portuguese?

PROCV (Portugal and Brazil). In Spanish BUSCARV, French RECHERCHEV, German SVERWEIS, Italian CERCA.VERT.

Why does my formula show an error after I paste it?

Usually the separator: English Excel uses commas between arguments, most European Excel versions use semicolons, and a decimal comma. The translator fixes both.

Can I change Excel to English function names?

Only by changing Excel's display/editing language in Office settings. Many people prefer to keep their language and translate the formula instead.

30 function guides (names, syntax and examples in 6 languages)

Each page is a proper reference: what the function does, the syntax and a worked example in English, Portuguese, Spanish, French, German and Italian, plus the mistakes that usually produce a quiet wrong number.

VLOOKUP = PROCV BUSCARV · RECHERCHEV · SVERWEIS · CERCA.VERTXLOOKUP = PROCX BUSCARX · RECHERCHEX · XVERWEIS · CERCA.XINDEX = ÍNDICE INDICE · INDEX · INDEX · INDICEMATCH = CORRESP COINCIDIR · EQUIV · VERGLEICH · CONFRONTASUMIF = SOMA.SE SUMAR.SI · SOMME.SI · SUMMEWENN · SOMMA.SESUMIFS = SOMA.SE.S SUMAR.SI.CONJUNTO · SOMME.SI.ENS · SUMMEWENNS · SOMMA.PIÙ.SECOUNTIF = CONTAR.SE CONTAR.SI · NB.SI · ZÄHLENWENN · CONTA.SECOUNTIFS = CONTAR.SE.S CONTAR.SI.CONJUNTO · NB.SI.ENS · ZÄHLENWENNS · CONTA.PIÙ.SEIF = SE SI · SI · WENN · SEIFS = SE.S SI.CONJUNTO · SI.CONDITIONS · WENNS · PIÙ.SEIFERROR = SE.ERRO SI.ERROR · SIERREUR · WENNFEHLER · SE.ERROREAND = E Y · ET · UND · ESUM = SOMA SUMA · SOMME · SUMME · SOMMAAVERAGE = MÉDIA PROMEDIO · MOYENNE · MITTELWERT · MEDIACONCATENATE = CONCATENAR CONCATENAR · CONCATENER · VERKETTEN · CONCATENATEXTJOIN = UNIRTEXTO UNIRCADENAS · JOINDRE.TEXTE · TEXTVERKETTEN · TESTO.UNISCITEXT = TEXTO TEXTO · TEXTE · TEXT · TESTOLEFT = ESQUERDA IZQUIERDA · GAUCHE · LINKS · SINISTRARIGHT = DIREITA DERECHA · DROITE · RECHTS · DESTRAMID = SEG.TEXTO EXTRAE · STXT · TEIL · STRINGA.ESTRAILEN = NÚM.CARAT LARGO · NBCAR · LÄNGE · LUNGHEZZATRIM = COMPACTAR ESPACIOS · SUPPRESPACE · GLÄTTEN · ANNULLA.SPAZIDATE = DATA FECHA · DATE · DATUM · DATAEOMONTH = FIMMÊS FIN.MES · FIN.MOIS · MONATSENDE · FINE.MESENETWORKDAYS = DIATRABALHOTOTAL DIAS.LAB · NB.JOURS.OUVRES · NETTOARBEITSTAGE · GIORNI.LAVORATIVI.TOTFILTER = FILTRAR FILTRAR · FILTRE · FILTER · FILTROUNIQUE = EXCLUSIVOS UNICOS · UNIQUE · EINDEUTIG · UNICISORT = ORDENAR ORDENAR · TRIER · SORTIEREN · DATI.ORDINASUMPRODUCT = SOMARPRODUTO SUMAPRODUCTO · SOMMEPROD · SUMMENPRODUKT · MATR.SOMMA.PRODOTTOPMT = PGTO PAGO · VPM · RMZ · RATA

More free tools