Is it possible to dynamically export data from JIRA into Excel?

Question

I'd like to set up a data import source in Excel through which I can dynamically pull data from Jira. I know this used to be possible by using an Excel web query and the XML link from the Jira filter I wanted to use. I've been unable to determine if this is still possible. If it isn't, is there another way to achieve this?

Solution

Whilst a little old I thought I note here how I did using JIRA 7.2.2 without the need for a 3rd party plugin

1. Use the Issue Navigator to create a filter/view of the JIRAs you want available to Excel
2. Save the filter
3. Click on Export drop-down
4. Right click on CSV (all fields or current fields) or XML
5. Select Copy Link Address (I am using Chrome other browsers will have a similar function)
6. Open Excel (I'm using 2016 version)
7. Select Data tab > New Query > From Other Sources > From Web
8. Paste in URL
9. Click OK and follow various steps
10. You're done :)

Comments

[Oliver]

I only get a bad request (400) from jira with excel 365

[Razan]

Unfortunately this no longer works in Jira v7.10.1 as they've added a dialog box to select the delimiter.