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. Open Microsoft Excel. You'll find Excel in the 'Microsoft Office' group in the All Apps area of the Windows menu.
Method 1 of 2:
Windows
-
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. -
How to Convert XML to Excel Picture 2
Click File. 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]
-
How to Convert XML to Excel Picture 3
Click Open. This opens the file browser. -
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:- 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.
-
How to Convert XML to Excel Picture 5
Click the File menu. -
How to Convert XML to Excel Picture 6
Click Save As…. -
How to Convert XML to Excel Picture 7
Navigate to the folder where you'd like to save the file. -
How to Convert XML to Excel Picture 8
Select Excel Workbook from the 'Save as type' drop-down. -
How to Convert XML to Excel Picture 9
Click Save. The XML data is now saved as an Excel file.
Method 2 of 2:
macOS
-
How to Convert XML to Excel Picture 10
Open Microsoft Excel. 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]
-
How to Convert XML to Excel Picture 11
Click the File menu. It's at the top of the screen.[3] -
How to Convert XML to Excel Picture 12
Click Open. This opens a Finder window. -
How to Convert XML to Excel Picture 13
Select the XML file. To do this, browse to the folder where it's contained, then click the file name once. -
How to Convert XML to Excel Picture 14
Click OK. The contents of the XML file will appear. -
How to Convert XML to Excel Picture 15
Click the File menu. -
How to Convert XML to Excel Picture 16
Click Save As. -
How to Convert XML to Excel Picture 17
Type a name for the file. -
How to Convert XML to Excel Picture 18
Select .CSV from the 'file type' drop-down menu. -
How to Convert XML to Excel Picture 19
Click Save. The XML file is now saved as a .CSV on your Mac.
4 ★ | 1 Vote
You should read it
- Open the file, open the folder with a mouse click
- How to Open an ODS File on PC or Mac
- How to Open a File in Windows
- How to Zip a PowerPoint File
- How to Open an Img File on PC or Mac
- Open a slide file in PowerPoint
- How to Open a PES File on PC or Mac
- How to Open an Sql File
- How to Open Obj Files on PC or Mac
- How to Edit a Dat File
- How to Open an RVT File on PC or Mac
- How to Convert a Doc File to a Docx File