Question: how to extract xml data into excel?
Answer: Go to the Data tab in the ribbon. Select Get Data found in the Get & Transform Data section. Choose From File. Choose From XML.