How to Convert XML to Excel Table (3 Easy Methods)

What Is an XML File?

An XML file can store data in a readable format for different applications and systems. XML stands for Extensible Markup Language. The XML file is mainly used for storing and transporting data that various applications use.

You can open an XML file with a text editor if it contains text data and make the necessary changes. You can extract the XML file to Excel if it contains tables.

Here’s a sample of an XML file we will convert to Excel.

XML file to Convert it to Excel Table


Method 1 – Using the Data Tab to Convert an XML to an Excel Table

Steps:

  • From the Data tab, go to the Get Data menu.
  • From the From File feature, select From XML.

Use of Data Tab to Convert XML to Excel Table

  • You will get a new window named Import Data.
  • Select your XML file.
  • Click on Import.

  • You will see the window named Navigator.
  • Select the record file.
  • Click on Load.

  • You will see the following result. The Dates are in the General format.

Result of the converted Excel table

  • Select the cells C2:C8.
  • Choose Short Date from Number formatting which is in the Home tab.

  • The dates are now in Date format.

  • You can format your Excel table, too.

Formatted result of how to Convert XML to Excel Table

Read More: How to Convert Large XML to Excel


Method 2 – Using a Web URL to Convert an XML to an Excel Table

Steps:

  • From the Data tab, go to the Get Data menu.
  • Choose From Other Sources and select From Web.

Employing Web URL to Convert XML to Excel Table

  • A new dialog box named From Web will appear.
  • Choose Basic.
  • Paste your file link to the URL box. We used this XML File link.
  • Press OK.

  • You will see the window named Navigator.
  • Select the url file.
  • Click on Load.

  • You will get the converted Excel table.

Read More: How to Convert XML to Columns In Excel


Method 3 – Using the Import Feature from the Developer Tab in Excel

Steps:

  • From the Developer tab, choose the Import option.

Using Import Feature from Developer Tab in Excel

  • A new window named Import XML will appear.
  • Choose your XML file in the File name box.
  • Click on Import.

  • You may see the following dialog box named Error In XML. If you do, press OK.

  • Another dialog box named Import Data will appear.
  • Input the starting cell in XML table in existing worksheet and select the option.
  • Press OK.

  • You will get the following data table. The Dates are in General format, so we’ll change this formatting to Date.

  • Here’s the final result.

Formatted result of the converted xml file to Excel table


Download the Practice Files


Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Musiha Mahfuza Mukta
Musiha Mahfuza Mukta

Musiha Mahfuza Mukta is a marine engineer who loves exploring Excel and VBA programming. To her, programming is a time-saving tool for dealing with data, files, and the internet. She's skilled in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. With a B.Sc in Naval Architecture & Marine Engineering from BUET, she's shifted gears and now works as a content developer. In this role, she creates techy content exclusively focused on Excel... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo