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

Dataset Overview

To illustrate these methods, we’ll use a dataset containing the report cards of some students. This dataset includes marks for three different subjects, all of which are currently in Chinese. Our goal is to translate them into English.

Method 1 – Using the Translate Command in Excel

In this method, we’ll utilize the Translate command found in the Review tab. This command facilitates the conversion from one language to another. We’ll translate the Excel file from Chinese to English.

Select Cell B4.
Navigate to the Review tab on the ribbon.
Locate and select the Translate command within the Language group.

This action will prompt the appearance of a Translator window.
Within the dialog box, you’ll find two sections. The upper box, labeled From, will display our selected text along with its language automatically detected.
In the To dialog box, select your desired language. Choose English.
The translation of the text will be displayed in the To section.

Once translated, select the entire text and press Ctrl + C to copy it.

Press Ctrl + V to paste it into cell B4.

Repeat the same procedure to translate the other cells if necessary.
Following these steps will yield the desired translations. You can refer to the screenshot for a visual representation.

Method 2 – Translating Chinese to English Using Google Translate

In this method, we’ll utilize the Google Translate website to translate the Excel file from Chinese to English.

Steps:

Open your web browser and navigate to the Google Translate website.

Click on the Translate window.
This action will open the Google Translate website.
Select the Document option.
Click on the Browse your computer.

Locate your desired Excel file and select it.
Click on Open.

Click on the Translate button.

Allow some time for processing.
Once processed, select Download translation.

Your translated file will be downloaded.
Open the file using Microsoft Excel, and you will have the translated text.

How to Translate Multiple Cells in Excel

You can translate multiple cells in Excel using the Translate command from the Review tab.

Steps:

Navigate to the Review tab on the ribbon.
Select the Translate option from the Language group.

This action will open a Translator window.
Within the dialog box, you’ll find two sections. The upper box, labeled From, will display our selected text along with its language automatically detected.
In the To dialog box, choose your desired language. Select English.
The translation of the text will be displayed in the To section.