Use Excel to combine multiple data sources in XML documents by creating a map in a spreadsheet that contains the predefined table information. Once the map is in place, the data can be imported ...

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.