Create XML using EXCEL

Many a time I have got question about how to create XML with excel, So I decided to add this into my blog. Hope this will help the readers.

step 1:
Create one schema file (A template that we will use to generate the xml).
Eg. (Save following lines in dataSchema.xml file)

Step 2:
Open your excel file containing the data.

CountryID	CountryName
1	India
2	Pak
3	Srilanka
4	China
5	Koria

Step 3:

Go to the Developer TAB, if it is not on the top then you need to enable it from (File > Option )

Step 4:

Click "Source" under XML.

It will open XML source panel, having two buttons at the bottom. Click "XML Maps...".

Step 5:

Click "Add" to the XML Maps window.

Step 6:

Select "dataSchema.xml" file that we created in Step 1

Click OK twice

Step 7:

In XML Source you can now see the TREE VIEW of your columns.

Step 8:

Drag and Drop each column to the first row of your data.

Step 9.

Click "Export" button in Developers > XML tab.

Step 10:

You can now save this file as XML and that's it. Done.