Question: how to import data from xml file to excel?
Answer: In the XML Map, select one of the mapped cells.
Click Developer > Import. If you don't see the Developer tab, see Show the Developer tab.
In the Import XML dialog box, locate and select the XML data file (. xml) you want to import, and click Import.