(C) 2012 - 2021 by Mourad Louha · All rights reserved.
Privacy  ·  Imprint

Translator

The Microsoft Excel functions have been localized into many languages. If you send your Excel file to someone using a different language for Excel than you, the functions and formulas used in the workbook are automatically translated by Excel when opening the file. However, the automatic translation usually does not work, if you directly insert foreign language formulas into your worksheet. Such a situation may for example occur, if you are using Excel in German and want to use an English formula provided by a forum. The following online tool allows you to translate an Excel formula from one language into another language and therefore use the localized formula.

Microsoft ExcelMore information

Select your Microsoft Excel version. If you are using an Excel version older than Excel 2010, then select the last entry in the list. Please note, that some Excel function names have been translated differently across different Excel versions. This is for example the case for the function VLOOKUP. The Dutch translation for the function VLOOKUP is OPZOEKEN for Excel 2010 and ZOEKEN for Excel 2010 SP1 and above.

Source formulaMore information

Please enter either a single Excel function or a formula to the source formula field. If you enter a formula, the formula should have a correct syntax. The translator translates the function names, error values such as #DIV/0! and optionally the arguments for the CELL and INFO function.

Source languageMore information

Select the source language. The language must match the language of the function or formula previously entered, so that the translator can recognize the names.

Target languageMore information

Select the target language. Please note, that for several languages not all functions have been localized. There are even languages where only the arguments for the CELL and INFO functions have been translated.

OptionsMore information

The first option allows you to specify if the argument separators should be replaced. This is for example important, if you are translating an English formula to German. Usually, the comma is used as argument separator in an English Excel version and the semi-colon in a German Excel version. Therefore, you need to replace the argument separator, so that the German Excel version recognizes the formula. The Excel-Translator automatically suggests you an option when selecting a language. The other options allow you to specify whether the first arguments for the CELL and INFO function should be translated to English or to the target language. These options are set to the English translation by default, as Excel always recognizes the arguments in English.

Separator for the function arguments

First argument for CELL()

First argument for INFO()

Target formula

 
 
Comments

Hi Chris,

the online tool is fully integrated in WordPress and therefore, I am unfortunately not able to provide an embed code for the tool itself. I am in a development of an API but still far away from a productive version. So, sorry, I can not help you in this case.

Best,
Mourad

Hi Carl,

thank you very much! I am very glad, that this tool helped you for so much years. And sorry for the late reply; I only have seen this comment now, as this blog unfortunately did not inform me about the new comment.

And thank you for the suggestions. Yes, that would be useful options. I am planning a new version of this site with the support of a design agency in the course of summer/autumn this year, including a more modern implementation of the translator tool.

Best,
Mourad

Hi Mohit,

thank you very much! And sorry for the late reply; this blog unfortunately did not inform me about the new comment.

Best,
Mourad

Hi Mourad, do you happen to provide embed code for this tool at all? I’m just in the process of considering adding an Excel translation article to our website and your translation tool looks to be just about the most useful solution available so far as I can tell.

Hello Mourad, and thank you so much for this incredibly useful translation tool that has helped me many times over the years!

If you want to spoil us users even more, I would love for there to also be an option to remember my choices (languages and options). Perhaps through the use of a cookie? And maybe the desired languages to translate to-from could be supplied in the URL, like so:
https://en.excel-translator.de/translator/?lang=de-se

Again, thank you so much, and I wish you all the best on this journey they call life!

Mohit Narkhede

Thanks for the tool!

Hi Cesar

thank you very much :-)

Best,
Mourad

Thank you very much for a very useful tool!

Hi Peter,
thank you very much. I am glad, that the site helped you :-)
Happy new year,Mourad

I consider the localisation of the function names in Excel as one of the most stupid enforcement Microsoft could do.
I am very happy I found your site which helps me a lot! Peter

Hi Abdul,
thank you very much. I am happy to hear, that this site is helpful to discover the English functions names.
Best,Mourad

Thank you so much for this site. I am learning excel in French but I’m not sure I’m gonna work in the same language. This site helped me discover the formulas in English.

Hi Dennis,
thank you very much – happy, the tool and site could help and are useful :-)
Best,Mourad

Leave a Reply