Data Scraping Wikipedia with Google Spreadsheets(ouseful.wordpress.com)

33 pointsby iamelgringo18 yıl önce7 comments

ouseful.wordpress.com

Data Scraping Wikipedia with Google Spreadsheets

http://ouseful.wordpress.com/2008/10/14/data-scraping-wikipedia-with-google-spreadsheets/

6 comments

"So to recap, we have scraped some data from a wikipedia page into a Google spreadsheet using the =importHTML formula, published a handful of rows from the table as CSV, consumed the CSV in a Yahoo pipe and created a geocoded KML feed from it, and then displayed it in a Yahoo map."

Hilarious!

blakeweb18 yıl önce

Fantastic. Such a cleaner method than copy-pasting table data from web pages into excel to visualize and manipulate it, which I've done countless times doing market research.

zandorg18 yıl önce

My BSc dissertation was on a simplified English dialect (language) which can be translated into triplets (or data items) while still being readable as English. However, I never really finished the editor it required which hooked up to a parser to show you the triplets as you type.

Also, I'm bad at getting traction on my ideas.

Jasber18 yıl önce

Or you could just use DBpedia: http://dbpedia.org/About

pedalpete18 yıl önce

the purpose isn't to show getting data from wikipedia. this can be done with any html table

PJGoldwing18 yıl önce

Bravo! One of the most useful submissions to HN in a while. This is the kind of thing that gives my faith in tech a little boost - "throwing sheep at your friends on facebook" or cute productivity apps that reduce your productivity are not.

theschwa18 yıl önce

does any one know of a way to incorporate google spreadsheets with ajax rendered table data?