This is a helpful tutorial that sets up a Google Sheets document lớn automatically translate English 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 have improved greatly over the last couple of years.

Step 1: Create Google Spreadsheet

Go khổng lồ Google Drive and mở cửa a new Google Sheet. Set up your column headers for English & Chinese. My example shows English, Traditional Chinese, Simplified Chinese, và Pinyin.


Step 2: Fill in English

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


Step 3: Enter the Translate Formula

In column 2, enter the formula to translate to 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 to translate to lớn Simplified Chinese =GOOGLETRANSLATE(A2, “en”, “zh-cn”).


Step 4: địa chỉ cửa hàng Pinyin API

For Pinyin you will need to showroom the Mandarin Cantonese API.

From the menu, click on Add-ons và 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 & 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 and select Mandarin Cantonese Tools & 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 & 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 to lớn be quite good.


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