Question: how to export data from excel to xml file?
Answer: Press Ctrl+S to save your file. ... 
Click File > Save As, and select the location where you want to save the file. ... 
In the File name box, type a name for the XML data file.
In the Save as type list, click XML Data, and click Save.