How do I export a Jira dataset compiled by another individual to excel based on a filter value?
Hello @Diana Yockey ,
Are you talking about a Jira filter or an Atlassian Analytics dataset? The process is slightly different.
If it's a shared Jira filter you don't need to be the owner in order to export the results. Open the filter, tweak the search criteria as appropriate and then go to Export → Export Excel CSV. You can also save a copy of the filter without altering the original.
You just need access to the filter and permission to view the work items.
https://support.atlassian.com/jira-software-cloud/docs/export-search-results/
Cheers,
Arek🤠🧙♂️
Hi @Arkadiusz Wroblewski !
Please excuse me for specifying Jira 'filter' when I was referring to a filter in an Atlassian dataset as you so wonderfully had mentioned. I am not seeing an 'Export' option:
Hi @Diana Yockey ,
From your screenshot, that’s a regular Jira dashboard, not Atlassian Analytics. Jira dashboards don’t have an export option, which is why you don’t see one. There’s an open suggestion for it you can vote on: JRACLOUD-73429.
The data in each gadget comes from a saved filter, though, so you can export that:
@Diana Yockey
For Jira exporting the filter results, you need to be in the search UI where you can see your filter (either in Basic or JQL mode, then you can click on the "…" to access the "Export" options
Hope this helps.
Best, Joseph
Thank you @Pavel Vasiliev! Or rather I should say Fala Mnogu! ;)
You can conveniently export any work item list tonative Excel spreadsheets (not plain text CSV files) using the Better Excel Exporter app.
It supports a wide range of export types and is accessible through the "Apps" menu:
In Jira Data Center, open the other person’s saved filter, narrow the results to the value you need, and export them as a CSV that you can save as an Excel workbook.
Thank you @Aron Gombas _Midori_ however my Jira does not contain what you have specified and as this is a work provided laptop and the resource downloads which are allowed are limited. I have a Refresh option, Edit, & the 3 dots.
I was able to download the dataset into a spreadsheet so now my inquiry lies in if I am able to set email notifications when a specific column reaches a certain value. I realize that I am able to email myself based on when I am assignee, when I am a reporter, and when I make changes to work items, but where is the Space and work items option in Notifications so that I am better able to manipulate what I am sending myself? As always, any help is always appreciated! :)
Hi Diana, glad the export worked out.
The notification settings can’t do this. They only react to activity on work items (assigned to you, you’re the reporter, you’re watching), not to a field reaching a value. You find them under the gear icon, Personal Jira settings, Notification settings. The menu was renamed, so the “Spaces and work items” label from older guides may not be there anymore.
For what you want, a filter subscription fits better and needs no admin. Save a filter with your condition, for example "Your field" >= 10, open it, select Details next to the filter name, then New subscription, and pick a schedule. Jira then emails you the matching work items.
"Your field" >= 10
Which field and value do you want to watch? Then I can help with the JQL.
Hi @Diana Yockey, I’m Thiago, a support engineer at Appfire. If you are considering third-party apps, there’s a workaround using JXL JXL provides a spreadsheet-style view of Jira work items. You can create a Sheet from an existing Jira Filter that is accessible to you, keep the filter's search query as the Sheet scope, and arrange the columns for your report. JXL can then export the Sheet to XLSX, CSV, or TSV. When exporting, you can choose whether to include only the currently filtered and searched view or all work items included in the Sheet scope. More information is available in the JXL documentation. Regarding email notifications, triggering them via a spreadsheet would require a live connector to sync updates. Instead, you can set these up directly in Jira Automation under Settings (cog icon) > System > Global Automation > Templates by selecting a Rovo agent email template and adding your instructions.
You can find JXL on the Atlassian Marketplace.Please contact our support if you have any other questions about JXL. Best regards, Appfire support team.
If you have access to the Jira data and the filters that another user has created, you can open up that saved filter, add any further criteria that you require and then go Export -> Export Excel CSV (all fields) to download the results.
If you're up to using third-party apps and want more sophisticated filtering and Excel reports, then you might also look at Issue History for Jira (Work Item History) app by SaaSJet.
You can filter work items by project, date range, updater and so on and then export the results to Excel (.xlsx) with the full change history.
Here's a step-by-step guide covering both native Jira exports and the app:
Hope this helps!
It looks like you're new here. Sign in or register to get started.