3

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.

Dev-iL
  • 23,742
  • 7
  • 57
  • 99
Sem
  • 31
  • 1
  • 1
  • 2
  • 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. – user27874 Mar 23 '17 at 15:35

2 Answers2

2

The conversion with Excel works for me.

enter image description here

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.

Ettore Rizza
  • 2,800
  • 2
  • 11
  • 23
-1

One of the ways would be to use Online XML to Excel Converter, for example, provided by Conversion Tools - https://conversiontools.io/convert/xml-to-excel.

You upload the XML file and in a minute download the Excel file which has a table structure.

So the structured data from the XML file will be transformed into the table format.

For Converting XML to CSV - use the following page https://conversiontools.io/convert/xml-to-csv.

drdmitry
  • 21
  • 5