How to Add an XML Map to an Excel Spreadsheet

1. Launch Microsoft Excel and open the spreadsheet to which you want to add the XML map.
2. In Excel 2003, click the 'Data' tab and put the cursor over 'XML.' On the drop-down, select 'XML Source.' In Excel 2007, click 'Data,' then click 'From Other Sources' in the drop-down, then click 'From XML Data Import.'
3. Click on the 'XML Maps' button and then click 'Add.'
4. Locate the XML schema you want to map to the spreadsheet and then click 'Open.'
5. Click 'OK' to map the XML schema to the spreadsheet.