It’s not 100% accurate but I’ve found Google Translate to be quite good. With Google Translate you still need to double check the translations. The API isn’t perfect but it’s a great resource nonetheless. If you get an error, refresh the document. This will copy the translation formula into the other cells. Right click, select Paste Special, click on Paste Formula Only. C2 stands for the column of the source text. From the menu, click on Add-ons and select Mandarin Cantonese Tools and click on Use in this spreadsheetįollow the same instructions in step 2, but use the language code for Pinyin.Once complete, close the installer window.Click on Advanced and then click on Go to Mandarin Cantonese Tools In the search bar type in “Mandarin Cantonese API and click on the image.From the menu, click on Add-ons and select Get add-ons from the drop-down menu.In column 3, enter the formula to translate to Simplified Chinese = GOOGLETRANSLATE ( A2, “en”, “zh-cn” ).įor Pinyin, you will need to add the Mandarin Cantonese API. The code for Simplified Chinese is “zh-cn”. Anyone seeking a reliable Cantonese translator or interpreter can choose among the certified and non-certified Cantonese translations provided by Translationz. “en” is the source language, “zw-tw” is the language code for Traditional Chinese. In column 2, enter the formula to translate to Traditional Chinese = GOOGLETRANSLATE ( A2, “en”, “zh-tw” ).Ī2 is the cell you want to translate. In column 1, fill in the words and phrases you want to translate to Chinese. My example shows English, Traditional Chinese, Simplified Chinese, and Pinyin. Set up your column headers for English and Chinese. Go to Google Drive and open a new Google Sheet. Create your own translation document from scratch Step 1: Create Google Spreadsheet Please make a copy of the Google Spreadsheet in your Google Drive so that you will have editing capabilities. You can use the Google Spreadsheet I created and edit it with your own words and phrases. I find Google translate Chinese to have improved greatly over the last couple of years. Keep in mind the translation is only as accurate as Google Translate. Language options include Traditional Chinese, Simplified Chinese, and Pinyin. This is a helpful tutorial that sets up a Google Sheets document to automatically translate English to Chinese.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |