Drag and drop .XML files to Excel 2007
July 7, 2009 in Uncategorized
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 (http://office.microsoft.com/en-us/excel/HP102064051033.aspx)
.

Recent Comments