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.