How to Convert Excel to XML Format



To convert excel to xml format you need to open the spreadsheet you want to convert.
open the spreadsheet

Select file from the top menu. Then select save as.
select the file > save as option

Name the file. Select the save location.
name your file and select save location

In the format type drop down select XML 2004 spreadsheet (xml). Then click on save. This will save your spreadsheet as an xml file.
click drop down and select XML 2004