You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
How do I export a custom report to excel or cvs of tasks from the filtered view?
I see the option to export issues to csv, but that is limited to all fields. What I would like to to export a tailored csv, excel, google sheets with select data points.
this comes up every now and then, and it appears as if there was a native solution to this; kindly have a look a this thread: https://community.atlassian.com/t5/Jira-Software-questions/Exporting-only-specific-fields-which-are-needed/qaq-p/1756433
If the suggested solution does not work or is not practical for some reason, there's a number of options available from the Atlassian Marketplace. E.g., my team and I work on an app in which your use case would be trivial to solve: JXL for Jira.
JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also offers a one-click export to XLSX (e.g., Excel or Google Sheets) and CSV that exports exactly the columns that you chose for your JXL sheet, and also is not limited by JXL's export limit of 1000 issues:
I should add that JXL also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), s um-ups, or conditional formatting.
Any questions just let me know,
That forum link you sent me had the answer, but only thing I'm missing is the export currently selected column, but the view in Jira is fine for us for now. If we need better exporting in the future will definitely look at your app as a solution.
For those searching for a solution that come after me.
You need to be in the list view, basic setting then you can use the column button on the far right to choose which columns you see from your custom variables.
Export to a standard XLSX file with the Better Excel Exporter. This fileformat is can be then opened in Excel, Google Sheets and any other spreadsheet tool.
The app supports "All fields", "Visible fields", "Fields with non-empty values" modes and a lot more:
(Disl. it is a paid and supported app developed by our team. Free for 10 users.)
If you like to export to Google Sheets you can try our Google Sheets Integration add-on from the Atlassian Marketplace. It allows you to select which fields and order to export. In addition you can enable real-time or scheduled exports. This is all done from within Jira either starting with a filter or a search.
The Mobility Team