Question: how to import an xml file into excel on a mac?
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.