After installing this add-on on Google Sheets, you now have access to the PINYIN() and JYUTPING() functions.
- Type some chinese text into cell A1 such as 你好
- In cell A2, enter the formula =PINYIN(A1). You should see the text nǐhǎo appear.
- Similarly, you can use the JYUTPING() formula for Cantonese.
- More detailed tutorial: Converting Chinese characters to Pinyin or Jyutping on Google Sheets
- Advanced functionality: Converting Chinese Characters to Pinyin/Jyutping on Google Sheets: now with more functionality
You can view our Privacy Policy here
You can open an issue on github, or email mandarincantonese@mailc.net to report any problems.
Want to support my work on this add-on, and get priority feature requests, bug fixes ? Become a supporter on patreon: https://www.patreon.com/lucw