This link has been bookmarked by 55 people . It was first bookmarked on 15 Oct 2008, by Dan Callahan.
-
26 Oct 09
-
28 Sep 09
-
12 Jul 09
Simon WrightI started having a tinker with using Google spreadsheets as for data table screenscraping.
So here’s a quick summary of (part of) what I found I could do.google docs import html table wikipedia datasource mashup excel spreadsheet
-
06 Jul 09
-
17 May 09
-
14 May 09
-
06 May 09
-
26 Apr 09
Gary BurgeThe 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 t
-
09 Mar 09
-
03 Mar 09
-
23 Feb 09
-
10 Feb 09
-
24 Jan 09
-
14 Jan 09
-
01 Dec 08
-
20 Nov 08
-
08 Nov 08
-
Mark BlairPrompted in part by a presentation I have to give tomorrow as an OU eLearning community session (I hope some folks turn up - the 90 minute session on Mashing Up the PLE - RSS edition is the only reason I’m going in…), and in part by Scott Leslie’s compelling programme for a similar duration Mashing Up your own PLE session (scene scetting here: Hunting the Wily “PLE”), I started having a tinker with using Google spreadsheets as for data table screenscraping.
So here’s a quick summary of (part of) what I found I could do.
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. -
29 Oct 08
-
22 Oct 08
Casper KuijjerReally nice mashup showing how to import a table from Wikipedia and mapping it to Google Maps
mashup web2.0 yahoopipes google gmaps gdocs wikipedia information_extraction
-
Elizabeth Koha how-to of a mashup between google docs, wikipedia info and google maps.
-
21 Oct 08
-
19 Oct 08
marcell marsWe 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 YahooGoogle map.
google yahoo semantic software map storage programming social design
-
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
YahooGoogle map.
-
-
17 Oct 08
freddiedotseeehScrape Wikipedia data using Google Spreadsheets
-
Cindy MarstonFascinating article about remixing information - what we DO with data
-
Ben WTurn html tables into charts and maps with Google Spreadsheets & Yahoo Pipes, and Google Maps. Imagine the possibilities...
-
E. Alana Jameshow to take data from one online element and mashup with others for new ways to read/understand it
-
16 Oct 08
-
15 Oct 08
-
Rashid Al-Yahyaihow data collected from wikipedia, go to google spreadsheet then to Yahoo Maps and to Google
yahoo web2.0 web3.0 tools spreadsheet research rashid-interest
-
-
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.
-
Would you like to comment?
Join Diigo for a free account, or sign in if you are already a member.