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 organised 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 web pages, 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.
- Skill level:
- Moderately Easy
Things you 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 dialogue box will open titled "Open XML." In this box select the radio button titled "As an XML table," then click "OK."
If another dialogue 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 and 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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for