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


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


Hi André
thanks :-)
Thanks for the suggestion too. Remembering the source and target language, some options and more would normally imply a cookie implementation (afaik) – but I like the idea by using url parameters, what will avoid cookies. So, I will note that suggestion on my notebook for a future improvement. I am currently fully redesigning this site, so that it will have a new layout and much more translated functions in Excel. However, the redesign will take a while, I plan to be ready January/February 2019.

André Marques

Hi! This tool it’s a real life saver hehe
Is it somehow possible for the site te remember preferences like target language and options etc? Or at least source and target language? (maybe in the url. e.g.: From english to portuguese -> https://en.excel-translator.de/translator/pt)

Hi Marcel,
thank you! And thank you for the suggestion too. I will see, what I can do, but I can not say when and if this will possible. A redesign of this website has some priority on my tasks list.

Hi great work! Is it somehow possible for the site te remember preferences like target language and options etc? tia! regards, Marcel.

Hi Florian, thanks!
Best, Mourad

This tool saved my day :-) – great work!

Hello Sandra,
thanks :-)
I am always open for suggestions for the Online Tool, however is there a reason why you suggested to change the field locations? Btw, next year there will be some improvements on this part.
Best, Mourad

Great job! I think it would be best if you rearrange the elements of the HTML form, as follows, bottom down: Excel, Source formula, on one line the Source and Target language fields (+ an arrow icon to go from Source to Target), buttons Translate and Verify, Target formula, and then Options?

Hi Cam-Linh,
thanks, glad the site/translator helps out :-)
Best, Mourad

Great thank you! I am working on French excel version and it is horrible to start everything again. Thank you so much for your work. This saved my time and “saved my life” :) :)

Leave a Reply