How to get data into a Google Spreadsheet via SPARQL. Note, you can't pull this off via ODBC, JDBC, ADO.NET etc.. Exactly why Linked Data is an utterly superior option for real Open Data Access.


1. http://goo.gl/iddXC -- SPARQL Protocol URL (Results) in CSV format

2. http://goo.gl/N81Qf -- SPARQL Protocol URL (Actual Query Editor with Query)

3. goo.gl/t3ZXR -- Google Spreadsheet with data loaded directly from DBpedia via SPARQL Protocol URL.

The formula used in my Google Spreadsheet:

=ImportHtml("{SPARQL-Protocol-URL-For-My-Query-Results}";"table";1)

Live specimen that you can paste into any Google Spreadsheet cell:

=ImportHtml("http://dbpedia.org/sparql?default-graph-uri=&query=select+distinct+%3Fperson+%3Fgenre+%3Fdied+%3Fborn+from+%3Chttp%3A%2F%2Fdbpedia.org%3E+where+%0D%0A+%7B+%0D%0A+++%3Fperson+a+%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2FMusicalArtist%3E+%3B%0D%0A++++++%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2Fgenre%3E+%3Fgenre%3B%0D%0A++++++%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2FdeathDate%3E+%3Fdied%3B%0D%0A++++++%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2FbirthDate%3E+%3Fborn+.%0D%0A%0D%0A+++%0D%0A+%7D%0D%0A%0D%0Alimit+20&format=application/vnd.ms-excel&CXML_redir_for_subjs=&CXML_redir_for_hrefs=&save=display&fname=";"table";1)

Related

1. https://plus.google.com/u/0/112609322932428633493/posts/egXaoyvhYRm -- post by +Danny Ayers that triggered this incarnation of the SPARQL to Google Spreadsheet demo .

2. http://goo.gl/ovqPL -- earlier post about Linked Data and why it trumps ODBC, JDBC, ADO.NET, JDO, OLE-DB etc..

3. http://danbri.org/words/2008/01/06/246 -- circa. 2008 post about the same matter via +Dan Brickley post .

#SPARQL #LinkedData #SemanticWeb #NoSQL #CoRelational #CoSQL #SPARQL
Shared publiclyView activity