Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

Drag and drop .XML files to Excel 2007

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 …

  1. Easier to read
  2. Simple to filter and sort
  3. 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?

 

image

image

 

image

Import XML data (Excel – Import XML as Table)

 

.

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲