Processing XML file is way easier than CSV or other format of file, so it is good to know how to export the data to XML format from the Excel file.
1. Create a xml map file which acutally is a simply xml file containing at least 2 sets of the data. See the example below:
<?xml version="1.0" encoding="ISO-8859-1" ?>
<data>
<users>
<id>id</id>
<fullname>full name</fullname>
</users>
<users>
<id>id</id>
<fullname>full name</fullname>
</users>
</data>
2. From Excel, click Data->XML->XML Source... to open the XML Source window on the right side of work sheet.
3. Click XML Maps button and Add button to add the XML map file.
4. Pick up the column and double-click the proper XML filed name to link each other.
5. Repeat step 4 to link all the columns you want to export.
6. Once it's done, click Data-XML->Export... to export the data into XML format file.