]]>By: Kevinhttps://blog.ouseful.info/2008/10/14/data-scraping-wikipedia-with-google-spreadsheets/#comment-36599
Tue, 26 Mar 2013 03:11:49 +0000http://ouseful.wordpress.com/?p=306#comment-36599Can’t get my pipes to work. any ideas? i can get it in the correct format using this =QUERY(ImportHtml(“http://en.wikipedia.org/wiki/List_of_largest_United_Kingdom_settlements_by_population”,”table”,2),”SELECT Col1, Col2, Col3 LABEL Col1 ‘rank’, Col2 ‘city’, Col3 ‘population'”)
in google docs, but it is not showing up correcting in pipes. Appreciate any help!!
]]>By: WordPress – Weekly Dump (weekly) | ResponsiPaulhttps://blog.ouseful.info/2008/10/14/data-scraping-wikipedia-with-google-spreadsheets/#comment-32778
Tue, 19 Feb 2013 07:07:38 +0000http://ouseful.wordpress.com/?p=306#comment-32778[…] Data Scraping Wikipedia with Google Spreadsheets « OUseful.Info, the blog… […]
]]>By: Andyhttps://blog.ouseful.info/2008/10/14/data-scraping-wikipedia-with-google-spreadsheets/#comment-32571
Sat, 16 Feb 2013 14:20:04 +0000http://ouseful.wordpress.com/?p=306#comment-32571Awesome. Now I just need to work out how to do it on a private (ie logon required) site, as I have loads of data i could manipulate that i can’t really get to otherwise, any ideas?
]]>By: ibook21.comhttps://blog.ouseful.info/2008/10/14/data-scraping-wikipedia-with-google-spreadsheets/#comment-32506
Fri, 15 Feb 2013 18:45:48 +0000http://ouseful.wordpress.com/?p=306#comment-32506Hiya! I know this is kinda off topic nevertheless I’d figured I’d ask.
Would you be interested in exchanging links or maybe guest authoring a blog article
or vice-versa? My site goes over a lot of the same subjects
as yours and I believe we could greatly benefit from each
other. If you’re interested feel free to send me an e-mail. I look forward to hearing from you! Excellent blog by the way!
]]>By: When a Hack Goes Wrong… Google Spreadsheets and Yahoo Pipes « OUseful.Info, the blog…https://blog.ouseful.info/2008/10/14/data-scraping-wikipedia-with-google-spreadsheets/#comment-31695
Tue, 05 Feb 2013 17:25:34 +0000http://ouseful.wordpress.com/?p=306#comment-31695[…] One of my most successful posts in terms of lifetime traffic numbers has been a recipe for scraping data from a Wikipedia page, pulling it into a Google spreadsheet, publishing it as CSV, pulling it into a Yahoo Pipe, geo-coding it, publishing it as a KML file, displaying the KML in Google maps and embedding the map in another page (which could in principle be the original WIkipedia page): Data Scraping Wikipedia with Google Spreadsheets. […]
]]>