This article will teach you how to import an XML file into a Microsoft Excel workbook using a Windows or Mac computer.
Method 1 of 2: Windows
Step 1. Open Microsoft Excel You can find it in the "Microsoft Office" group in the All apps area in the "Windows" menu
Step 2. Click File in the upper left corner of the window
In Excel 2007, click the round button with the Office logo
Step 3. Click Open… to open "File Explorer"
Step 4. Double click on the XML file
Depending on the file format, some additional steps may be required.
- If you see the "Import XML" dialog, the file references at least one XSLT stylesheet. click in Open the file without applying a stylesheet to select the default format, or in Open the file with the following stylesheet applied to format the data according to the style sheet.
- If you see the "Open XML" dialog, select As a read-only workbook.
Step 5. Click on the File menu item
Step 6. Click Save As…
Step 7. Navigate between the folders where you want to save the file
Step 8. Select Excel Workbook from the "Save as type" drop-down menu
Step 9. Click Save
Then the XML data will be saved to the Excel file.
Method 2 of 2: Mac OS
Step 1. Open Microsoft Excel You can find it in the "Applications" folder
Excel for macOS does not import XML data from another source, but it does allow opening XML spreadsheets
Step 2. Click on the File menu located at the top of the screen
Step 3. Click Open
Then the "Finder" window will open.
Step 4. Select the XML file
To do this, navigate to the folder where the file is saved and click on it.
Step 5. Click OK
Now you will see the contents of the XML file.
Step 6. Click on the File menu
Step 7. Click Save As
Step 8. Enter a name for the file
Step 9. Select CSV from the "File Type" drop-down menu
Step 10. Click Save
Then the XML file will be saved as CSV on Mac.