Convert XML into EXECL

XML conversion to execl I want to convert the XML file generated by PHP to execl table representation & nbsp; for example, my xml is XMLcode & lt; subject & gt; BasicInformation & lt; question & gt; Whatisyourage? & Lt; answer & gt; 8-12 & lt; answer & gt; & lt; convert XML to EXECL
I want to convert the XML file generated in PHP to execl table representation.
For example, my xml is

XML code

   
  
     Basic Information  
   
      What is your age?   8-12   
    
     2
       
    
     0.01%
       13-19   
    
     43
       
    
     0.31%
       20-34   
    
     65
       
    
     0.47%
       35-49   
    
     24
       
    
     0.18%
       50+   
    
     3
       
    
     0.02%
       
   
   
      What is your gender?   Male   
    
     119
       
    
     0.87%
       Female   
    
     18
       
    
     0.13%
       
   
  

When this sub-statement is represented in EXECL
Only the last layer of data is displayed, that is, answer count and ratio. the content of question is not displayed, and the answer count ratio data is not in the corresponding row.
How can I display XML data properly under the guidance of a person?

------ Solution --------------------
Your code?
------ Solution --------------------
EXECL has its own format. you can only convert it to execl format to open it.
------ Solution --------------------
Phpwind splits the xmlfield, and then the output x.csv can be opened in excel.