Google Sheets has translation and pinyin functions

[markpete]

Hi, people.  I recently discovered that Google Sheets has a native translation function, as well as an available add-in that lets you generate pinyin.  So while I'm talking to a teacher or language partner, we can both add Chinese words to a shared sheet, and the English translation and the pinyin will automatically get filled in.  (It is a Google product, though, so people in Taiwan will have access but people in China generally won't.) 

 

Here is an example of how it works: https://bit.ly/2QKengc

 

This add-in for generating pinyin is called “Mandarin Cantonese API”, available at https://workspace.google.com/marketplace/

 

Cheers,

   Mark

[zhouhaochen]

That's interesting, thanks for sharing. How does it choose the right Pinyin for 多音字?

[mungouk]

It uses this Python code, by the same developer: https://github.com/lucwastiaux/python-pinyin-jyutping-sentence

 

Quote

Uses the Jieba library (https://github.com/fxsjy/jieba) to tokenize the sentence. Then words are converted to Pinyin/Jyutping either as a whole, or character by character, using the CC-Canto dictionary (http://cantonese.org/about.html). The Jyutping diacritic conversion is not standard but originally described here: http://www.cantonese.sheik.co.uk/phorum/read.php?1,127274,129006

 

Add-on's web page: http://api-docs.mandarincantonese.com/HELP

 

[Dawei3]

On 5/1/2021 at 2:24 PM, markpete said:

add-in that lets you generate pinyin

Hi Mark, Are you aware Word will do this as well?  I prefer what Word does because it puts the pinyin directly above the character.  In this way, I associate the pinyin to the character more closely (rather than with google that lists them separately).   Example below

 

[mungouk]

The online conversion tool (one of many) at the Purple Culture bookstore can do this as well, adding pinyin "ruby" text, even with the tones colour-coded.

 

https://www.purpleculture.net/chinese-pinyin-converter/