Converting a large XML file to Excel

0 votes

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.

Mar 23 in Database by Edureka
• 9,320 points
62 views

1 answer to this question.

0 votes
Using the web URL, import an XML file into Excel.
Open the Excel file into which the data will be imported.
Toggle to the Data tab.

Select the 'Get Data' option from the Get & Transform group.

Select 'From Other Sources' from the drop-down menu.

Select 'From Web' from the drop-down menu.

Copy and paste the URL for the XML data into the 'From Web' dialogue box.

Click the OK button.
answered Mar 24 by Edureka
• 8,820 points

Related Questions In Database

0 votes
1 answer

How to view the XML form of an Excel file?

Excel is a spreadsheet programme. Click File->Open in ...READ MORE

answered Mar 25 in Database by Edureka
• 9,320 points
51 views
0 votes
0 answers

How would I use excel to generate a large update sql statement?

I know there's a way to have ...READ MORE

Mar 30 in Database by Edureka
• 9,320 points
23 views
+2 votes
1 answer

How to export data from MySql to a CSV file?

If you are using MySql workbench then ...READ MORE

answered Jan 4, 2019 in Database by Priyaj
• 58,060 points
359 views
0 votes
1 answer
0 votes
1 answer

Convert a number to a letter in C# for use in Microsoft Excel [duplicate]

If you are familiar with using formulas ...READ MORE

answered Feb 23 in Database by Edureka
• 8,820 points
35 views
0 votes
1 answer

Converting HTML to Excel? [closed]

Upload html-file(s) Select files from Computer, Google ...READ MORE

answered Feb 23 in Database by Edureka
• 8,820 points
20 views
0 votes
0 answers

How to import JSON file to Excel without coding?

Let's say you have a file named input.json which ...READ MORE

Feb 24 in Database by Edureka
• 9,320 points
23 views
0 votes
1 answer
0 votes
1 answer

How to open a password protected excel file using python?

I recently came upon a Python package ...READ MORE

answered Apr 6 in Database by Edureka
• 8,820 points
93 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP