Excel Export

Get started with Excel Exports

This article will guide you through the process to get Excel reports on Exporter. With it you will be able to get your issues' information including comments and transitions in a native Excel file with just few clicks.

Step 1: Go to Exporter from the JIRA Issue Navigator and select issues that you want to export

1. Once you have the results of the filters in the Issue Navigator, click on Exporter Button

2. Once you are in the first Exporter Screen you can uncheck the issues that you don't want to export, by default all the issues are selected. Click on "Continue with # issues"

Step 2: The format selection screen

1. The second step is to select the format of the export. Between all of them, select Excel.

2. Click on "Continue with # issues"

Step 3: The extra content screen 

Do you feel that JIRA default information is not enough? No problem, with Exporter you can select the extra content that you want:

  • Comments: Export the issues comments. You will have the comment's date, author and message. Also, you will have the security of the comment Public or Internal and the name of the group or role.
  • Transitions: Export the workflow trace that each issue follows. For example: perhaps an issue has started in To Do, then it was moved to Doing and it has ended in Done.

You can select more than one extra content, feel free to choose all of them

1. Select the extra content that you wish to export

2. Click on "Continue with # issues"

3. If you downloaded the Issue transitions, these are columns you will see:

  • Initial status date: The date in which the initial status is established.
  • Time in initial status (sec): Time in the initial status before the transition in seconds.
  • Initial status: Initial status of the transition.
  • Final status: Final status of the transition.
  • Transition date: When the transition is done
  • Transition user: The user who did the transition
  • Times: How many times the same transition has been done?
  • Time in final status (sec): Time in the final status before the transition in seconds.

Step 4: Just a final check and download

You will see a Summary screen showing the information that you want to export:

  • Number of issues
  • Format
  • Extra content

1. Click on Generate File to start generating the exported file.

The process is pretty fast but if you are going to export a lot of issues (more than 10,000), it may take a bit longer. But no worry, while you prepare a coffee your export file will be ready, be patient.

2. Once the process finished you will see a confirmation screen. Click on "Download file now" to download the exported file. You can download the file as many times you wish during the next 10 minutes. After that time, the file will be deleted. If you need to download it again, please generate the file again. Just click on "Back" button and click on "Generate file"

Please note, at the end of the file, you can find the original JQL:

Page content