Automatically translate English to Chinese with Google Sheets

Step 1: Create Google Spreadsheet · Step 2: Fill in English · Step 3: Enter the Translate Formula · Step 4: Add Pinyin API · Step 5: Enter the Formula for Pinyin. Skiptocontent ThisisahelpfultutorialthatsetsupaGoogleSheetsdocumenttoautomaticallytranslateEnglishtoChinese.LanguageoptionsincludeTraditionalChinese,SimplifiedChinese,andPinyin.Sadlythere’snooptionforZhuyinyet.KeepinmindthetranslationisonlyasaccurateasGoogleTranslate.IfindGoogletranslateChinesetohaveimprovedgreatlyoverthelastcoupleofyears. Step1:CreateGoogleSpreadsheet GotoGoogleDriveandopenanewGoogleSheet.SetupyourcolumnheadersforEnglishandChinese.MyexampleshowsEnglish,TraditionalChinese,SimplifiedChinese,andPinyin. Step2:FillinEnglish Incolumn1,fillinthewordsandphrasesyouwanttotranslatetoChinese. Step3:EntertheTranslateFormula Incolumn2,entertheformulatotranslatetoTraditionalChinese=GOOGLETRANSLATE(A2,“en”,“zh-tw”). a2isthecellyouwanttotranslate.“en”isthesourcelanguage,“zw-tw”isthelanguagecodeforTraditionalChinese.ThecodeforSimplifiedChineseis“zh-cn”. Incolumn3,entertheformulatotranslatetoSimplifiedChinese=GOOGLETRANSLATE(A2,“en”,“zh-cn”). Step4:AddPinyinAPI ForPinyinyouwillneedtoaddtheMandarinCantoneseAPI. Fromthemenu,clickonAdd-onsandselectGetadd-onsfromthedropdownmenu Inthesearchbartypein“MandarinCantoneseAPIandclickontheimage InthenextwindowclickInstall InthepopupclickContinue SelectyourGoogleaccount Analertmessagewillappear.ClickonAdvancedandthenclickonGotoMandarinCantoneseTools InthenextwindowclickonAllow Oncecomplete,closetheinstallerwindow Fromthemenu,clickonAdd-onsandselectMandarinCantoneseToolsandclickonUseinthisspreadsheet Step5:EntertheFormulaforPinyin Followthesameinstructionsinstep2,butusethelanguagecodeforPinyin .C2standsforthecolumnofthesourcetext. Step6:CopyandPasttheFormula Selectthetranslatedcell.Rightclickandselectcopy.Highlighttheotheremptycells.Rightclick,selectPasteSpecial,clickonPasteFormulaOnly.Thiswillcopythetranslationformulaintotheothercells. Notes Ifyougetanerror,refreshthedocument.TheAPIisn’tperfectbutit’sagreatresourcenonetheless.WithGoogleTranslateyoustillneedtodoublecheckthetranslations.It’snot100%accuratebutI’vefoundGoogleTranslatetobequitegood. Asanalternative,youcanusetheGoogleSpreadsheetIcreatedandeditwithyourownwordsandphrases.PleasemakeacopyoftheGoogleSpreadsheetinyourGoogleDrivesothatyouwillhaveeditingcapabilities. OneyouhaveyourlistyouandeasilycreateflashcardsinQuizlet. VideoTutorial:HowtosetupGoogleSheetstoautomaticallytranslateEnglishToChinese Hopeyoufoundmyposthelpful.CheckouttheseotherresourcestolearnChinese. Enjoythiscontent?Pleaselikeandshare!🙂 Postnavigation ChineseCharacterPaintedCookies →← NightMarketGamewithChineseFlashCards 8thoughtson“AutomaticallytranslateEnglishtoChinesewithGoogleSheets” Jesssays:Doesthisworkforjyutpingand/orcantonesetranslationaswell? Reply April7,2020at4:49pm JeanneChangsays:Ihaven’ttrieditbutitshouldasitwascreatedforCantonese.Insteadofthecode=PINYIN,use=JYUTPING Reply April17,2020at1:33am Lucsays:Hi, I’mtheauthoroftheMandarinCantoneseadd-onongooglesheets.IrecentlyaddedsupportforPinyinontraditionalcharacters(asopposedtoonlyforJyutping).I’mplanningondevelopingmoretoolsinthisspace.Youcanfollowthelatestonmypatreonpage:https://www.patreon.com/lucw Reply August28,2020at7:23am JeanneChangsays:Thankyouforcreatingsuchafantastictoolforus.IwillupdatethispostsoonwiththePinyinadd-on🙂 Reply August29,2020at7:00am MadisonLinsays:hi,itsnolongerworkingtotranslatetopinyin?ihadafilewhichworkedbeforeandnowitsall#NAME? Reply October28,2021at5:20pm JeanneChangsays:Thankyouforlettingmeknow.Notsurewhathappenedbutthelinkhasbeenupdated.Pleasemakeacopyofthedocumenttoaddyourownedits. Reply October31,2021at6:46pm Tinasays:MayIknowisthatpossibletotranslatefromChinesetoEnglish?Thankyou Reply April23,2021at6:12am JeanneChangsays:Yes,youcantranslatefromChinesetoEnglishbyreversingthespreadsheetformula Reply April23,2021at6:47am LeaveaReplyCancelreplyYouremailaddresswillnotbepublished.Requiredfieldsaremarked* RecipeRating RecipeRating CommentName* Email* Website Signupforfreelearningresources! EmailAddress FirstName LastName RecentPosts 新小小牛頓NewLittleNewtonMagazine HolidayMoviesinMandarinChinese PodcaststoLearnChinese FoodieGiveaway FreeOnlineChineseStorytime