An XML map allows a business to arrange data stored in XML documents so that the information can be easily imported into a predefined table in an application such as Microsoft Excel. In this way ...

Click on the "Data" menu in Excel and choose "XML," then "XML Source" to open the "XML Source" task pane. Click on the "XML Maps" button, then click "Add" and choose the XML map file you created ...