Data Scraping

Google Spreadsheets + Wikipedia

Here's an amazing tutorial about how to data-scrape Wikipedia tables using Google spreadsheets:

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

Here's the short, technical version:

The Google spreadsheet function =importHTM(”",”table”,N) will scrape a table from an HMTL web page into a Google spreadsheet. The URL of the target web page, and the target table element both need to be in double quotes. The number N identifies the N’th table in the page (counting starts at 0) as the target table for data scraping.

And it's free! Free as in beer!

Added by 1rick

How do you use Google Spreadsheets + Wikipedia?

Please login to comment