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.
- 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.
- 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.
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.
- 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.
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.
- 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.