Exporting or import excel data to/from xml is pretty simple and straight forward after office 2003. You dont have to write any code or macros for the straight forward export. I have found an add-in which was very useful for me when I was doing couple of exports.

The good thing about this add-in is you dont have specify any schema to get the data, simply select the range, and select if the first row is the column heading thats it, you get the xml data within couple of clicks. Well its not just that, it can help you to create XSD files for XML maps, rename the <Root> and <Row> elements, or refresh all of the XML maps in a workbook.

I highly recommend this add-in if you are using any kind of xml import or export using Excel 2003.

Read more about the add-in here

-Rujith