(viewing XML Contents as excel file, )
Suppose if you have sample xml file, which you want to view in EXCEL instead of XML format.
Step1: simply drag the file from desktop to your required cell in excel sheet.(choose 1st radio button option)
Step2: if you want to see the structure of xml file, choose (Developer, source option as shown in the image)
Step3: suppose, if you want to see the heading part( full xpath of the element, at the time dragging it will ask you 3 radio buttons, choose 2nd option);
Step 4: if you need only structure as shown in below image(right side), use 3rd option to view only structure.