Jump to content
Learn Chinese in China

  • Why you should look around

    Since 2003, Chinese-forums.com has been helping people learn Chinese faster and get to China sooner. Our members can recommend beginner textbooks, help you out with obscure classical vocabulary, and tell you where to get the best street food in Xi'an. And we're friendly about it too. 

    Have a look at what's going on, or search for something specific. We hope you'll join us. 

Hanzi to Pinyin in Excel?

Recommended Posts



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!

Share this post

Link to post
Share on other sites
Site Sponsors:
Pleco for iPhone / Android iPhone & Android Chinese dictionary: camera & hand- writing input, flashcards, audio.
Study Chinese in Kunming 1-1 classes, qualified teachers and unique teaching methods in the Spring City.
Learn Chinese Characters Learn 2289 Chinese Characters in 90 Days with a Unique Flash Card System.
Hacking Chinese Tips and strategies for how to learn Chinese more efficiently
Popup Chinese Translator Understand Chinese inside any Windows application, website or PDF.
Chinese Grammar Wiki All Chinese grammar, organised by level, all in one place.


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.

Share this post

Link to post
Share on other sites

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.

Share this post

Link to post
Share on other sites

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


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.


Share this post

Link to post
Share on other sites

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!

Share this post

Link to post
Share on other sites

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.

Click here to reply. Select text to quote.

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...