How to Open XML in Excel 2007

1. Enable the 'Developer' tab in MS Excel 2007. Click on the Windows icon on the top left hand side of the screen and click on the 'Excel Options' button. Click on the 'Popular' category to bring up popular Excel 2007 choices. Then click on the box next to 'Show Developer Tab in Ribbon.' Click on 'OK' once this box is checked.
2. Click on the 'Developer' tab on the top of the screen to show the Developer commands. Click on the 'Import' button in the 'XML' box.
3. Browse through your files until you find the file you want. Click on the file to select it and then click 'Open.'
4. Select the import option you want in the dialog box that opens. 'XML Table in Existing Worksheet' will open the table beginning in the cell location you are currently in. 'XML Table in New Worksheet' will open up a new Excel file and import the file starting in field A1. Click 'Import' once you have selected the correct option to begin the import process.