How can i export an Issue's Change History tab results in an excel sheet?

I wanted to prepare a report which will give me a overview of the change history of an issue, how can i achieve it?

3 answers

0 votes

Copy and paste the "issue history" tab?

There's not a lot else you can do here.  A word export might get you part way to an excel table, but the change history is the best option.

I find it interesting that this is one of the FIRST things I wanted to do when tossed into a project having over 7,000 issues. What I want to do is to look at aggregate statistics showing how long it takes a bug to go from "In Progress" (not "Created") to "Closed" and to look at the average between priority groups to see if things are being classified correctly so that predictions for delivery dates can be improved.

The only way to get this is to be able to export Issues AND link them to exported IssueHistory.

@Nic Brough [Adaptavist]

Hello Nic,

Thanks for your reply, though copy and pasting would not be good idea in my case as i am having around 500-600 issues in my JIRA project.

Do we have any plugin available for this which significantly export History of issue. I found one plugin - Exporter but it only facilitates to export Comments and Transitions besides default JIRA export.

I'm not aware of any add-ons that would do that.  I see your point about 500 issues, but that begs the question "why?"  What do you need the history of 500 issues for? 

We have one requirement where we wanted to track changes in versions of each issue in its lifecycle.hence this requirement.


Mmm.  The changes are already tracked in JIRA's history for the issues, so you already have the tracking.  I think my question needs to be more about how you really want to report on this.

In support of pratiyush.rounak, I need change history to get stats on aging of items throughout their status change lifecycle. The only way to get this is through the change history that gets linked to an issue or sub-task.

To make a point to Atlassian, instead of asking "Why do you need this?", why don't you think in terms of Big Data and simply provide the information to us in a digestible format and let the users decide what they want to do with it.

In case anyone is interested in the solution for JIRA Cloud, there's now plugin that exports history of changes to JIRA issues - Advanced Export.

Any custom or standard field can be exported with every change as a separate row to make it easy to analyse in spreadsheet or postprocess in any other way.

Full disclosure: I'm the author

Tomasz, any plans to add a single issue export function or build another addon?

i havent found a plugin that can export a single issue with full details, i.e. comments, transition, history, activity.

we have audit requirements and we have to selectively export full details for request specific issue.

I evaluated Advanced export and it seems pretty straightforward, but doesnt meet my needs.

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Feb 15, 2018 in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

1,064 views 6 19
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot