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:

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


1. -- others posts about SPARQL and Spreadsheet integration.

#LinkedData #SPARQL #Spreadsheet #SemanticWeb #SmartData #Excel   #CSV   #OpenData  
5 Photos - View album
Shared publiclyView activity