Batch mode, tone numbers, spaces between syllables now supported.

Please read https://medium.com/@lucw/converting-chinese-characters-to-pinyin-or-jyutping-on-google-sheets-eb12cca669cb to install the addon. This article focuses on the new functionality.

Support my work on this add-on

Batch Mode

You can now pass a range of cells or a whole column to the PINYIN() / JYUTPING() fuctions, for example:

  • PINYIN(A:A) this will convert any chinese text present in column A. It will keep on converting as you add new rows in column A. Make sure you have no existing text in the target column.
  • PINYIN(A3:A) this will convert any chinese text present in column A, starting at row…


AnkiReview is a flashcard reviewing app, companion to AnkiDroid. It was meant to make the reviewing experience more pleasant, making use of animations and swiping gestures.

Early on during development, I made a bold choice: I was going to break compatibility with traditional Anki HTML/CSS templates, and introduce a new, easy to use templating system. You can read about it here: https://medium.com/@lucw/ankireview-yet-another-flashcard-app-5fa3e708bc1e . I did this in part to introduce a slick animation when revealing the answer.

While this worked great for very simple text-based flashcards like language decks, it introduces severe limitations: no images, and users have to re-implement…


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.

Support my work on this add-on

Step 1: new spreadsheet

Open new spreadsheet on https://docs.google.com/spreadsheets/ . Enter the following column headers: Chinese and Pinyin.


AnkiReview is a flashcard app/plugin which works in conjunction with AnkiDroid and focuses on a smooth reviewing experience. I realized early on when reviewing Chinese flashcards that I frequently need to mark or annotate a card if the definition or usage is unclear.

Support my work on AnkiReview

In my case, this need would come up in under the following circumstances:

  • I don’t understand the English definition.
  • The definition seems incorrect or needlessly long (particularly if copied from the dictionary).
  • I need an example sentence to really memorize this word.


A lot of Chinese learners ask me how to get started with flashcards. Here’s a beginner-friendly step by step guide for Android users, using AnkiReview.

Support my work on AnkiReview

Start by installing AnkiDroid. Then head over to the list of shared Anki decks. We’ll use this deck as an example: Chinese/English — Comprehensive Compilation — With Examples. Scroll down and you’ll see a download link. Download the shared deck to your Android phone. Then, open AnkiDroid, click the menu (upper right hand corner) and choose Import. Browse to the location of the .apkg file you just downloaded.


I’ve been using flashcards for language learning for close to a decade now and experimented with various setups. If you’re learning Chinese, the flashcard module in Pleco certainly deserves a look. Having the the ability to add entries off the dictionary saves you the hassle of manual entry.

Support my work on AnkiReview

LucW

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