Using XML in Excel
 

Microsoft Excel makes it easy to import Extensible Markup Language (XML) data that is created from other databases and applications, to map XML elements from an XML schema to worksheet cells, and to export revised XML data for interaction with other databases and applications.

https://support.office.com/en-us/art...c-c9e9752a7d80

http://www.liquid-technologies.com/xml.aspx