Export the XML

Now that the Range has been converted to XML, you can export the data as an XML file.

 

6. Try it: Export the XML

Go to Developer ->XML.

Click on Export.

 

Location: In this example the XML file will be saved to the Documents folder.

 

File Name: tblProducts

Save as type: XML Files

 

Click Export.

 

Done and done...sooooo.....

Developer ->XML-> Export

Exam 77-888: Microsoft Excel Expert 2010

1. Sharing and Maintaining Workbooks

1.1. Apply workbook settings, properties, and data options: Export data as XML