Scraping tabular data from the web

I’ve been looking for a quick and easy solution to scrape an HTML table into a usable format. Of course, there are numerous solutions to do that in some small Perl/PHP/Python programme, but I found another path especially elegant. It turns out, Google Docs has an importHTML() function in Spreadsheets: =importHTML(“http://www.parlamentswahlen-2011.ch/resultate-a-z.html”,”table”,1) scrapes the first (1) … Continue reading Scraping tabular data from the web