...
With Excel export, you can extract flexible data for analysis, customized reporting, data sharing, and record-keeping outside the platform. Here's what exported data looks like and how to format it before exporting.
...
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.
...
Author and timestamp.
Visibility settings (e.g., public or restricted).
The actual comment content.
Example:
...
Transitions
...
Its format is the one the Jira instance has set in Look and field “Complete Complete Date/Time Format”Format:
Duration fields
Duration fields, such as time spent, aggregate time spent, time estimate, aggregate time estimate, time original estimate, aggregate time original estimate:
Format: the one the Jira instance has set on Time tracking Time tracking format:
They are calculated based on Jira setting in Working hours per day and Working days per week
Transitions area - duration fields
"Time in final status" and "Time in initial status":
Format: the one the Jira instance has set on Time tracking “Time tracking format”: Time display format
They are calculated in real hours, not working hours. For example:
3 days = 72 real hours, even if there are only 24 working hours.
...