I recently came across a nice little mambot that allows using XSL to format XML in Joomla. I modified it a bit so that it can pull in remote XML. Usage is easy:

{mosxslt my.xml my.xsl}

OR

{mosxslt http://foo.com/my.xml my.xsl}

You can download it here