Excel formula translator

Excel shows function names in its own language: VLOOKUP is SVERWEIS in German, PROCV in Portuguese and BUSCARV in Spanish. Paste a formula from a tutorial or a colleague and get it in your language, or in English.

An example

English: =IF(VLOOKUP(A2, Prices!A:C, 3, FALSE)>=1.5, "High", "Low")

How it works

A workbook is not tied to a language. Excel stores every formula the same way and shows it in the language of whoever opens the file, so a file made in German Excel works in English Excel without changes. The names only get in the way when a formula travels as text: in a tutorial, a forum answer, an email or a chat.

The translator changes four things: function names, the separator between arguments, the decimal point, and TRUE, FALSE and error values such as #N/A. Text in quotes, cell references and sheet names stay exactly as you wrote them. Every name was checked against two sources before it was added; where a name could not be confirmed, the translator leaves the English one and tells you.

Function names by language

The most used functions in every language

EnglishCzechDanishDutchFinnishFrenchGermanHungarianItalianNorwegianPolishPortuguese (Brazil)Portuguese (Portugal)RussianSpanishSwedishTurkish
VLOOKUPSVYHLEDATLOPSLAGVERT.ZOEKENPHAKURECHERCHEVSVERWEISFKERESCERCA.VERTFINN.RADWYSZUKAJ.PIONOWOPROCVPROCVВПРBUSCARVLETARADDÜŞEYARA
XLOOKUPXOPSLAGX.ZOEKENXHAKURECHERCHEXXVERWEISXKERESCERCA.XXOPPSLAGX.WYSZUKAJPROCXПРОСМОТРXBUSCARXXLETAUPPÇAPRAZARA
IFKDYŽHVISALSJOSSIWENNHASEHVISJEŻELISESEЕСЛИSIOMEĞER
SUMIFSSUMIFSSUM.HVISERSOMMEN.ALSSUMMA.JOS.JOUKKOSOMME.SI.ENSSUMMEWENNSSZUMHATÖBBSOMMA.PIÙ.SESUMMER.HVIS.SETTSUMA.WARUNKÓWSOMASESSOMA.SE.SСУММЕСЛИМНSUMAR.SI.CONJUNTOSUMMA.OMFÇOKETOPLA
COUNTIFCOUNTIFTÆL.HVISAANTAL.ALSLASKE.JOSNB.SIZÄHLENWENNDARABTELICONTA.SEANTALL.HVISLICZ.JEŻELICONT.SECONTAR.SEСЧЁТЕСЛИCONTAR.SIANTAL.OMEĞERSAY
COUNTPOČETTÆLAANTALLASKENBANZAHLDARABCONTA.NUMERIANTALLILE.LICZBCONT.NÚMCONTARСЧЁТCONTARANTALBAĞ_DEĞ_SAY
INDEXINDEXINDEKSINDEXINDEKSIINDEXINDEXINDEXINDICEINDEKSINDEKSÍNDICEÍNDICEИНДЕКСINDICEINDEXİNDİS
MATCHPOZVYHLEDATSAMMENLIGNVERGELIJKENVASTINEEQUIVVERGLEICHHOL.VANCONFRONTASAMMENLIGNEPODAJ.POZYCJĘCORRESPCORRESPПОИСКПОЗCOINCIDIRPASSAKAÇINCI
FILTERFILTRERFILTERSUODATAFILTRESZŰRŐFILTROFILTRARФИЛЬТРFILTRARFİLTRE
IFERRORIFERRORHVIS.FEJLALS.FOUTJOSVIRHESIERREURWENNFEHLERHAHIBASE.ERROREHVISFEILJEŻELI.BŁĄDSEERROSE.ERROЕСЛИОШИБКАSI.ERROROMFELEĞERHATA
TEXTJOINTEXTJOINTEKST.KOMBINERTEKST.COMBINERENTEKSTI.YHDISTÄJOINDRE.TEXTETEXTVERKETTENSZÖVEGÖSSZEFŰZÉSTESTO.UNISCITEKST.KOMBINERPOŁĄCZ.TEKSTYUNIRTEXTOUNIRTEXTOОБЪЕДИНИТЬUNIRCADENASTEXTJOINMETİNBİRLEŞTİR
ROUNDZAOKROUHLITAFRUNDAFRONDENPYÖRISTÄARRONDIRUNDENKEREKÍTÉSARROTONDAAVRUNDZAOKRARREDARREDОКРУГЛREDONDEARAVRUNDAYUVARLA
SEQUENCESEQUENCESEKVENSREEKSSEQUENCESEQUENZSEQUENZASEKVENSSEKWENCJASEQUÊNCIASEQUÊNCIAПОСЛЕДОВSECUENCIASEKVENS
RANKRANKPLADSRANGARVON.MUKAANRANGRANGSORSZÁMRANGORANGPOZYCJAORDEMORDEMРАНГJERARQUIARANGRANK
WEEKNUMWEEKNUMUGE.NRWEEKNUMMERVIIKKO.NRONO.SEMAINEKALENDERWOCHEHÉT.SZÁMANUM.SETTIMANAUKENRNUM.TYGNÚMSEMANANÚMSEMANAНОМНЕДЕЛИNUM.DE.SEMANAVECKONRHAFTASAY
EDATEEDATEEDATOZELFDE.DAGPÄIVÄ.KUUKAUSIMOIS.DECALEREDATUMKALK.DÁTUMDATA.MESEDAG.ETTERNR.SER.DATYDATAMDATAMДАТАМЕСFECHA.MESEDATUMSERİTARİH