Excel Formula Translator

Translate Excel formulas between English and Spanish with the right separator (, or ;): VLOOKUP to BUSCARV, IF to SI and 120+ more functions

Your formula (one per line)

Source separator

Examples:

Translate to

=SUMAR.SI.CONJUNTO(D2:D100,B2:B100,"North")

Functions in your formula:SUMAR.SI.CONJUNTO SUMIFS

With comma separators, decimals use a point: 1.5.

All 123 functions in English and Spanish

Spanish	English
ABS	ABS
Y	AND
PROMEDIO	AVERAGE
PROMEDIO.SI	AVERAGEIF
PROMEDIO.SI.CONJUNTO	AVERAGEIFS
BYCOL	BYCOL
BYROW	BYROW
MULTIPLO.SUPERIOR	CEILING
ELEGIR	CHOOSE
ELEGIRCOLS	CHOOSECOLS
COLUMNAS	COLUMNS
CONCAT	CONCAT
CONCATENAR	CONCATENATE
CONTAR	COUNT
CONTARA	COUNTA
CONTAR.BLANCO	COUNTBLANK
CONTAR.SI	COUNTIF
CONTAR.SI.CONJUNTO	COUNTIFS
FECHA	DATE
SIFECHA	DATEDIF
DIA	DAY
DIAS	DAYS
EXCLUIR	DROP
FECHA.MES	EDATE
FIN.MES	EOMONTH
IGUAL	EXACT
FILTRAR	FILTER
ENCONTRAR	FIND
MULTIPLO.INFERIOR	FLOOR
VF	FV
BUSCARH	HLOOKUP
HORA	HOUR
APILARH	HSTACK
SI	IF
SI.ERROR	IFERROR
SI.ND	IFNA
SI.CONJUNTO	IFS
INDICE	INDEX
ENTERO	INT
TIR	IRR
ESBLANCO	ISBLANK
ESERROR	ISERROR
ESNOD	ISNA
ESNUMERO	ISNUMBER
ESTEXTO	ISTEXT
LAMBDA	LAMBDA
K.ESIMO.MAYOR	LARGE
IZQUIERDA	LEFT
LARGO	LEN
LET	LET
MINUSC	LOWER
MAP	MAP
COINCIDIR	MATCH
MAX	MAX
MAX.SI.CONJUNTO	MAXIFS
MEDIANA	MEDIAN
EXTRAE	MID
MIN	MIN
MIN.SI.CONJUNTO	MINIFS
MINUTO	MINUTE
RESIDUO	MOD
MODA	MODE
MODA.UNO	MODE.SNGL
MES	MONTH
DIAS.LAB	NETWORKDAYS
NO	NOT
AHORA	NOW
NPER	NPER
VNA	NPV
O	OR
PAGO	PMT
POTENCIA	POWER
PRODUCTO	PRODUCT
NOMPROPIO	PROPER
VA	PV
JERARQUIA	RANK
JERARQUIA.EQV	RANK.EQ
TASA	RATE
REDUCE	REDUCE
REPETIR	REPT
DERECHA	RIGHT
REDONDEAR	ROUND
REDONDEAR.MENOS	ROUNDDOWN
REDONDEAR.MAS	ROUNDUP
FILAS	ROWS
SCAN	SCAN
HALLAR	SEARCH
SEGUNDO	SECOND
SECUENCIA	SEQUENCE
K.ESIMO.MENOR	SMALL
ORDENAR	SORT
ORDENARPOR	SORTBY
RAIZ	SQRT
DESVEST	STDEV
DESVEST.P	STDEV.P
DESVEST.M	STDEV.S
SUSTITUIR	SUBSTITUTE
SUBTOTALES	SUBTOTAL
SUMA	SUM
SUMAR.SI	SUMIF
SUMAR.SI.CONJUNTO	SUMIFS
SUMAPRODUCTO	SUMPRODUCT
CAMBIAR	SWITCH
TOMAR	TAKE
TEXTO	TEXT
TEXTODESPUES	TEXTAFTER
TEXTOANTES	TEXTBEFORE
UNIRCADENAS	TEXTJOIN
DIVIDIRTEXTO	TEXTSPLIT
NSHORA	TIME
HOY	TODAY
ESPACIOS	TRIM
UNICOS	UNIQUE
MAYUSC	UPPER
VALOR	VALUE
BUSCARV	VLOOKUP
APILARV	VSTACK
DIASEM	WEEKDAY
NUM.DE.SEMANA	WEEKNUM
DIA.LAB	WORKDAY
BUSCARX	XLOOKUP
COINCIDIRX	XMATCH
AÑO	YEAR

Want to practice? Interactive Excel exercises

Share this tool

If it helped, send it to someone who needs it too.

About Ads

This site uses Google AdSense to display ads. These ads help us keep WebHerramientas completely free. Ads are managed by Google and meet strict security and privacy standards.

Free Online Excel Formula Translator

If you copied a formula from a Spanish tutorial and your Excel is in English, or the other way round, translate it here instead of rewriting it. The translator changes every function name, the argument separator (comma or semicolon), decimals and TRUE/FALSE, while keeping quoted text, sheet names and ranges. Below is the full dictionary of Excel functions in English and Spanish.

Why use Excel Formula Translator

Translates function names, separators, decimals and logical values
Spanish with commas (Mexico) or semicolons (Spain, much of South America)
Several formulas at once, one per line
Keeps text, sheet names like Sheet2! and whole columns like A:C
Flags misspelled functions
Searchable dictionary of 120+ functions linked to their reference pages

How to use it in 3 steps

1
Paste the formula
Copy the formula from Excel or a tutorial and paste it in the box. You can add several, one per line.
2
Pick the target
Choose English Excel, Spanish with commas or Spanish with semicolons.
3
Copy the result
Press the copy button and paste it into your Excel.

Questions about Excel Formula Translator

What is VLOOKUP called in Spanish Excel?

BUSCARV. Likewise IF is SI, SUMIF is SUMAR.SI, COUNTIF is CONTAR.SI, IFERROR is SI.ERROR and INDEX is INDICE. Type any name in the dictionary search to see its equivalent.

Why does Spanish Excel use semicolons?

Where the comma is the decimal mark, as in Spain and much of South America, Excel separates arguments with semicolons. Pick "Spanish with ;" as the target and decimals are converted too.

Do I need to translate formulas when opening a file from another language?

No. Excel stores formulas in English internally and shows them in each installation's language. You only need to translate when copying formula text, for example from a tutorial or a forum.

Which functions keep their name?

MIN, MAX, ABS, LET, CONCAT, LAMBDA, MAP and BYROW, among others, are the same in both languages. The argument separator still depends on regional settings.

Is Excel Formula Translator free?

Yes, Excel Formula Translator from WebHerramientas is 100% free. No registration or subscription required. You can use it as many times as you need at no cost.

Is it safe to use Excel Formula Translator online?

Yes, all information is processed directly in your browser. We do not store or send your data to any external server.

Does Excel Formula Translator work on mobile?

Yes, the tool is fully responsive and works on any device: phone, tablet or computer with a modern browser.