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 :

  1. Excel python module
  2. XML python Module
  3. OS python module
  4. Enumerate

This is what the XML file looks like:

 

Code:

Resulting Excel File looks like this:

xml_to_excel

Hope it helped!