How to Convert XML Files Into an Excel Spreadsheet

XML (Extensible Markup Language) is a data format used by many different types of programs to disseminate information between users of the software and to transfer information to other software. The data is organized by a series of tags. The tags tell what category the data lies in and can be nested (one tag within another). HTML, the format used for displaying webpages, is a derivative of the XML format. Manipulating raw XML files can be done, though it is generally easier to view the data in a table layout, such as in Excel.

Businesswoman typing on computer
credit: BananaStock/BananaStock/Getty Images

Step

Open Excel.

Step

Click the Microsoft Office symbol in the upper left-hand corner. Select "Open" from the menu.

Step

Find the XML document you want to convert and click "Open." If the document does not seem to be present where it should be, you may need to select "XML Files(*.xml)" from the "Files of type:" drop-down box.

Step

A small dialog box will open titled "Open XML." In this box select the radio button titled "As an XML table," then click "OK."

Step

If another dialog pops up that has a message relating to creating a "XML schema," simply click "OK." The XML file should be opened as a spreadsheet.

Step

To complete the conversion, save the spreadsheet as an Excel file by clicking the "Office" button, then "Save."