Working with SharePoint daily I see a great deal of XML data. System configuration, user data, feature definition, list schema, usage, etc. SharePoint is a product that lives and breathes in XML format for nearly everything.
I personally find Excel 2007 very handy here.
If you didn’t know it is possible to drag a plain XML file onto a blank workbook and follow the Excel 2007 defaults to view in a grid layout (sample below). From there it’s …
- Easier to read
- Simple to filter and sort
- Possible to create PivotTables or Charts to identify patterns
Try it out! Please leave a comment of any XML tricks you find helpful. Anybody work a lot with XML in SQL 2005 or InfoPath forms?



Import XML data (Excel – Import XML as Table)
.