CODEWITHSUNDEEP
excelrdfrdf-xml
Arduino
Arduino

Reputation: 373

Read RDF/XML file from website in Excel

I need to read a RDF/XML file from a website but haven't figured out how yet after reading some other posts and have no previous experience with such files.

Ideally I would convert this file to be dealt with Excel as a bunch of data, can anyone guide me a hint with the file?

Upvotes: 0

Views: 2445

Answers (1)

Ivo Velitchkov
Ivo Velitchkov

Reputation: 2431

You can easily get a table of all triples in your file, using for example the Structured Data Sniffer, which is a browser extension. This would be the result. If you change "uri=&query=" with "uri=&qtxt=", you'll enter edit mode. There you can choose CSV or another result format.

Yet, having the list of triples would not be a very useful result, so you need to explore your data. A good starting point would be to run

SELECT DISTINCT ?property
FROM <http://www.bcn.cat/tercerlloc/serveis_socials.rdf>
WHERE {
  ?s ?property ?o .
}

This will give you the list of properties, a subset of which you'd finally use as columns of your result table. Then you can run other exploratory queries, until you get sufficient understanding of your data set.

Upvotes: 2

Related Questions