How to convert an XML Document to CSV File or Excel Spreadsheet

  1. Open the XML file and select all the text by clicking Ctrl + A then copy it by clicking Ctrl+C.



  2. Open Notepad ++ and paste the text from the previous step.
    **You will need to the delete the first two lines in the document:
    "SourceOptions
    XPath/RenderXSL"



  3. From the top menu, open the Language sub-menu, then select XML.

     

     
  4. After you choose the correct language, click File, then Save As. Choose where to save the file and click Save.

     

  5.  Open Excel and click on File from the ribbon bar.



  6.  Choose Open and Browse.

     

  7. Locate the file you saved in the previous steps and choose Open.



  8. A now pop box is displayed. Choose As an XML table and click OK.



  9. Another pop up is displayed, to alert you that this source has no schema. Ignore this error and click OK.



  10.  You should now see the Excel sheet populated with all the correct fields.

     
In This Article
Was this article helpful?
Thank you for your feedback!