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. -- SPARQL Protocol URL (Results) in CSV format

2. -- SPARQL Protocol URL (Actual Query Editor with Query)

3. -- Google Spreadsheet with data loaded directly from DBpedia via SPARQL Protocol URL.

The formula used in my Google Spreadsheet:


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



1. -- post by +Danny Ayers that triggered this incarnation of the SPARQL to Google Spreadsheet demo .

2. -- earlier post about Linked Data and why it trumps ODBC, JDBC, ADO.NET, JDO, OLE-DB etc..

3. -- circa. 2008 post about the same matter via +Dan Brickley post .

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