How to Convert XML to an Excel 2003 Spreadsheet

Converting the XML File Directly Using Excel 2003
1. Click on the Microsoft Excel 2003 icon on your computer's desktop to open the application. Or click 'Start,' 'All Programs,' 'Microsoft Excel 2003,' if you are using Windows. On a Mac, click on the Excel icon in the Applications folder of your Mac's hard drive.
2. Click 'File,' then 'Open.'
3. Click on the down arrow next to the box labeled 'Files of Type.' Select 'XML files (*.xml).'
4. Click on the down arrow next to the box labeled 'Look In.' Navigate to the directory containing the XML file you would like to convert to a spreadsheet.
5. Double-click on the XML file's name to open it. The 'Open XML' dialog box will open.
6. Click on 'As an XML list' to open the XML file to view the raw data in a structured list format. Click 'OK.' This option lets you edit the XML data.
7. Click on 'As a read-only workbook' to open the XML file to view the data in an uneditable file. Click 'OK.' The XML data will be displayed in a grid instead of a list.
Converting XML File Via The Excel 'Data' Menu
8. Open Microsoft Excel 2003.
9. Click 'Data' and select 'XML.'
10. Click on 'XML Source.' The 'XML Source' task pane will open.
11. Click on 'XML Maps.' Click on 'Add.' Use the 'Look in list' function to navigate to the XML file you want to open.
12. Double-click on the XML file to open it. Click 'OK' to close the open dialog box confirming that you want to open the XML file.
13. Click 'OK' to display the XML file in the XML Source task pane.
14. Click and drag the items you want to view from the Source task pane to the blank cells of the open Excel 2003 worksheet.
15. Click on the 'A1' cell of the spreadsheet to highlight it.
16. Click on 'Data,' 'XML,' 'Import.' The 'Import XML' dialog box will open.
17. Click on 'Look in list' to locate the XML file you used in Step 5.
18. Click on the file's name. Click 'Import.' The XML file will open in Excel 2003.