stsadm xml output and excel

This is kind of obvious but I just hadn’t thought about doing it.

I was playing with the list of sites commands and seeing the output on the command line in xml format. It’s a lot of info on the command screen and difficult to interpret.

So I tried

stsadm -o enumsites -url http://mywebapp.domain.com > sitelist.xml

I then just opened up the xml file with excel2007. (really beginning to like the features in this version)
It warned that there was not an associated schema, would I like to create on from the file, ‘yes Please’!

And now I have great spreadsheet where I can sort, filter, sum, etc.