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?

5 answers

1 accepted

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

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

jira-automatic-excel.png

 

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?

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

The add-in you’ve been waiting for: Jira Cloud for Excel 🙌

Introducing Jira Cloud for Excel Here at the product integrations team at Atlassian, we are thrilled to announce the new Jira Cloud for Excel add-in! This add-in lets you export Jira data directly ...

864 views 6 24
Read article

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