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

this perspective it becomes rather easy to create an XSL 1.0 style sheet to transform the XML document from Listing A into something that my half brother will feel comfortable with.