How to Add an XML Map to an Excel Spreadsheet. 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 ...

Ensure that you save the map file with a ".xml" extension. Click on the "Data" menu in Excel and choose "XML," then "XML Source" to open the "XML Source" task pane.