Can Jira automatically update an excel file

Question

I was wondering if there’s a way to have Jira or an add-on automatically update an excel file with data that  pulls from fields in Jira?

we have an excel file that has a general format that is the same for all our issues and we always add information from a handful of fields in Jira on each issue. Is there a way to have the system automatically update our Excel file? Or maybe some add-on that performs something like this?

Daniel P_ Allis · Answer

Sometimes it is easier to reorganize data and display than it is to reorganize the minds of those consuming the data.

Aron Gombas _Midori_ · Answer

@Jon You can use the Better Excel Automation app to solve this!

The app extends standard Jira Cloud automation rules with Excel exporting capability. In your use case, you could use the app this way:

* use any of the Jira Cloud automation triggers to start the automation
* export the issue data to your Excel export template (you can create your own template, and from that the export will produce the exact output you wanted!)
* either attach the exported Excel file to an issue (even to the originating issue!) or email that to one or more email addresses

Here is how an automatically exported XLSX looks like when attached to an issue:

It is a bit different direction from your original idea, but it can work equally well (or even better).

(Discl. this app is developed and supported our team.)

Curt Holley · Answer

When you have a tool like Jira, you should really look to define your format in Jira so it can be the master for all your issues, otherwise what is the point of having Jira?