CODEWITHSUNDEEP
xmlxlsxfile-conversionopendata
Sem
Sem

Reputation: 31

Converting a large XML file to Excel

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.

Upvotes: 3

Views: 16464

Answers (2)

drdmitry
drdmitry

Reputation: 13

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.

Upvotes: -1

Ettore Rizza
Ettore Rizza

Reputation: 2830

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.

Upvotes: 2

Related Questions