How to Convert XML Files Into an Excel Spreadsheet

Written by contributing writer
  • Share
  • Tweet
  • Share
  • Email

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

Show MoreHide


  1. 1

    Open Excel.

  2. 2

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

  3. 3

    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.

  4. 4

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

  5. 5

    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.

  6. 6

    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.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.