It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to create Schedule automated Reports in Jira?

I would like to create an automated report for all JIRAs raised in a project.

It will run monthly (the first of each month) and send an Excel spreadsheet by email.

Is this possible?

6 answers

1 accepted

This does not send reports in email. This sends a single website link.

Like # people like this

I use Jira v8.4.2 and I get the content of the filter (e.g. the list of issues with assignee, etc.) in addition to the link. Not sure if it was customized somehow but it does the job for me.

Is there a way to make Jira send you the CSV/excel version of the query (rather than a link to the online query)?

With Excel Automation for JIRA you can generate Excel spreadsheets periodically or at issue events (when an issue created, updated, transitioned, etc.). The spreadsheets are generated from Excel templates that are regular Excel files themselves, and allow using:

  • Excel functions
  • Excel formulas
  • Excel pivot tables
  • Pivot charts

See the Excel tutorial



Bhushan, it worked for me. thankyou!!

Please accept the answer if it worked. Thank you.

Hi Bhanu,

If you need more complex reports including logged time, linked issues and more you should check out our plugin Intelligent Reports. You can design your report template in Microsoft Word, fill it in with simple point and click rules including multiple JQL queries, charts and more, and then schedule it to be sent to you by email.

Does it work for cloud version of JIRA?

Both Intelligent Reports and Excel Automation for JIRA appear to be for server clients only. If anyone knows of an integration that does this for cloud, please let us know!

Like # people like this
0 votes

Why cant I see any answers here?

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you