I am trying to use the RSS Viewer web part on a team site and it accepts Feed URLs that end in .rss but when I insert one that ends in .xml, it doesn't load the content. Has anyone else experienced this issue? Is there a workaround?
You need to use XML Viewer Web Part for this case(It can also display live rss feeds).
You can find it in the same place where you found the RSS feed web part.
It will give you the results which you need.
Kindly let me know if you need more info.