Are you sure this .xml file is complete? I don't see some of the information which is populating your excel file here.
I'm no xml guru but I can take this and turn it into something readable via xml parse or regex - and (as confirmed by notepad) there's missing data.
I would suggest you're probably better off reading this document in as a series of single field (just a text string) rows, adding a Record ID, then going through a series of Filter & Regex Parse tools to pull the content you're interested in. As an XML file, it is not well structured since the there is a lack of nested nodes to define the parent-child relationships. Rather, it appears that it's simply the order of the nodes that identify what the parent is (hence the Record ID recommendation).