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