How to convert an XML file to CSV or Excel Spreadsheet

Follow the steps below to convert an API call output given in XML format to a CSV 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 new pop-up 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.
     

Was this article helpful?

Thank you for your feedback!

Name

Email

Submit your feedback

Thank you! Your comment has been submitted.