This tool is useful
 |
| XML Notepad 2007 |
The other tool I use all the time for both XML and SQL is Notepad ++ which has an XML tool plugin and is available here Notepad ++ .
 |
| Notepad++ |
The XML plugin for Notepad has a number of tools including 'Pretty Print' which will format a single line XML document into a readable multi-line document, and a 'Current XML Path' which copies the current XPath to the clipboard, and an 'Evaluate XPath expression' too, which gives you a list of values found from the XPath you enter.
There is also an 'XSL transformation' tool which will convert the loaded document using a specified XML stylesheet.
