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.