Save Google NGram result as .csv

Question

Is there an easy way, to save a Google Ngram result http://books.google.com/ngrams/ as a csv?

So that I get a list like

1900 peace 500000times
1901 peace 540000times 

and so on?

I downloaded their raw data but have no idea how to handle it. When I open those csv in OpenOffice, I can't even see a single word.

Answer 1

It can be done, and it's actually quite easy. Generate the graph you want on the Google Ngram viewer, then use your browser's function to show the page source code (this might be hidden under advanced or developer options). Then in the code (probably on line 297), you will find the data simply listed. You can use any word processor and/or spreadsheet software to clean up the data and export them as CSV.