Question: how to import data using xml in excel?
Answer: Click Developer > Import. ...  In the Import XML dialog box, locate and select the XML data file (. ...  In the Import Data dialog box, do one of the following: ...  If the XML data file doesn't refer to a schema, then Excel infers the schema from the XML data file.