export filter results to excel file

[Jon]

is there anyway to export the jql filter results to a excel file so it can be added up?

[Andy Heinzer · Accepted solution]

Hi everyone,

For Jira Cloud there are actually a few free apps that could help here. 

• Jira Cloud for Excel (official) - offers a quick way to export Jira issue data into Excel
• Jira Cloud for Google Sheets (Official) - offers the same, but for Google Sheets
• Marketplace also has other solutions on this topic

Meanwhile both Jira Cloud and Jira Server versions today allow users to export search results into CSV format, which can then be imported into just about any spreadsheet application for further data manipulation.

I hope this helps.

Andy

[Lucas Modzelewski _Lumo_]

If you need to modify data and send it back to Jira (2 way communication), then you can use our Excel Connector for Jira: 

You can check getting started section with some short videos with overview of features: Getting started

Cheers,
Łukasz

[Mohamed Benziane]

You can make a search in atlassian marketplace i think one is caller better excel plugin

[Mohamed Benziane]

On server you can export on csv i think its also possible on cloud. But you can't without plugin export to an excel file.

Regards

[Jon]

I see. how do I add this plug in? 

[Levente Szabo _Midori_]

Hi Jon,

Give our app, Better Excel Exporter a try, it does exactly what you requested and even more complex exports and reports in Excel from Jira issues.

However, I saw you used the Jira Cloud tag on this question. Please note that Better Excel is currently for Jira Server only.

[Jon]

are there any like this for cloud? I don't need much just ability to export the list of issues into excel. all I need to do is get some sum totals. 

[Levente Szabo _Midori_]

As Mohamed said, you can make a search on the Atlassian Marketplace, you might find something that fits your needs!

[Mohamed Benziane]

Hi @Jon

Can you just export your result filter in csv and work on it in excel? It is much easier if you just need to make a sum of value from a customfield.

Sorry from my english

[Rich Scire]

I might be missing something but you can export the results of a filter without needing a plug-in by using the built-in export feature. You can select either HTML or CSV, both of which can be opened in Excel.

[Jon]

I use this but for whatever reason when I try to export and select CVS excel current fields it pulls all fields, but the odd thing is this happens only if I have other tabs open on the internet browser. if I do it when I first open up my PC its seems to work as it should but if I do it with other browsers open the export doesn't pull the right fields..

any ideas of why this could happen?