Exporting Jira Reports

[Gabriel]

Hi,

I need assistance in exporting  Jira reports from Jira into an excel sheet.

To provide more detail, I would like to see how many tickets were closed within the past week and wanted to see if I can extract that data from Jira and insert it into an excel sheet

[John Funk · Accepted solution]

Hi Gabriel - Welcome to the Atlassian Community!

You can create a filter and the export the results.

Click in the Search box in the top nav bar on the upper right.

Choose view all issues.

Enter your query and click the search icon to see the results.

The add and take away whatever columns you like.

Go ahead and Save the filter.

Finally, click on the export button and choose CSV with default fields.

[Aron Gombas _Midori_]

@Gabriel In the Issue Navigator:

1. Execute this JQL search to collect the issues resolved over the last calendar week (not the last seven days): 

   statusCategory = Done AND resolutiondate >= startOfWeek("-7d") AND resolutiondate < startOfWeek()

2. Select the columns you wanted to export.
3. Export to CSV (if this plain text format is good enough for you) or to Excel (if you need more precise output).

(Discl. the app suggested above is a paid and supported app developed by our team. Free for 10 users!)

[Bernhard Doleschel (Ease Solutions)]

Hello @Gabriel ,

as a vendor of easeOffice for Jira Data Center (sorry, Cloud is in development) I would like to suggest you our Excel Plugin. It is directly installed in your local MS Office Excel (on Windows), with it you can

• download any Jira issue by project, by Jira filter and by JQL (Jira query language)
• define which fields you are interested in, Jira custom fields also supported
• Modify content in Excel
• Check current download against latest changes in Jira
• Upload changes to Jira

Best Regards,

Bernhard

[Mary from Planyway]

Hi @Gabriel ,

To export Jira reports into an Excel sheet, particularly to see how many tickets were closed within the past week, you can follow these steps:

Exporting Jira Reports to Excel

1. Search for Issues in Jira:

   • Go to Jira and use the Issue Navigator to search for the issues.
   • Apply the necessary filters to get the tickets that were closed in the past week. You can use JQL (Jira Query Language) for this. For example:
     scss

     status = Closed AND resolutiondate >= startOfDay(-7d)

2. Customize Columns:

   • Ensure that the columns you want to include in your report are visible in the Issue Navigator. You can customize the columns by clicking on the "Columns" button and selecting the fields you need.

3. Export to Excel:

   • Once you have your filtered issues and customized columns, you can export the data to an Excel sheet.
   • Click on the "Export" button on the top right of the Issue Navigator.
   • Select "Export Excel CSV (current fields)" or "Export Excel CSV (all fields)" based on your requirements.

Using Planyway for Enhanced Reporting and Export

While Jira's built-in functionality allows you to export data, using Planyway can significantly enhance your reporting capabilities. Planyway is a powerful tool that integrates with Jira and provides a more visual and flexible way to manage and report on your tasks.

Benefits of Using Planyway:

1. Visual Timeline and Calendar Views:

   • Planyway offers a visual timeline and calendar views, making it easier to manage and understand your team's workload and progress at a glance.

2. Customizable Reports:

   • You can create custom reports that fit your specific needs, making it easier to track key metrics such as ticket closures over time.

3. Easy Export to Excel:

   • Planyway allows you to easily export your views and reports to Excel, ensuring that you can quickly share insights with your team or stakeholders.

4. Integration with Jira:

   • Planyway integrates seamlessly with Jira, ensuring that your data is always up-to-date and that you can leverage all the capabilities of both tools.

[Josh_Unito]

@Gabriel its relatively easy to export any data you want as a CSV from Jira. You could use a Jira dashboard or your backlog for starters.

For a one-off task, I’d probably just save a filter with a condition to only view tasks completed within a specific date range. You may need to add a custom field for that. 

Then just apply the filter and export all as a CSV and pop it into Excel or Google Sheets.

Beyond that, there are tons of apps and add-ons that automate that process for you. I can recommend some if you want, or if you just need to export a few times then you should be good with the steps I mentioned above.

Good luck!