How to Convert XML to Excel


This wikiHow teaches you how to import an XML file into a Microsoft Excel workbook using Windows or macOS.

Part 1
Windows

Windows on How to Convert XML to Excel

1
You’ll find Excel in the “Microsoft Office” group in the All Apps area of the Windows menu.

Windows on How to Convert XML to Excel

2
It’s at the top-left corner of Excel. If you’re using Excel 2007, click the round button with the Microsoft Office logo inside instead.[1]

Windows on How to Convert XML to Excel

3
This opens the file browser.

Windows on How to Convert XML to Excel

4
Depending on the format of the file, you may have to take additional steps to open this file: 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. If you see the Open XML dialog, select As a read-only workbook.

Windows on How to Convert XML to Excel

5

Windows on How to Convert XML to Excel

6

Windows on How to Convert XML to Excel

7

Windows on How to Convert XML to Excel

8

Windows on How to Convert XML to Excel

9
The XML data is now saved as an Excel file.

Part 2
macOS

macOS on How to Convert XML to Excel

1
You’ll find it in the Applications folder. Excel for macOS cannot import XML data from another source, but it will allow you to open XML spreadsheet files.[2]

macOS on How to Convert XML to Excel

2
It’s at the top of the screen.[3]

macOS on How to Convert XML to Excel

3
This opens a Finder window.

macOS on How to Convert XML to Excel

4
To do this, browse to the folder where it’s contained, then click the file name once.

macOS on How to Convert XML to Excel

5
The contents of the XML file will appear.

macOS on How to Convert XML to Excel

6

macOS on How to Convert XML to Excel

7

macOS on How to Convert XML to Excel

8

macOS on How to Convert XML to Excel

9
CSV from the “file type” drop-down menu.

macOS on How to Convert XML to Excel

10
The XML file is now saved as a .CSV on your Mac.