With Excel format you can get flexible data analysis, customized reports, data sharing, and record-keeping outside the platform.
Rows look like this:
By default, every row is an issue, and if you export transitions or comments the rows will not be merged, so there will be no merged cells hat hinder sorting and filtering of data.
Columns are fields, comments data, transition data, or approval data. The columns are in colors that goes like this:
Purple: Issue columns
Orange: Comments
Green: Transitions
Comments look like this:
Transitions look like this
Approvals look like this:
JQL
Please note, at the end of the file, you can find the original JQL, example:
Adapt data format before exporting
Date fields
Format: the one the Jira instance has set on Look and field “Complete Date/Time Format”:
Campos duration de transiciones, “Time in final status” and “Time in intial status”:
Format: the one the Jira instance has set on Time tracking “Time tracking format”:
No tenemos en cuenta los working days para esa duración, sino el tiempo natural pasado. Ejemplo: 3dias, en ese caso es que pasaron 72h reales desde el inicio al fin, mientras que en horas laborables hubieran sido 24h.
se coge el formato de jira, pero no tiene en cuenta el timetracking, es decir son 24 horas al día y 7 días a la semana.
Number
Format number from Excel settings:
