Excel Functions Translator (2022)

This article will walk you through setting up and using the Excel Functions Translator add-in. The Functions Translator is geared towards people who use versions of Excel in different languages, and need help finding the right function in the right language, or even translating entire formulas from one language to another.

The Functions Translator:

  • Enables users who know Excel's English functions to become productive in localized Excel versions.

  • Enables users to easily translate full formulas to their native language.

  • Supports all of Excel's localized languages and functions, with 80 languages, and 800 functions.

  • Provides an efficient way to search for any part of a function's name in both languages selected.

  • Displays a scrollable, and categorized list of English functions, and their corresponding localized functions.

  • Enables you to give feedback to Microsoft on the function translation quality. You can give feedback on a specific function in a specific language.

  • Has been localized for English, Danish, German, Spanish, French, Italian, Japanese, Korean, Dutch, Portuguese Brazilian, Russian, Swedish, Turkish, Chinese Traditional and Chinese Complex Script.

Installing the Functions Translator add-in

The Functions Translator is available for free from the Microsoft Store, and can be installed by following these steps:

  1. Start Microsoft Excel.

  2. Go to the Insert tab.

  3. Click on the Store button in the Ribbon.

  4. This will launch the Office Add-ins dialog. Make sure that Store is selected at the top, and then click Productivity on the left-hand side.

  5. Search for "Functions Translator" in the upper-left search box.

  6. When you find it, click the green Add button on the right, and the translator will be installed

    (Video) Translate Functions in Excel - Tutorial

Configuring the Functions Translator

When the Functions Translator has been installed, it creates two buttons on the Home tab at the very right.

Excel Functions Translator (1)

The buttons will respectively take you to the Reference and Translator panes in the Functions Translator dialog. The exception to that is the first time you run the Functions Translator it will take you to a Welcome pane:

Excel Functions Translator (2)

The pane opens at the right-hand side of Excel, which is where it will be anchored for all operations.

You can skip straight to translations by clicking the Skip > link on the right-hand side at the top of the frame, but we recommend selecting Get Started, which will bring you to the Language settings dialog. This allows you to choose your default From and To languages, although you can change them at any time.

Excel Functions Translator (3)

Here you can configure your language set. While the Functions Translator supports all languages that Microsoft has localized Excel functions to, you can only operate with one pair at the time. Any combination of languages is possible, and Excel will remember your choice. The language pair can be changed at any time through the Preferences pane, which is accessible from any of the add-in's main panes.

By default, the From and To language will be pre-populated with English as the From language and the Excel Install language as the To language. If your install language is one of the languages we have localized for the Functions Translator, the user interface will display in the localized language. Click Start Working when you have selected your language pair.

We are using the concept of To and From in the translator. To is the language that you know, From is the language that you want to find. So if you were researching lookup functions in English, but needed the French function names then you would set the From language to English, and the To language to French.

The green Up arrow/Down arrow button in between To/From has been supplied to let you easily switch the From and To languages around.

Preferences

You can activate the Preferences pane by clicking the settings wheel at the bottom of any of the three main panes.

Excel Functions Translator (4)

(Video) How To Use the Translation Features of Microsoft Excel

Besides providing various links that may be of interest, you can also change your To and From languages from here at any time. Clicking the Left arrow at the top of the pane brings you back to the main pane.

Excel Functions Translator (5)

The Reference pane

The Reference Pane has a drop-down list for Function category, which will display all functions in each group selected with the From language on the left, and the To language on the right. If you're not sure which category a function belongs to, you can choose the All option.

By default, the functions are sorted alphabetically by the From column, in this case English, and shown here with a small down arrow next to the word English. You can sort alphabetically, reverse alphabetically, and you can chose to sort on either the From or To language. Just click on the language you want to sort by, and click on the name again to reverse sort. The arrow indicates the sort direction.

Excel Functions Translator (6)

Clicking on a function name in either column will bring you to the Dictionary pane, which will show the function with a short description.

The Dictionary Pane

The Dictionary pane enables you to search for any part of a function name by displaying all functions that contain the letters you entered. For performance reasons, search won't populate any results until you have entered at least two letters. Search will be in the language pair you have selected, and returns results for both languages.

Excel Functions Translator (7)

Once search has returned the function name you want, you can click on it, and the language pair and function definition will be displayed. If you click on a function name in the Reference pane, you will likewise be brought to the Dictionary, and shown the language pair and function description.

Notes:

  • Not all functions will have descriptions, but very few will be missing.

  • Function descriptions are in English only.

  • If you need to see a localized description, you can go to the Formulas tab, click on the relevant Function Category, and hover over the function in question. Excel will display a description of the function in your install language.

Clicking the lightbulb icon in the Dictionary pane will bring you to the Feedback on translation pane, where you can give us feedback about a particular translation.

Excel Functions Translator (8)

(Video) EXCEL TRANSLATE FORMULA FUNCTION ADD ON Google Translation Plug in Microsoft Office Table Sheet

The Translator Pane

The Translator pane can translate a full formula from one language to another. Here is an example of the Translator pane where a formula has been translated from English to French:

Excel Functions Translator (9)

The top box is for the From language, and the bottom for the To language. The two green arrow buttons in the middle will translate in the direction indicated. In this case, we pasted a formula into the From box, and clicked the down arrow to translate to French.

Manually setting delimiters

Excel functions rely on delimiters to separate ranges and arguments from each other. Different languages use different separators, so while the Functions Translator will try to make the right choices, it may sometimes be necessary to set some of these manually.

Excel Functions Translator (10)

Below each From/To box there are a group of buttons, shown above. The first button will take whatever is in the text box above, and paste it to the currently active cell in Excel. You can use that to paste a localized formula into the cell of your choice.

The other buttons are grouped by their respective functions: the decimal separator, the array separator and the list separator.

  • Decimal separator

    • The decimal separator can either be a period or a comma.

  • Array separator

    • This separator is specific to Array formulas.

      (Video) Microsoft Excel: How to translate text using Excel

  • List separator

    • For English, the decimal separator is normally a period, and the list delimiter is a comma. For some European languages, the decimal separator is a comma, and the list delimiter therefore has to be something else, namely a semi-colon. 

Instantly translate selected cell

The Instantly translate selected cell option on the Translator tab will attempt to translate the formula in any cell that you select. It will input the formula from the selected cell into the bottom To language box, and instantly paste a translation in the From language box.

Notes:

  • The Instantly translate selected cell feature is not supported in Microsoft Excel 2013 or earlier.

  • The Instantly translate selected cell feature will not work if you are in Edit mode in a cell. As soon as you exit Edit mode, instant translation will work again.

Feedback

We hope that the Functions Translator helps you to become more productive using localized versions of Excel, and we very much welcome feedback. Please feel free to give feedback on both on functions where the translation may not be the best, but also with the add-in itself.

If you have an opinion on how we localize functions in general, and how you would like to see this add-in work, we would very much like to hear that opinion as well!

The Functions Translator team, Martin and Vadym

fxlator@microsoft.com

Note:We will review each piece of feedback personally, however, we cannot guarantee a response. Please do not include any files containing personal information.

Need more help?

You can always ask an expert in the Excel Tech Communityor get support in the Answers community.

FAQs

Excel Functions Translator? ›

Excel Functions Translator
  • Enables users who know Excel's English functions to become productive in localized Excel versions.
  • Enables users to easily translate full formulas to their native language.
  • Supports all of Excel's localized languages and functions, with 80 languages, and 800 functions.

Is there a function to translate in Excel? ›

First, open your Excel spreadsheet and select the text you wish to translate. Then, on the toolbar, select Review > Translate. The translator menu will appear on the right, where you can set the source language and the target language.

Can you translate an entire Excel? ›

Microsoft Excel has a built-in translator you can use for simple translations (same machine translator can be found within Word when translating Word documents and PowerPoint presentations). First, open your Excel spreadsheet and select the text you wish to translate. Then, on the toolbar, select Review > Translate.

How do you auto translate in Excel? ›

Translate words or phrases in Word, Excel, or PowerPoint

In your document, spreadsheet or presentation, highlight the cell or text you want to translate. Select Review > Translate. Select your language to see the translation.

How do I insert a translation formula in Excel? ›

The Functions Translator is available for free from the Microsoft Store, and can be installed by following these steps:
  1. Start Microsoft Excel.
  2. Go to the Insert tab.
  3. Click on the Store button in the Ribbon.
  4. This will launch the Office Add-ins dialog. ...
  5. Search for "Functions Translator" in the upper-left search box.

Can I use Google translate in Excel? ›

Google Sheets allows formulas to translate text from one language to another =Googletranslate(A2, "en", "es").

How do I use Microsoft Translator? ›

Translator Dictionary
  1. Open the Microsoft Translator Windows 10 app.
  2. Select the Translate tab, then Text.
  3. Select the from and to language.
  4. Type your sentence or copy/paste your text.
  5. In the box to the right, highlight specific words in the language you translated to.

How do I translate a language into English? ›

Use Tap to Translate
  1. Open an app with text you can copy.
  2. Highlight the text you want to translate. Copy.
  3. On your current screen, tap Google Translate .
  4. Choose the language you want.

How do I turn on Google Translate in Excel? ›

How to use Google Translate within Excel | ExcelTricks3 | MiTutorials

Can I use Google translate in Excel? ›

Google Sheets allows formulas to translate text from one language to another =Googletranslate(A2, "en", "es").

How can I translate a page into English? ›

When you come across a page written in a language you don't understand, you can use Chrome to translate the page.
  1. On your computer, open Chrome.
  2. Go to a webpage written in another language.
  3. On the right of the address bar, click Translate .
  4. Chrome will translate your current webpage.

Videos

1. How To Use Language Translation Feature in Excel & Google Sheets | No VBA Required
(Excel Dose)
2. Excel Function Translator free
(excelexpertHU)
3. Translate functions in excel 2022 - tutorial
(Mobi Expert)
4. Translator tool in Excel 😳 #shorts
(MyExcelOnline.com)
5. Automate Language Translations Using Excel VBA
(Dinesh Kumar Takyar)
6. Translate Excel texts fully automatically via DeepL Use glossary function DeepL Excel Translator
(agindo GmbH)

Top Articles

Latest Posts

Article information

Author: Ray Christiansen

Last Updated: 12/25/2022

Views: 5997

Rating: 4.9 / 5 (49 voted)

Reviews: 80% of readers found this page helpful

Author information

Name: Ray Christiansen

Birthday: 1998-05-04

Address: Apt. 814 34339 Sauer Islands, Hirtheville, GA 02446-8771

Phone: +337636892828

Job: Lead Hospitality Designer

Hobby: Urban exploration, Tai chi, Lockpicking, Fashion, Gunsmithing, Pottery, Geocaching

Introduction: My name is Ray Christiansen, I am a fair, good, cute, gentle, vast, glamorous, excited person who loves writing and wants to share my knowledge and understanding with you.