After 3,5 years of Mandarin classes I took to Taobao to buy a gaming console to play Pokémon LeafGreen from 2004: 口袋妖怪-绿叶. Here I take you through the process and adventure of learning new words and catching Pokémon.
– For Chinese to English, use a formula such as =GOOGLETRANSLATE(A1,”zh-CN”,”en”)
– For characters to Pinyin, install the Google Spreadsheet addon ‘Mandarin Cantonese Tools’ and use the formula =PINYIN(A1)
Replace A1 with the variable you need.