Question: how to extract data from 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.