This wikiHow teaches you how to import an XML file into a Microsoft Excel worksheet using a Windows or Mac computer.
Steps
Method 1 of 2: Windows
Step 1. Launch Microsoft Excel
The Excel program icon is located within the "Microsoft Office" group of the list All apps from the Windows "Start" menu.
Step 2. Access the File menu
It is located in the upper left corner of the Excel window.
If you are using Excel 2007, press the button with the Microsoft Office logo
Step 3. Click Open
The Windows "File Explorer" dialog will be displayed.
Step 4. Double-click the icon of the XML file to be processed
Depending on the format of the file under consideration, you may need to perform additional steps before you can open it in Excel:
- If the "Import XML" dialog box appears, the selected file references one or more style sheets in XSLT format. In this case you can choose the option Open the file without applying a style sheet to use normal Excel formatting or entry Open the file and apply the following stylesheet to format the data according to the selected style sheet.
- If the "Open XML" dialog appears, choose the option Read-only workbook.
Step 5. Access the File menu
Step 6. Choose the Save As… option
Step 7. Select the folder where you want to store the new Excel file
Step 8. Choose the Excel Workbook format from the "Files of type" drop-down menu
Step 9. Press the Save button
At this point the data contained in the original XML file has been stored in the Excel file you created.
Method 2 of 2: macOS
Step 1. Launch Microsoft Excel
The program icon is stored in the "Applications" folder.
The macOS version of Excel cannot import XML data from an external source, but it does allow you to open an XML spreadsheet
Step 2. Access the File menu
It is located at the top of the screen.
Step 3. Click Open
The "Finder" dialog will be displayed.
Step 4. Select the XML file to use
Navigate to the folder where it's stored, then select the file name with a single mouse click.
Step 5. Press the OK button
The content of the XML file will be displayed on the screen.
Step 6. Access the File menu again
Step 7. Choose the Save As option
Step 8. Name the file you want
Step 9. Choose the. CSV format from the "Files of type" drop-down menu
Step 10. Press the Save button
The data present in the chosen XML file will be stored in CSV format in the specified folder of the Mac.