How to Convert Large XML to Excel – 2 Methods

Method 1 – Using a File Stored in the System Memory

Steps:

• Go to Data > Get Data > From File.
• Select From XML.

• In the selection box, locate and select the XML file to import.

• The XML file will be displayed in the Navigation box.

• Select the worksheet to import. Here, sitemap.

• Click Load to see the XML data in your sheet.

Optional:

• To modify data, select Transform before choosing Load. The table will be displayed in the Power Query Editor (you can edit table data and headings, remove or add data)

Read More: How to Convert XML to Columns In Excel

Method 2 – Utilizing a Web-Link to Convert Large XML to Excel

Steps:

• Go to the Data tab and select Get Data.
• Click From Other Sources and select From Web.

• In the dialog box asking for the site link or the XML file’s link, copy and paste your XML file link and click OK.

• The file will be displayed in the Navigator box: the source file location is the weblink.

• Follow the steps described in the previous method: select sitemap and click Load.

• After loading the file into Excel, a separate worksheet (sitemap) is displayed with a table containing the XML data.

Read More: How to Extract Data from XML File to Excel

Download Practice Workbook

Download the practice workbook.

Related Articles

• Difference Between XML and Excel Files
• [Solved]: XML File Not Opening in Excel
• How to Convert XML to Excel Table
• How to Edit XML File in Excel
• VBA Code to Convert XML to Excel

<< Go Back to Import XML to Excel | Importing Data in Excel | Learn Excel