Jump to content
Learn Chinese in China

Google Sheets has translation and pinyin functions

Recommended Posts


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/




  • Thanks 1
  • Helpful 2
Link to post
Share on other sites
Site Sponsors:
Pleco for iPhone / Android iPhone & Android Chinese dictionary: camera & hand- writing input, flashcards, audio.
Study Chinese in Kunming 1-1 classes, qualified teachers and unique teaching methods in the Spring City.
Learn Chinese Characters Learn 2289 Chinese Characters in 90 Days with a Unique Flash Card System.
Hacking Chinese Tips and strategies for how to learn Chinese more efficiently
Popup Chinese Translator Understand Chinese inside any Windows application, website or PDF.
Chinese Grammar Wiki All Chinese grammar, organised by level, all in one place.


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

Link to post
Share on other sites

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



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


Link to post
Share on other sites
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



  • Like 1
Link to post
Share on other sites

Join the conversation

You can post now and select your username and password later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Click here to reply. Select text to quote.

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...