This is a helpful tutorial that sets up a Google Sheets document khổng lồ automatically translate English to lớn Chinese. Language options include Traditional Chinese, Simplified Chinese, và Pinyin. Sadly there’s no option for Zhuyin yet. Keep in mind the translation is only as accurate as Google Translate. I find Google translate Chinese to lớn have improved greatly over the last couple of years.

Bạn đang xem: Free English To Chinese Simplified Translation

Step 1: Create Google Spreadsheet

Go lớn Google Drive and open a new Google Sheet. Mix up your column headers for English & Chinese. My example shows English, Traditional Chinese, Simplified Chinese, & Pinyin.


Step 2: Fill in English

In column 1, fill in the words and phrases you want to translate to lớn Chinese.


Step 3: Enter the Translate Formula

In column 2, enter the formula to lớn translate khổng lồ Traditional Chinese =GOOGLETRANSLATE(A2, “en”, “zh-tw”).a2 is the cell you want to lớn translate. “en” is the source language, “zw-tw” is the language code for Traditional Chinese. The code for Simplified Chinese is “zh-cn”.

In column 3, enter the formula lớn translate to Simplified Chinese =GOOGLETRANSLATE(A2, “en”, “zh-cn”).

Xem thêm: Các Nhóm Đối Tượng Khách Hàng Thường Gặp Trong Kinh Doanh Và Cách Thức Tiếp Cận


Step 4: địa chỉ Pinyin API

For Pinyin you will need to địa chỉ cửa hàng the Mandarin Cantonese API.

From the menu, click on Add-ons and select Get add-ons from the drop down menuIn the search bar type in “Mandarin Cantonese API and click on the imageIn the next window click InstallIn the pop up click ContinueSelect your Google accountAn alert message will appear. Click on Advanced and then click on Go khổng lồ Mandarin Cantonese ToolsIn the next window click on AllowOnce complete, close the installer windowFrom the menu, click on Add-ons và select Mandarin Cantonese Tools và click on Use in this spreadsheet


Step 5: Enter the Formula for Pinyin

Follow the same instructions in step 2, but use the language code for Pinyin

. C2 stands for the column of the source text.


Step 6: Copy và Past the Formula

Select the translated cell. Right click và select copy. Highlight the other empty cells. Right click, select Paste Special, click on Paste Formula Only. This will copy the translation formula into the other cells.



If you get an error, refresh the document. The API isn’t perfect but it’s a great resource nonetheless. With Google Translate you still need to lớn double check the translations. It’s not 100% accurate but I’ve found Google Translate khổng lồ be quite good.


As an alternative, you can use the Google Spreadsheet I created và edit with your own words & phrases. Please make a copy of the Google Spreadsheet in your Google Drive so that you will have editing capabilities.