My first thought is to Google "JSON to CSV". Replace JSON with XML/SOAP or whatever format the API data comes in.
Discussion
And if you're handy with a certain language (python for me) then throw that into the search and make a script to do the conversion.