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.