Converting a large XML file to Excel

0 votes

I want to convert the following XML file (WARNING: it's 40MB) 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, 2022 in Database by Edureka
• 13,690 points
2,847 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, 2022 by gaurav
• 23,260 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, 2022 in Database by Edureka
• 13,690 points
6,221 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, 2022 in Database by Edureka
• 13,690 points
2,369 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,020 points
1,575 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, 2022 in Database by gaurav
• 23,260 points
846 views
0 votes
1 answer

Converting HTML to Excel? [closed]

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

answered Feb 23, 2022 in Database by gaurav
• 23,260 points
593 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, 2022 in Database by Edureka
• 13,690 points
780 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, 2022 in Database by gaurav
• 23,260 points
10,049 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP