How to Use Google Translate Formula in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

People who use Excel in several languages and require assistance finding the appropriate function in the appropriate language or even translating full formulas from one language to another can utilize the Functions Translator. This article will demonstrate how to use the google translate formula in Excel by using a function translator.


Download Practice Workbook

You may download the following Excel workbook for better understanding and practice it by yourself.


Step-by-Step Procedures to Use Google Translate Formula in Excel

This article will walk you through how to use the functioning translator dialog box from the Review tab to do Google translate formula in Excel. So, to know more about this, you can follow the below steps accordingly.


Step 1. Making Data Set with Different Languages

Here, we have created a data set with 7 different languages such as Spanish, Bengali, Hindi, Chinese, Korean, Arabic, and Japanese, and we will translate all these languages into English for showing google translate formula by using the Translate toolbar which is the Add-ins in Microsoft Excel.

  • So, you can see the below data set here with 7 different languages.

Making Data Set with Different Languages to Use Google Translate Formula in Excel

Read More: How to Translate Language in Excel Formula (with Easy Steps)


Step 2. Utilizing Translate Toolbar

In Excel, there is no built-in function to use Google translate formula. So, you can use your Review tab, where the Translate toolbar will appear. This toolbar works like a function translator to do google translate from one language to another.

  • Firstly, go to the Review tab.
  • Secondly, choose the Translate toolbar from the Language group.

Utilizing Translate Toolbar to Use Google Translate Formula in Excel

  • Therefore, a Translator dialog box will open.
  • Besides, you can see here the From and To options.
  • Then, you will select any language conversion google translation.
  • Here, we will show how to translate different languages into English. That’s why we will select Auto-detect for any language detection automatically and English for translating it into English.

Read More: How to Translate Excel File to English (2 Easy Ways)


Similar Readings


Step 3. Selecting Language Text to Translate

In this section, we will select text in different languages and see the translation in the left-side Translator dialog box.

  • Firstly, we will select the text from the B5 cell and then you will see on the right side where the Spanish language is detected.
  • Then, this function translator helps translate it into English on the right side.

Selecting Language Text to Use Google Translate Formula in Excel

Read More: How to Translate an Excel File from Japanese to English


Step 4. Showing Final Output

In the end, we will demonstrate all the translated text in one column by using the copy-and-paste option.

  • After doing Step 3 for all the text in the B column, you will copy the translated text from the Translator dialog box and paste it one by one into the D column.
  • Finally, you will see all the google translations in that B column.

Showing Final Output to Use Google Translate Formula in Excel


Notes
  • If you can’t find any Translator toolbar in your Excel, then you will go to the Insert tab first.
  • Secondly, you will choose the Get Add-ins option.

  • Then, type Translator from the Store
  • After that, click on Add.

  • Again, click on Continue.

  • Finally, you will see the Translator here in the below image when you go to the Review tab first.

Read More: How to Translate Portuguese to English in Excel (4 Effective Ways)


Conclusion

In this article, we’ve covered Step-by-Step Procedures to do Google Translate with Formula in Excel. We sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on Excel, you may visit our website, Exceldemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.


Related Articles

Bishawajit Chakraborty
Bishawajit Chakraborty

I'm Bishawajit Chakraborty. Hello. I graduated from Rajshahi University of Engineering & Technology (RUET) with a degree in Mechanical Engineering. I'm working with ExcelDemy as a Content Developer for Excel & VBA. You can visit our website, Exceldemy if you'd like to read my published articles on MS Excel and VBA.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo