How to convert an XML file to a CSV or Excel spreadsheet

About

This guide explains how to convert an API call output given in XML  into a CSV or Excel spreadsheet, making it easier to view and work with your data in a structured format.

Get started

1. Open the XML file and select all the text by clicking Ctrl + A. 
2. Copy your selected text by clicking Ctrl + C.

   

3. Open Notepad ++ and paste the copied text.
4. Delete the first two lines in the document:

SourceOptions

XPath/RenderXSL



1. From the top menu, open the Language sub-menu and select XML.

   

2. After you choose the correct language, click File, then Save As.



3. Choose where to save the file and click Save.
4. OpenExceland clickFilein the ribbon bar.



5. ChooseOpen, thenBrowseto locate the file saved in the previous step.



6. Select the file and clickOpen.



A pop-up box displays.

7. Choose As an XML table and click OK.



8. Another pop-up displays to alert you that this source has no schema. Ignore this error and click OK.



Your XML data will now appear in Excel, fully converted into a structured spreadsheet 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.