Converting a large XML file to Excel

xml xlsx file-conversion opendata
Sem picture Sem · Mar 21, 2017 · Viewed 11.1k times · Source

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

Ettore Rizza picture Ettore Rizza · Mar 21, 2017

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.

Related questions

xlsx error: "Removed Records: Named range from /xl/workbook.xml part" when tried to resolve errors

I have an xlsx file that I generate using SSIS. The data to this file is written through a data flow task where the xlsx file is the oledb destination. I have used the following connection string as an expression …

Read More
How to properly assemble a valid xlsx file from its internal sub-components?

I'm trying to create an xlsx file programmatically on iOS. Since the internal data of xlsx files is basically stored in separate xml files, I tried to recreate xlsx structure with all its files and subdirectories, compress them into a …

Read More
Looking for a clear description of Excel's .xlsx XML format

Microsoft Excel's ".xlsx" files are zip files that each contain a set of files. Could someone please provide a link that concisely describes the full structure/syntax/markup/format of the embedded .xml files (the headers are less interesting)? For …

Read More