Hanzi to Pinyin in Excel?

[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!

[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.chinese-forums.com/index.php?/topic/6972-adding-pinyin-to-hanzi&highlight=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.