Please read our privacy policy for details about how we handle your data.
Please read our terms of service for details.
Convert Chinese characters to Hanyu Pinyin with tone numbers in Google Sheets.
MOTET HANYUPINYIN is a Google Sheets custom function that converts Chinese characters to Hanyu Pinyin annotation with tone numbers.
=MOTET_HANYUPINYIN(text) - text is the only parameter for this function.
Chinese characters are expected as input. The output is a corresponding space-delimited list of Hanyu Pinyin (toneme) sounds.
Please read our privacy policy for details about how we handle your data.
This Google Sheets custom function requires the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonly - limits the visibility to your current spreadsheet only
https://www.googleapis.com/auth/script.external_request - allows the function to fetch and cache the latest pinyin conversion data
OPTION #1: Install this Google custom function from the Google Workspace store. (COMING SOON, MAYBE...)
OPTION #2: Copy and paste the code below into your Apps Script editor in Google Sheets.
Use the contact form to share feedback or report an issue.