Xls to Xml conversion and real time use

om

Steps to create .XML from .xls XML data file

Step 1:

Sample xls file with XML tabular data

Step 2:

Click on Office button on top right corner

then save as other formats

Step 3:

Save the file in desired location

Step 4:

click on continue button

Step 5:

converted xml file

Step 6:

Open the xml file with notepad ++

Our desired XML format is obtained.

Scenarios faced in real-time:

• Client sent  xls file in mail attachment.It contains xml data
• To test inbound proxy scenario in sap pi
• I need XML file to test in the sap
• I tried many online tools won't work
• Finally I converted the xls file to XML based on above steps and I Successfully converted xls file to xml and tested in proxy scenario.