Buzz
Mytour will guide you on how to import an XML file into a Microsoft Excel spreadsheet on both Windows and macOS today.
Steps
Windows
Launch Microsoft Excel. You'll find Excel in the 'Microsoft Office' group within the All Apps section of the Windows Start menu.
Click on the File option in the top-left corner of Excel.
- If you're using Excel 2007, click the round button with the Microsoft Office icon inside.
Click on the Open option. The file explorer will open up.
Double-click on the XML file. Depending on the file format, you may need to follow additional steps to open it:
- If you see an Import XML dialog box, ensure that the file reference includes at least one XSLT style sheet. Select Open the file without applying a style sheet for the standard format, or Open the file with the style sheet applied to format the data according to the style sheet.
- If you encounter the Open XML dialog box, choose As a read-only workbook.
Click on the File menu.
Click on the Save As… option.
Navigate to the folder where you want to save the file.
Select Excel Workbook from the 'Save as type' dropdown menu.
Click on Save (Save). Your XML data will be saved as an Excel file.
macOS
Open Microsoft Excel. The application is located in the Applications folder.
- Excel for macOS cannot import XML data from other sources, but the application allows you to open XML spreadsheet files.
Click the File menu at the top of the screen.
Click on Open (Open). The Finder window will open.
Select the XML file. Navigate to the directory containing the XML file and click the file name to select it.
Click OK. The contents of the XML file will be displayed.
Click on the File menu.
Click on the Save As.
Provide a name for your file.
Select .CSV from the “file type” dropdown menu.
Click on the Save. The XML file has been successfully saved with the .CSV extension on a Mac.
