Question: how to export xml data into excel?
Answer: Click Developer > Export. ... 
If a small Export XML dialog box appears, click the XML Map you want to use, and click OK. ... 
In the large Export XML dialog box, in the File name box, type a name for the XML data file.
Click Export.