With Excel format you can get flexible data analysis, customized reports, data sharing, and record-keeping outside the platform.
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
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
Columns are fields, comments data, transition data, or approval data.
Comments look like this:
Transitions look like this
Approvals look like this:
Please note, at the end of the file, you can find the original JQL, example:
In the excel file you will also find:
Color differentiation:
Purple: Issue columns
Orange: Comments
Green: Transitions
Structured headers: The headers will be organized into one row.
Text alignment: The text fields will be aligned at the top in all cells.
Merged cells avoided: When exporting, there will be no merged cells hat hinder sorting and filtering of data.