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

It allows you to open XML documents and view or edit their content. You may open an XML file in Excel using two different methods – a) using the File menu and b) using the Data menu.

You can create XML data from a Microsoft Excel 2003 worksheet or workbook, but you'll need to do some manual steps to get the data to conform to valid XML format.