Question: how to open multiple xml files in excel?
Answer: Select a mapped cell to import multiple XML files into a single set of mapped cells. ... 
Click Developer > Import. ... 
In the Import XML dialog box, locate and select the XML data file (. ... 
Click Import.