Importing RSS Feed To Excel

[TesterMatt]

Hi all,

I'm working on a dashboard for my company's testing efforts (we use excel sheets to track test cases), and I'd like to incorporate bug data from Mantis. We're currently using version 1.1.8, and what I'd like to do is use the data from the RSS feed to get the number of bugs that are open (ie. every status except Closed). In an ideal world, I'd like to be able to break that number down what the status is, but at the minimum, I'd like the total open cases, and for it to automatically feed from Mantis, as my test case numbers already do that.

Any assistance would be greatly appreciated!