How to Convert XML to Excel

Windows

1. How to Convert XML to Excel Picture 1
   Open Microsoft Excel. You'll find Excel in the 'Microsoft Office' group in the All Apps area of the Windows menu.
2. How to Convert XML to Excel Picture 2
   Click File. It's at the top-left corner of Excel.

   1. If you're using Excel 2007, click the round button with the Microsoft Office logo inside instead.^[1]
3. How to Convert XML to Excel Picture 3
   Click Open. This opens the file browser.
4. How to Convert XML to Excel Picture 4
   Double-click the XML file. Depending on the format of the file, you may have to take additional steps to open this file:

   1. If you see a dialog box called Import XML, the file references at least one XSLT style sheet. Select Open the file without applying a style sheet to select the standard format, or Open the file with the style sheet applied to format the data in accordance with the style sheet.
   2. If you see the Open XML dialog, select As a read-only workbook.
5. How to Convert XML to Excel Picture 5
   Click the File menu.
6. How to Convert XML to Excel Picture 6
   Click Save As….
7. How to Convert XML to Excel Picture 7
   Navigate to the folder where you'd like to save the file.
8. How to Convert XML to Excel Picture 8
   Select Excel Workbook from the 'Save as type' drop-down.
9. How to Convert XML to Excel Picture 9
   Click Save. The XML data is now saved as an Excel file.