Page content
Table of Contents | ||||
---|---|---|---|---|
|
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
...
...
Step 2: Choose issues to export
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 and then click on "Continue with # issues"
...
Step
...
3: The format selection screen
1. The second next step is to select the format of the export. Between all of them, select Excel .2. Click and thenclick on "Continue with # issues"
...
Step
...
4: The extra content screen
Select the extra content that you wish to export and then click on "Continue with # issues"
...
Info |
---|
With Exporter, you can select the extra content that you want: Comments
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.
By checking Transition and its approvals, you can also include approvals for each transition with approvals, in this case, this information will be exported:
|
Info |
---|
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 5: Final check
Check the summary of your export and then click on Export now to start generating and downloading the file. You can also schedule the export.
...
Info |
---|
You will see a Summary screen showing the information that you want to export:
|
...
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. |
...
Step 6: Download
Once the process is 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"
...
Info |
---|
You can download the file as many times as 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 the "Back" button and click on "Export now". |
Excel file explanation
1. By default, every row is an issue, but, if you export transitions or comments the rows will be merged and you could have more than one row per issue:
2. Columns are fields, comments data, transition data, or approval data.
3. Comments look like this:
4. Transitions look like this:
5. Approvals look like this:
6. Please note, at at the end of the file, you can find the original JQL, example: