(C) 2012 - 2024 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

 
Version 5.00 - Build 080121 - Copyright 2011 - 2024 by Mourad Louha - All rights reserved
 
Comments
Mourad
2015-04-02 at 09:38

Hello Tom,
nice to hear that the polish site exactly fits your needs :-)
Google considers the subdomains each one as a single site. And the polish site is relatively new, so that the english site is more indexed, I think. May be a reason why you’ve only found the english links on your search.
Thanks for the great offer to support me with translations. Yes, I will contact you by e-mail (may take some time) and send you some strings in an Excel file. Of course, if you like, I can add you on the about page with infos about the contributors.
Kind regards, Mourad

Tom
2015-04-02 at 09:23

Hello Mourad,

“This website also offers a polish version http://pl.excel-translator.de”

I have to say it’s quite a surprise for me and it perfectly fits my needs. No need to implement cookies if I there is direct link with correct settings.

How is it possible that I didn’t notice polish version so far? I didn’t pay attention to the upper “tiles” menu with “Language” link, and google results links guide directly to english subdomain.

If you need help

If you need help with polish translation – please feel free to contact me via email.

Kind regards,
Tom

Mourad
2015-04-02 at 07:12

Hello Tom,
ok, I see. Unfortunately I don’t know if this is possible, as this sites are driven by WordPress and the cookies etc. are sent and managed by WP. As I am not a WP-Developer, I will ask some friends and if it is possible, then I can add such a feature. This website also offers a polish version http://pl.excel-translator.de where Polish – English is set as default. The interface of the polish website is not fully translated yet and therefore some strings are in English. PS: the other feature for a reverse translation is on its way.
Kind regards, Mourad

Tom
2015-04-01 at 20:35

Hello Mourad,

“Or are you meaning sessions, when you exit the site and come back?” <- That's exactly what I meant. During one visit everything works fine, but It would be perfect if the site could remember language choice from my previous visit. For me it's PolishEnglish translation 99% of the time.

Kind regards
Tom

Mourad
2015-04-01 at 13:41

Hello Tom,
Thanks for your feedback and suggestions :-)
Does the remembering for the two selected languages not work for you? Meaning, when you are translating a formula, the selected languages should be kept. Or are you meaning sessions, when you exit the site and come back?
The button for swapping is a good idea. I think, I will implement this. May be take some time.
Best regards, Mourad

Tom
2015-04-01 at 13:05

This site is really great and the new version introduces some really nice improvements. If you don’t mind, I’d like to suggest two small changes to make it even more user friendly:
– remember language choice between sessions
– add a button to swap languages (I often translate a formula, modify it and translate it back to original language)

Thanks

Mourad
2015-02-16 at 19:09

Hello Anders,
Thanks – glad, that it helps you. :-)
Greeting to Norway, Mourad

Anders
2015-02-16 at 18:55

I love this site. I’ve been watching english Excel-videos on Youtube and it’s great having a site that translates functions into my native Language, Norwegian. Thank you very much! :)

Mourad
2015-01-20 at 09:05

Hello Akin,Thanks :-) Regards, Mourad

AKIN
2015-01-20 at 01:28

Womderful. Great source. Thank you so much. :)

Mourad
2014-12-12 at 16:55

Hi Ian,
thanks for your feedback and suggestions :-)
The translator offers an option for replacing the commas by semi-colons in “Separator for the function arguments”. If you set this option to “Replace commas with semi-colons”, you get the right separators. Concerning the second suggestion, yes, you are right. This is a small bug in the parser module, as it does not recognize Excel functions without brackets. I will fix this.
Regards, Mourad

Ian
2014-12-12 at 15:56

Generally I think this is an excellent resource. However, I have a small suggestion. It might be useful to be able to translate phrases within the formula too.

For example I put:

vlookup(A:A,B:D,2,false)

and got:

RECHERCHEV(A:A,B:D,2,false)

There are still two errors with this formula. First the “,” should be replaced by “;”. Second, the word false should be “faux”. This are probably things that would be picked up very quickly when working in the country, but I still think it would improve the functionality of this website.

Ian

Mourad
2014-11-09 at 10:08

Hello Acacio many thanks :-)Best regards, Mourad

Acacio Martins
2014-11-08 at 12:52

Great tool! Just have this in German and couldn’t understand a word…until now!
Thank you :)

SawStory
2014-10-18 at 18:54

You Saved my day

Mourad
2014-10-13 at 15:28

Hi Alberto, many thanks :-)

Older Comments
Newer Comments
Leave a Reply
Search
Advertising