Help & Support
Send Feedback
HanyuPinyinTools
Converts Chinese text to Hanyu Pinyin, with or without tone marks.
inpinyin.com
4 users
Works with
Install
Overview
FEATURES
--Comprehensive tone sandhi
--Automatic removal of tone 5 tone mark annotation
--Converts Traditional and Simplified Chinese characters
--Converts a single text value or a range of text values
--Convert from tone numbers to tone marks
--Convert from tone marks to tone numbers
--Convert to tone marks specified in ISO standard for transliteration

POSSIBLE USES
--Build and share new vocabulary lessons directly in Google Sheets
--Design and deploy a custom dictionary lexicon
--Create Android apps powered by Google Sheets
--Instruction support for a classroom-based activity
--Tutoring and online collaboration for a custom Mandarin Chinese curriculum

CUSTOM FUNCTIONS LIST
=HANYUPINYIN(text): pinyin with tone numbers.
=HANYUPINYIN_TONELESS(text): pinyin with no tones.
=HANYUPINYIN_TONEMARKS(text): pinyin with backwards-compatible tone marks.
=HANYUPINYIN_TONEMARKS_ISO(text): pinyin with ISO tone marks.



PREVIOUS VERIONS
--Functions list now loads faster.
--Bug fixes.
--Improved performance.
-- Adds the ability to convert a text value or a text range. Using ranged text input allows for more conversions with "fewer" function calls. For example, either formula HANYUPINYIN_TONEMARKS(A1) or HANYUPINYIN_TONEMARKS(A1:A15) will work.
--Adds new method HANYUPINYIN_TONEMARKS_ISO with ISO 7098 compliant format, with caron diacritic
--Reverts HANYUPINYIN_TONEMARKS to backwards-compatible format, with breve diacritic; should fix issues with apps that are looking for this version of third tone.
--Better, cleaner code, for better performance
--Improved tone removal for HANYUPINYIN_TONELESS function
--Bug fixes and improvements
--Pinyin third tone is now a ISO 7098 compliant caron (not a breve)
--More efficient tone processing


#InPinyin
Reviews
December 2, 2018
Very useful. There are some performance issues however - if you try to convert 1000 characters to pinyin it will take 10s of minutes.
Submit reply
Cancel
May 31, 2018
Great addon. Adds all the functionality for converting 中文 into Zhōngwén.
Submit reply
Cancel
February 16, 2018
Tools works great at conversion But what happened to the jyutping version of this tool?
Submit reply
Cancel
February 12, 2018
Does exactly what you'd expect, and I like the options for including or hiding tone marks.
Submit reply
Cancel
June 29, 2017
Love it, it's just work
Submit reply
Cancel
April 4, 2017
Super helpful to get the PinYin from Chinese characters. The example, nor the slideshow shows that you can remove the tones, so I was pleasantly surprised that it's built-in!
Submit reply
Cancel
1-6 of 6
Additional information
Search
Clear search
Close search
Google apps
Main menu