Is it possible to dynamically export data from JIRA into Excel?
excel, export, import, jira
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
- Use the Issue Navigator to create a filter/view of the JIRAs you want available to Excel
- Save the filter
- Click on Export drop-down
- Right click on CSV (all fields or current fields) or XML
- Select Copy Link Address (I am using Chrome other browsers will have a similar function)
- Open Excel (I'm using 2016 version)
- Select Data tab > New Query > From Other Sources > From Web
- Paste in URL
- Click OK and follow various steps
- You're done :)
Problem
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?