How to map excel data in to XML file

First go and click on office button --> then click on “Excel options” button at the bottom --> then put the tick on show developer tab in the ribbon.


Then click on the developer tab --> and click source --> then side window will open

Create xml file like this
As an ex -:



Aa
SSEngineer


Aa
SS Engineer



Then click on XML maps button in that side bar and brows the created xml file.



Then click on data and drag and drop on to the ‘name’ in data sheet.


Then you can export the data using developer tab.

After exporting file will be like this




aaa
11


bbb
22


ccc
33



--thusitha--