Highlight the data file and then click "Import" to map the data directly to the spreadsheet under the table information, recreating the XML table within your Excel spreadsheet.

Excel pro tips: Importing and parsing data When data dumps into your spreadsheet and it's a big mess, you'll know what to do.

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.