So you have an xml file with data you need extracted and converted into an excel sheet ? the following code should provide an idea of how to extract values from an xml file. This is adapted to the following example xml file, so you will need to tweak yours depending on the structure of your file.
Links you may need :
This is what the XML file looks like: