Converting a large XML file to Excel

Question

I want to convert the following XML file (WARNING: it's 40MB), http://www.rvo.nl/sites/default/files/open_data/dop_projecten.xml, to a more readable format. Any hints on how to do this?

I have been trying to convert it to Excel, but it keeps crashing. My primary goal is to be able to sort the different projects in the file on the basis of year or Allterms.

Solution

The conversion with Excel works for me.

The structure of this XML is very simple, but it's a pretty big file (39 Mb), so it'll take a few minutes. Perhaps your computer lacks memory. Here is the file in CSV format if it can help.

Comments

[user27874]

more readable by what, a human, or a computer program? Note that Excel is an XML format, that's what the x means at the end of xls.