How To Save XLS (Microsoft Office Excel) File As XML File

Hi! Everyone, hope you all are fine.
Today in this post I will tell you how you can save Microsoft Office Excel document into XML format. My father was doing efiling (submitting income tax details online), so in the process he needed to convert Microsoft Office Excel document (given by the Government) to XML format.

save XLS file to XML
Image credit: Iconfinder

So if you also needed to convert Microsoft Office Excel (xls) to XML for some reasons, here how you can

  1. Open the Microsoft Office Excel document you want to convert
  2. Click on Files –> Save As (excluding Microsoft Office 2007) and go to step 4.
  3. Click on Office Option icon –> Save As –> Other Formats (for Microsoft Office 2007) or press F12
  4. Office Option icon -- Save As -- Other Formats (for Microsoft Office 2007 and 2010)

  5. Now navigate where you want to save your XML file
  6. Give the File name
  7. Now from Save as type drop-down option select XML Data (*.xml)
  8. Click on Save button
  9. Save As option for Microsoft Office Excel

Your XML file read, now you can use as you want. If you have any question or problem let me know.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.