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 ...

You'll need to create a data map, define the XML tags and then map them to the columns in the worksheet before you can export the XML file. Launch Microsoft Excel 2003.

Importing from KML is as easy as renaming the file from .kml to .xml and then using Excel’s built in import features. We used Excel 2013, ... Next, click the ‘XML Maps’ button.