I've been studying Mandarin for a while and I've come across a pretty good website called chinasmack.com. It's good because it has Chinese articles translated into English along with the internet comments of Chinese people who respond to the articles. The comments are the most useful for me because they're very informal and I like how funny they usually are.

Knowing that the English translation of the comments are on the website along with the original Chinese, I wanted to create a spreadsheet that had the original Chinese comments in one column and the translated English in another column.

I don't want to spend hours and hours copying and pasting the original Chinese comments and their English translations manually so I was wondering if anyone could help me write a program that would do that for me.

I'm not very good at programming so I'm stumped. I want the program to just copy each original sentence from chinasmack and input it into a spreadsheet in one column and do the same with the English translations in another column.

I was wondering if anyone knew how to do this. Thank you!

[ファブリス]

Well unfortunately that's quite a bit of work. You'd want to make either a Perl / Python script and use something like curl to fetcth the html code and process it. Or you'd make an extension for the browser.

In the latter case it's a good idea to check userscripts.org to see if someone created a script for the website.

In general if the text in the browser contains TABs or uses a HTML table, then you can select text across cells and copy/paste to a spreadsheet and it will spread across rows and columns accordingly.

I think you may have better luck with a website actually aimed at Chinese language learners. Click the "Wiki" tab above and check out some of the Chinese website resources in there.

I'll check to see if there is something similar to what I want that's already out there. In the meantime, I guess I'll look up ways to do this in Python. Thanks.