How to Translate Chinese to English in Excel (2 Simple Methods)

Get FREE Advanced Excel Exercises with Solutions!

Sometimes we get an Excel file in a different language rather than English. Excel has a built-in feature to translate the other language into English. In this article, we will demonstrate to you 2 quick methods to translate an Excel file from Chinese to English. I hope you find this article very informative and use it for different purposes.


How to Translate Chinese to English in Excel: 2 Simple Methods

To demonstrate the methods, we take a dataset that contains a result card of some students. Here, we include the marks of three different subjects. As all of the text values are in Chinese form, we would like to translate them into English. Both of the methods are fairly easy to use.


1. Use Translate Command to Convert Chinese to English in Excel

In this method, we are going to use the Translate command from the Review tab. The Translate command helps to convert from any language to a different language. We would like to translate the Excel file from Chinese to English. Follow the steps carefully.

Steps

  • Firstly, select Cell B4.
  • Then, go to the Review tab on the ribbon.
  • Select the Translate command from the Language group.

Use Translate Command to Convert Chinese to English in Excel

  • As a result, a Translator window will appear.
  • In the dialog box, you will find two boxes. Among them, the upper box, entitled From, will show our selected text and the language of that text automatically.
  • In the To dialog box, choose your desired language. Here, we choose the English language.
  • You will find the translation of that text shown in the To section.

Utilize Translate Command to Convert Chinese to English in Excel

  • After that, select the entire translated text and press Ctrl +C to copy.

  • Then, press Ctrl +V to Paste in cell B4.

  • Follow the same procedure to translate Chinese to English.
  • As a result, you will find the following result. See the screenshot.

Apply Translate Command to Convert Chinese to English in Excel

Read More: How to Translate Excel File from German to English


2. Translate Chinese to English with Google Translator

In this method, we will take help from the Google Translate website to translate the Excel file from French to English. The procedure is quite simple. To understand the method, follow the steps carefully.

Steps

  • First, open the browser and click on the Translate window.

  • As a result, the Google Translate website will open.
  • Next, select the Document option.
  • Then, click on the Browse your computer option.

Translate Chinese to English with Google Translator

  • After that, find out your required Excel file and select it.
  • Then, click on Open.

  • Next, click on the Translate button.

  • It will take some time to process.
  • Then, select Download translation.

  • Your translated file will be downloaded.
  • Then, open the file with Microsoft Excel, and you will get the translated text.

Convert Chinese to English with Google Translator

Read More: How to Translate Excel File from French to English


How to Translate Multiple Cells in Excel

You can translate multiple cells in Excel. In order to do this, you need to open the Translate command from the Review tab. Then, set the auto-detect option and select the range of cells. Follow the steps carefully.

Steps

  • Firstly, go to the Review tab on the ribbon.
  • select the Translate option from the Language group.

  • As a result, a Translator window will appear.
  • In the dialog box, you will find two boxes. Among them, the upper box, entitled From, will show our selected text and the language of that text automatically.
  • In the To dialog box, choose your desired language. Here, we choose the English language.
  • You will find the translation of that text shown in the To section.

How to Translate Multiple Cells in Excel

  • Then, select the range of cells B4 to B7.
  • As a result, you will find the translator detects this language and shows the translated form in the To section.

  • Next, select the translated text and press Ctrl+C to copy.
  • Here, you need to copy the text one after another.
  • Finally, press Ctrl+V to paste the text in the desired place.

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


Download Practice Workbook

Download the practice workbook below.


Conclusion

To translate Chinese to English in Excel, we have shown 2 suitable methods through which you can easily do the work. I hope that this article will be helpful for you and you will be able to translate an Excel file from Chinese to English. If you have further queries, feel free to ask in the comment section.


Related Articles


<< Go Back to Translate in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Durjoy Paul
Durjoy Paul

Durjoy Kumar, with a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, is a dedicated contributor to the ExcelDemy project. His substantial contributions include crafting numerous articles and demonstrating expertise in Excel and VBA. Durjoy adeptly automates Excel challenges using VBA macros, offering valuable solutions for user interface challenges. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, SPSS, C, C++, C#, JavaScript, Python Web Scraping, Data Entry... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo