Shared publicly  - 
 
How To Import Data Into Excel via SPARQL

1. Locate a SPARQL Service (e.g. Virtuoso's) that supports CSV as an output for SELECT, DESCRIBE, or CONSTRUCT queries

2. Execute your query with CSV output parameter

3. Copy the SPARQL Query Results URL to your OS clipboard

4. Use a URL shortener to shorten the SPARQL Results URL

6. Start Excel

7. Follow the File | Open URL menu path and then paste in your SPARQL Results URL

8. Let Excels CSV import wizard do the rest.

Sample SPARQL Protocol URL: http://bit.ly/Tp61H3

Note: I've attached screenshots that illustrate my steps.

Related

1. https://plus.google.com/s/spreadsheet%20linked%20data%20idehen%20sparql -- others posts about SPARQL and Spreadsheet integration.

#LinkedData #SPARQL #Spreadsheet #SemanticWeb #SmartData #Excel   #CSV   #OpenData  
4
2
Aravind Sesagiri Raamkumar's profile photoEmeka Okoye's profile photo
Add a comment...