Are Excel's localized function names documented

Question

Is there a reference of Excel's localized function names?

For example, the function "SUM" is "SOMME" in French and "SUMA" in Spanish.

Is there an exhaustive documentation somewhere?

Melissa

Answer 1

There's a list of English/French/German function names here, or a comprehensive list of functions in 14 different languages

• Brazilian Portuguese (português brasileiro)
• Czech (čeština)
• Danish (dansk)
• Dutch (nederlands)
• Finnish (suomi)
• French (français)
• German (deutsch)
• Hungarian (magyar)
• Italian (italiano)
• Norwegian (norsk)
• Polish (język polski)
• Portuguese (português)
• Spanish (español)

• Swedish (svenska)

  here.

EDIT

I also have a set of Russian function names, though I'm not aware of any other translation sites with that set of data.

I'm always interested in other language lists if you manage to track any down.

EDIT 2

For some information about other localization issues, Ron de Bruin, Kirill Lapin and Hector Miguel Orozco Diaz have this excellent page that mentions a host of further localization differences.

EDIT 3

Russian function names are included in the Russian language files for PHPExcel. The full text is too big to post here, but You can find it in the source repository.

Despoil

as my website has been mentionned (software.maninweb.de, thanks), just want to inform you, that I have released an Online Excel Formula translator here: translator.excel-ticker.de Currently 16 languages are included and you can translate both single or combined excel formulas. Regards :-) – Enough

No documentation about some xls 2010 functions such as SUMIF. – Laundryman

is there any way to change it to english having other language? they are crazy that they localized function names. – Highboy

Not so crazy.... Excel is written to be used by people for whom English may not be their native language, and who may not even speak English, or whose native language may not even use a Latin alphabet – Despoil

unfortunately some of the links are dead. @MarkBaker but Excel for non-Latin languages still use English function names. It seems only European languages have localized names – Heartily

@FlashThunder just install a language pack and change Excel's language to English. There's also an official Excel functions translator that translates the whole expression or gives you the function list in all the supported languages – Heartily

As per today, The link is unfortunately broken – Flaccid

Answer 2

Yes.

A list of English function names is available from Microsoft here:

https://support.microsoft.com/en-us/office/excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188

If you change en-us in this URL to another language short code such as de-de, fr-fr or it-it, the page will be displayed in that language. All the Excel functions will also be shown in the selected language. For example, Italian is here:

https://support.microsoft.com/it-it/office/funzioni-di-excel-in-ordine-alfabetico-b3944572-255d-4efb-bb96-c6d90033e188

A list of language short codes (technically 'BCP 47 codes', I believe) used by Microsoft is available here: https://learn.microsoft.com/en-us/openspecs/office_standards/ms-oe376/6c085406-a698-4e12-9d4d-c3b0ee3dbc4a

(Not all of these are necessarily supported by the page above.)

Patroon