Converting Chinese characters to Pinyin or Jyutping on Google Sheets

If you study Mandarin, you probably know what Pinyin is. In Cantonese, Jyutping fulfills a similar role. Dictionaries will show you the Pinyin for individual words, but if you want to quickly convert whole sentences, such as when taking notes during a Chinese lesson, you need better tools.

Image for post
Image for post
Support my work on this add-on

Step 1: new spreadsheet

Image for post
Image for post

Step 2: choose add-on

Image for post
Image for post

Step 3: use pinyin conversion function

You can also use =JYUTPING(A2) if you are learning Cantonese.

Image for post
Image for post
Image for post
Image for post

Step 4: extend the formula to other rows

Image for post
Image for post

Done ! You can now quickly convert lots of chinese words or sentence to pinyin, which is particularly useful when taking notes during a Chinese lesson, especially if you’re going to convert those notes to flashcards. You can directly export the result to CSV and import into Anki.

Follow me on Patreon to receive updates about new functionality: https://www.patreon.com/lucw

This addon makes use of the following open source library: https://github.com/lucwastiaux/python-pinyin-jyutping-sentence

Written by

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store