Convert an XML file into an Excel spreadsheet with this technique
Source: Edmond Woychowsky
Developers often deal with information that is in no way user-friendly without really thinking about how a user would handle it. XML is a prime example --- most users don't know what to make of it. One way to present XML information to a user is by converting it to a file format the user actually knows. Edmond Woychowsky walks you through his process to convert an XML file to an Excel spreadsheet. The download includes all of the sample code and an explanation of how it works.
This download is also available as a TechRepublic article.