We may be compensated for your purchase of any of the products featured on this page – it helps us keep the lights on :)
The Excel Functions Translator add-in is a great (and FREE!) language translator that you can use to translate functions and formulas in Excel from one language to another.
This is ideal if you collaborate with people who use Excel in a different language than you.
Excel Functions Translator Add-in
(available for Office 365, Excel 2016, and Excel 2019 versions)
This add-in will help you translate functions and formulas from one language to another.
Download the Excel Functions Translator
To install the Excel Functions Translator add-in:
- Go to the Insert tab of your ribbon
- Go to the Add-ins section
- Click on “Get Add-ins.” This will open the Add-in Store (don’t worry – this is a FREE add-in)
- Go to the “Productivity” category
- In the options, scroll until you find “Functions Translator”
- Click “Add,” then click “Continue” to accept the terms
You should now see the Functions Translator add-in in the Home tab of your Excel ribbon.
Using the Excel Functions Translator
The first time you use the Translator, you’ll see a welcome screen. Click “Get Started” or “Skip” to move from this screen.
Next, you’ll have an option to set your language and the language to translate to. Don’t worry, you can change this again later if you need to.
The Functions Translator contains 3 tabs:
1. Reference tab:
In the Reference tab you can select a function by its category. The functions are listed alphabetically by their category.
The left column has the function in what you set as your “From” language, while the right column shows the equivalent, but translated function.
2. Dictionary tab:
The Dictionary tab lets you type the name of the function you want to translate.
3. Translator tab:
In the Translator tab you can translate functions and formulas. You have 2 options:
- Type or paste a function or formula to translate in the top box. To do the translation, click on one of the arrows between the boxes to select the direction of the translation.
NOTE: Different languages sometimes use different delimiters. For example, some may use a comma where others may use a decimal. For best results, make sure to select the right delimiter for your languages from the options below each box.
- You can also help avoid typing errors and save time by checking “Instantly translate selected cell” and Excel will automatically translate formulas inside your active cell (this is the cell in which your cursor is in).
NOTE: double-check the direction of the translation when checking this box. Notice, in this example, how it’s set to translate from Spanish to English. But, because my formula is in English, I need to change the translation direction to be from English to Spanish. Do this by clicking on the arrows between the boxes.
Change Languages in “Preferences”
You can switch the languages for your translations at any time by clicking on the Preferences icon on the bottom right of your Functions Translator window.
Once in the “Preferences” section, select the languages to set.
When done, click the back button on the top left to return to the main tabs.
FYI, this was created using the desktop version of Excel in Microsoft 365.