Study Chinese - Hanzi to Pinyin in Excel? -

> Learning Chinese > Chinese Computing and Technology
Hanzi to Pinyin in Excel?
Home New Posts

Login: Pass: Log in or register for standard view and full access.








prolyfik -

Hi,

I'm hoping someone may know how to do this...

I've got a long list of Chinese characters in Excel. Is there some kind of automated method for
taking characters in Hanzi form in one column and getting the next column over to show the
corresponding Pinyin?

Thanks in advance for any tips!



Pleco Software Learn Chinese with our Dictionaries for Palm and Pocket PC.
Learn Chinese in China Learn to speak Chinese 1MonthChinese.com -Mandarin School in China.
Chinese Textbooks Wide range, cheap, varied languages. Also Chinese cartoons, toys, gifts.
Study Chinese in Beijing Affordable Mandarin language courses at BLCU with ChinaUnipath.com.
HNHSoft Dictionary Learn Chinese on Smartphone and PDA with real person's voice.
XueXueXue IQChinese Get beyond the plateau.Take your Mandarin to a new level.
Chinese in Lijiang Short term Chinese study in a beautiful town with a focus on daily life.
MandarinTube Chinese Access to current everyday Chinese language and culture, 24/7.
Learn Chinese Homestay Chinese course, cultural activities & volunteer events in China.
Learn Chinese Online 1-on-1 instant tutoring, diverse courses, native teachers. FREE trial now!
Nihao Chinese Progam Free one-on-one Chinese lesson. Win 5-years of free lessons now!


About Ads (and how to hide them) -- Your message here









imron -

Probably your best bet is to copy the entire column, go to the adsotrans advanced page, set the
style to be pinyin, paste all the chinese characters, adsotate, and then copy and paste all the
pinyin back into the excel spreadsheet.










gato -

You can also do this using copy&paste and HanConv
http://www. /showth...hlight=hanconv

But HanConv's download site seems to be download right now.

The steps to do so are:
1. Copy & paste your column of characters from Excel into the leftside box in HanConv.
2. Use HanConv to convert these characters to pinyins. The pinyin output is shown in the rightside
box.
3. Copy & paste the column on pinyins in the right side into an empty column in Excel.










simonlaing -

There is also a similar tool in chinese-tools.com.

http://www.chinese-tools.com/tools/pinyin.html

It also involves copy and pasting , but at least keeps the pinyin together if you put separate.
though for 好 it often gives the fourth tone as well as the 3rd tone.

hmarty.free.fr/hanzi (yes no www) has some annotators good for big paragraphs.

Have fun.
Simon










prolyfik -

I just wanted to say thanks to all who replied.

I finally got around to trying out the suggestions that were put forward. It looks like the method
suggested by gato works the best because it does bulk translations at a time and will allow me to
easily cut & paste whole columns at once.

Thanks again to everyone!










gato -

Glad it worked for you.












All times are GMT +8. The time now is 04:55 PM.














Learn Chinese, Chinese School, Learning Materials, Mandarin audio lessons, Chinese writing lessons, Chinese vocabulary lists, About chinese characters, News in Chinese, Go to China, Travel to China, Study in China, Teach in China, Dictionaries, Learn Chinese Painting, Your name in Chinese, Chinese calligraphy, Chinese songs, Chinese proverbs, Chinese poetry, Chinese tattoo, Beijing 2008 Olympics, Mandarin Phrasebook, Chinese editor, Pinyin editor, China Travel, Travel to Beijing, Travel to Tibet