Extract hours booked by team member on Jira code in excel

[Shashidhar]

I would like to extract hours booked by team members who are working on my project in Jira. They book on the jira code and I need to manually take down the numbers for particular resource.

Is there a way of extracting the hours booked by a resource in Jira code to Excel.

Fields required:

Name of the resource

Hours booked week wise or end of the week Friday

Thanks

[Levente Szabo _Midori_]

Hi @Shashidhar ,

For a sophisticated Excel export or report, you can give Better Excel Exporter a try. It's developed by our team and can export the various fields you would like to see in your Excel output, including the exact amount of time spent. If you are using a time tracker app like Tempo, it's compatible with that, too. It also has a dedicated template to create work related pivot reports.

 

[Shashidhar]

My Team is booking hours from Tempo only. I just wanted to extract that data in Excel format. Please advise.

[Levente Szabo _Midori_]

I suggest you install Better Excel Exporter app into your Jira, try an Excel export and see if that's what you need.

For more information about the app, I recommend the Documentation or a hands-on webinar like this.