Advanced Export (Atlassian)

Advanced Export

With Advanced Export for JIRA you can easily export issues (including history of changes) for further analysis in a spreadsheet or other tools.

As far as we know this is the only add-on that allows for export of history of changes for JIRA issues. Simply select what standard JIRA fields of custom fields you’re interested in and download exported files:

  • CSV (Comma-separated values)
  • Excel XLSX
  • JSON (useful for further programmatic analysis)

The file will contain additional row for every change of any of the selected fields.

Example use cases

Let’s assume there’s a JIRA project with 2 custom fields: Ice Cream Flavor and Reason. Issues in this project track current preferences for ice cream. Owner of one of the issues started with Vanilla ice cream and a reason of Safe Choice. He then changed the fields to Chocolate and Adventurous, followed by Strawberry and Why Not.

All these changes can be found in issue history panel in JIRA, however analysis would become cumbersome if we had tens or hundreds of issues with many changes for each.

With Advanced Export add-on you can export CSV file which would look similar to the below (assuming we’re exporting fields Created, Ice Cream Flavor, Reason, Assignee):

KeyAs of dateChanged fieldsCreatedIce cream flavourReasonAssignee
1ISSUE-105/23/202205/01/2022StrawberryWhy NotTomek
2ISSUE-105/15/2022Ice Cream Flavor, Reason05/01/2022StrawberryWhy notTomek
3ISSUE-105/10/2022Ice Cream Flavor, Reason05/01/2022ChocolateAdventurousTomek
4ISSUE-105/01/202205/01/2022VanillaSafe ChoiceTomek

Columns Key, As Of Date and Changed Fields are always added by the report.

  • Row 1: current values of fields. Changed Fields is empty as there were no changes on the day the report was generated.
  • Rows 2-3: rows representing snapshots of values of fields on the dates changes occurred. Changed Fields show which fields were amended.
  • Row 4: initial state of the issue as it was created

Note, that values in columns Created and Assignee remained constant.

Usage

Use Advanced Export icon on any Search issues screen as seen below:

Advanced Export icon on the Search issues screen

Select fields that you want to export, and choose whether history should be exported as well (this will produce extra rows for each change of the issue, as described above).

Advanced Export view

Note, that Preview shows actual data from the first issues being exported. It changes as you select fields to export and change settings.

Saved configurations

You can save or load export configurations using top menu.

Save/load configurations

Saved configurations contain all the options and selected columns.

Save As dialog