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.