Using Excel to create xml file

Most people use excel to deal with daily routine tasks or storing a hug colossal data. This is an example how to create a xml file by using excel.

Please prepare a xml schema file  that includes titles like this:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <data-set xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">    <record>       <LastName>Smith</LastName>       <Sales>16753</Sales>       <Country>UK</Country>       <Quarter>Qtr 3</Quarter>    </record>    <record>       <LastName>Johnson</LastName>       <Sales>14808</Sales>       <Country>USA</Country>       <Quarter>Qtr 4</Quarter>    </record> </data-set>

Then we open a excel file that contains your data with the proper titles that haven’t been mapped yet.

In order to perform the mapping titles, we will use developer section in excel. Right click anywhere of your menu panel to choose Customize the Ribbon

Enable Developer ribbon

In developer ribbon, click source button, then click XML maps button down below the XML Source window.

Click Add button to import xml schema

Click OK twice
 

Now you are going to see the titles that are showing on the right side.
 

Just simply drag one of the titles to the proper cell that matches the title on the left side.

After finishing the maps, click export button to create a xml file copy

Open the xml file that was created in the previous step by using XML notepad. Now you will see the file is properly formatted.