How to create a custom report like an Excel (example in question)

Peter van den Ochtend

Why isn't possible without any paid tools (the application itself is already very expensive !!). to create a custom report.

Our product owner wants to have a report of the status of all the Epics with their child stories below. See screenshot for an Excel example.

All the data is available but only the formatting and presenting the data is unclear for me.

Mirek

Basically when you want to have a report in Excel only data is needed from Jira. If you download it (you can directly connect from Excel even) then using e.g PowerQuery on the Excel side let you format it in a way that would make it more friendly.

Example

https://www.youtube.com/watch?v=AQsEwVt6Oyo