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

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.


Download Practice Workbook

Download the practice workbook below.


2 Simple Methods to Translate Chinese to English in Excel

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 to English (2 Easy Ways)


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 times 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 Language in Excel Formula (with Easy Steps)


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


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. Don’t forget to check our website, ExcelDemy, for several Excel-related problems and solutions.


Related Articles

Durjoy Paul

Durjoy Paul

Hi there! I'm Durjoy. I have completed my graduation from the Bangladesh University of Engineering and Technology. I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo