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?
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.