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.

Answer 1

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.