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.
Things You'll Need
- Microsoft Excel
Click the Microsoft Office symbol in the upper left-hand corner. Select "Open" from the menu.
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.
A small dialog box will open titled "Open XML." In this box select the radio button titled "As an XML table," then click "OK."
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.
To complete the conversion, save the spreadsheet as an Excel file by clicking the "Office" button, then "Save."
Tips & Warnings
- This procedure is for Excel 2007. In previous versions of Excel, you may have to "Import" the XML file to read it as a spreadsheet. Some XML files will not import correctly into the Excel. This is due to a problem in the particular XML file's layout. Most database-derived files, though, will import into Excel without any problems.