Jieba VS OpenCC

jieba to do Chinese word segmentation

Jieba: Chinese text segmenter

If you know some python you can use a popular library called Jieba 结巴 to automatically get pinyin for every word. (Jieba has actually been ported to many languages) You can also use it to break a chinese text into a set of unique words for easy addition to your spreadsheet.

Since you're saying the main issue is segmentation, there are libraries to help out with that issue. jieba is fantastic if you have a Python backend, nodejieba (50k downloads/week) if it's more JS-side.

https://github.com/fxsjy/jieba/ (has some good word frequency data)

Try Open Chinese Convert. You can also install OpenCC via Homebrew as well. macOS can can convert between the two character sets, although it's not as smart as OpenCC (for example, macOS will convert「才」 to 「纔」 whereas OpenCC won't do this).

OpenCC: convert between traditional and simplified Chinese, see also http://opencc.byvoid.com/

Oh, also, there’s an online demo where you can test out the conversions. Also note that there may appear to be blanks in some of those files, or they may appear like empty rectangles, because some are very rare unicode characters. It’s possible to view them with special fonts or at GlyphWiki (example).

Many popular TV shows and movies have both traditional and simplified subtitles, and often have dual English/Chinese subtitles in both character sets. However if traditional subtitles are not available, then your only recourse is to convert a simplified subtitle to traditional. macOS has this functionality built-in, or you can try OpenCC (this is the GitHub repository. A web-based version is available here).