Macros

Import/Convert XML to Excel

What is an XML file?

An XML file is an Extensible Markup Language file. XML is a markup language that is used to store data.

An XML file is a file that stores data in a structured format.

XML files are often used to store data for use with web applications.

XML files can be opened and edited in any text editor, and can be read by any XML parser.

Import or Convert XML File to Excel

XML files are not typically thought of as something that can be easily converted into Excel files.

However, with the right tools, it is possible to convert XML to Excel.

This can be a useful way to take data from an XML file and put it into a format that can be more easily analyzed.

There are a few different ways to convert XML to Excel, and the best method will depend on the specific file that you are working with.

Using the famous Power Query (For Excel recent version)

First thing you need the XML File saved on your computer (here I’m using the Sitemap Post of the Macrosinexcel website post-sitemap.xml) then:

  1. Open Excel , go to Data tab
  2. Click on “New Query” (also called “Get Data”)
  3. From the dropdown choose From File -> From Xml
  4. Select the XML file you want to convert to Excel
  5. A new window appear the Navigator listing all data found in the XML file
  6. Select the data that you want to import
  7. and click the “Load” button

That’s it  a new worksheet in the Excel file will be created, and load all the data from the XML file into the new worksheet.

If you want to bring data directly from an online XML File (with url) , change the 3th step

3.From the dropdown choose From Other Sources-> From Web

and do the same steps

Using an XML Converter

If you have a wellstructured XML file, you can use a tool like the XML Converter to convert it to an Excel file.

This tool will take your XML file and convert it into a format that can be opened in Excel.

If you have a more complex XML file, you may need to use a more powerful tool like the XML Converter Pro.

This tool can handle more complex XML files and will convert them into a format that can be opened in Excel.

Leave a Comment