How do i save the xml response having 'n' nodes into excel.

I am working with REST services.As part of my xml response i get the information of different products and their status. I want to know how to save the entire response in to an excel sheet. I tried the 'Data Sink' but it only saves the first record in my response. How do i save all the records from xml response to Excel is the question. Any help is highly appreciated.