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.

Excel will use it to create a schema. Close any dialog boxes and you should now have something like this: Drag and drop the column names from the ‘XML Source’ pane to the appropriate column ...