If you wish to view data from an XML feed in a nicely formatted Excel spreadsheet, follow these steps.
1. Identify the data you wish to see in the feed by specifying the variables necessary in the URL. You can learn more about the available options in the Using the XML Reporting Service (XRS) article.
The URL to your XML feed should look something like this example:
2. When you enter the URL into a browser and receive results, right click on the results and save it as an XML file like ‘filename.xml’.
3. Next, open up a new Excel instance. From within Excel, select Open and select the file you just saved as an XML file.
4. Open the XML file. It should prompt you to open as an XML table.
And it will be nicely formatted.