prolyfik Posted March 23, 2007 at 01:54 PM Report Share Posted March 23, 2007 at 01:54 PM 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! Quote Link to comment Share on other sites More sharing options...
imron Posted March 24, 2007 at 12:37 AM Report Share Posted March 24, 2007 at 12:37 AM 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. Quote Link to comment Share on other sites More sharing options...
gato Posted March 24, 2007 at 03:06 PM Report Share Posted March 24, 2007 at 03:06 PM 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. Quote Link to comment Share on other sites More sharing options...
simonlaing Posted March 25, 2007 at 10:37 AM Report Share Posted March 25, 2007 at 10:37 AM 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:) Quote Link to comment Share on other sites More sharing options...
prolyfik Posted April 20, 2007 at 08:20 PM Author Report Share Posted April 20, 2007 at 08:20 PM 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! Quote Link to comment Share on other sites More sharing options...
gato Posted April 20, 2007 at 10:49 PM Report Share Posted April 20, 2007 at 10:49 PM Glad it worked for you. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and select your username and password later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.