Question: how to import xml to excel sheet?
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.