In this article, we will show you how to convert an XML file to an Excel file on a computer.
Steps
Method 1 of 2: Windows
Step 1. Start Excel
Open the Start menu and click All Apps> Microsoft Office> Excel.
Step 2. Click File
You will find this option in the upper left corner.
In Excel 2007, click the round button with the Microsoft Office logo
Step 3. Click Open
The Explorer window will open.
Step 4. Double click on the XML file
Depending on the file format, you may have to take additional steps to open the file:
- If the Import XML window appears, the file references at least one XSLT stylesheet. Click "Open File Without Style Sheet" to select a standard format, or click "Open File With Style Sheet" to format the data according to the style sheet.
- If the Open XML window appears, click As Read Only Book.
Step 5. Open the File menu
Step 6. Click Save As
Step 7. Navigate to the folder where you are going to save the file
Step 8. Choose Excel Workbook from the Save as type menu
Step 9. Click Save
The XML file will be converted to an Excel file.
Method 2 of 2: macOS
Step 1. Start Excel
It is located in the Applications folder.
Excel for macOS does not allow you to import XML data from another file, but you can open an XML file there
Step 2. Open the File menu
You will find it at the top of the screen. Step 3. Click Open.
A Finder window will open. Step 4. Select the XML file.
To do this, go to the folder with this file and then click on it. Step 5. Click OK.
The XML file will open in Excel. Step 6. Open the File menu.
7 Press Save as.
8 Enter a name for the file. 9 Select . CSV in the File Type menu. 10 Press Save.
The XML file will be saved in CSV format.