Microsoft Excel logo on a green background

If you and your team use versions of Excel in different languages, check out the Functions Translator. This Microsoft add-in can translate entire formulas or help you find the function you want in the language you need.

Install the Functions Translator Add-In

The Functions Translator is a Microsoft add-in available for free. You can install it by heading to the Insert tab and choosing “Get Add-ins” in the Add-ins section of the ribbon.

Get Add-ins on the Excel Insert tab

Enter “Functions Translator” in the Search field and the top. Then select “Add” when you see the add-in in the search results and “Continue” to install it.

Functions Translator in the Microsoft add-in store

Once the add-in installs, you’ll get a new section of the ribbon on the Home tab. On the right, look for Functions Translator and you’ll see the two tools you’ll use, Reference and Translator.

Functions Translator ribbon section

Set Up the Functions Translator

When you install and open the Functions Translator for the first time using either ribbon button, you’ll see a Welcome screen in the side panel on the right. This allows you set up default To and From languages, but you can change these translation languages anytime as needed.

Select Get Started to head to the language settings. If you prefer to get right to work, you can choose “Skip” on the top right.

Functions Translator Welcome screen

To set your default languages, simply select them in the drop-down boxes and click “Start Working.”

Functions Translator language setup

To change the languages later, select an option in the ribbon and click the gear icon in the sidebar to open the Preferences.

Functions Translator Preferences

Find a Function

If you want to find a function in another language, click “Reference” in the Functions Translator section of the ribbon on the Home tab.

RELATED: How to Alphabetize Data in Microsoft Excel

This sends you directly to the Reference tab in the tool’s sidebar. Use the drop-down box at the top to pick a category for the function or use “All” to see them all.

The functions appear in alphabetical order so you can find the one you need easily. You’ll see the languages at the top of the list with From on the left and To on the right.

Browse functions on the Reference tab

For additional information about a function, select it. You’ll then see a description of the function on the Dictionary tab.

Get function descriptions on the Dictionary tab

You can also use the Dictionary tab on its own to search for any function you like and see the description and corresponding function in another language.

Translate a Formula

Maybe you’d like to translate a formula, the handiest feature of the tool. Plus, you can use a few convenient options in the Translator area. Click “Translator” in the Functions Translator section of the ribbon on the Home tab.

RELATED: How to Paste Text Without Formatting Almost Anywhere

In the sidebar, either type or paste your formula in the box at the top. Optionally, select the delimiters you want to use.

Then, click the translate button which is the one with the arrow pointing down. You’ll then see your formula translated to the other language in the box at the bottom. You can also do the reverse if necessary and translate the opposite direction using the arrow pointing up button.

Translate a formula

To use the translated formula in your sheet, select a cell and then click the icon on the left of the translation. This appears as letters.

Use the translated formula

To automatically translate a formula in a cell, check the box at the bottom of the sidebar for Instantly Translate Selected Cell. Note the direction of the translation with the To and From languages before doing so.

Automatically translate a formula

Whether you need a formula in your own language from a sheet in a different dialect or want to help your team create formulas in their language, the Functions Translator in Excel is a great helper.

Profile Photo for Sandy Writtenhouse Sandy Writtenhouse
With her B.S. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She learned how technology can enrich both professional and personal lives by using the right tools. And, she has shared those suggestions and how-tos on many websites over time. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage.
Read Full Bio »