Exporting detailed time reports

[Chuck Kandzierski]

I don't need a full-blown time reporting system.  I am sure most of the third-party apps will do this.  The one thing I need but haven't been able to figure out in Jira is how to export time reporting information per employee.  The standard export rolls up all time for all employees for the entire life of the ticket.  I would like to export all time reported for each ticket for each employee individually for a period of time.

[Anton from JetHeads_io]

Hi @Chuck Kandzierski! 👋

Unfortunately, Jira doesn’t let you create reports per user, per issue, over a specific period. It just rolls everything up.

If you’re looking for a simple way to get exactly that, check out JetTime — it’s lightweight, not bloated, and built for easy reporting. You’ll get clean exports by user, issue, and date, and it’s free for up to 10 users. And you can export to PDF, Excel, and CSV. Worth a look!

👉 JetTime on the Atlassian Marketplace

— Anton, developer of JetTime

[Deniz Oğuz - Starware]

Hi,

If you don't need a full timesheet solution like WorklogPRO, you may try exporting issues to CSV using issue navigator. This will put every worklog of the issue as a new column and when you open this file in Excel, you can do various Excel tricks to group it by each user. 

[Rahul_RVS]

Hi @Chuck Kandzierski 

As an alternate, our app can certainly help you meet the requirement mentioned by you.

Worklogs Time Tracking in Jira & Timesheets

With this add-on, you can easily view all time entries for multiple issues day wise / month wise, user wise, grouped by in a single view. Also filter worklogs created between a date range as shown below. Main features of the app -

• Create time reports in real time by grouping & categorizing data with aggregation
• Prepare your reports based on Project/Sprint/Issue Type/Assignees and various other filters
• Group your data to build more meaningful reports
• CSV Export
• Dashboard gadget
• Enter Time Spent for multiple issues from Timesheet screen. With Calendar view and Board view

(Disclaimer: I am part of the app development team)

[Mary from Planyway]

Hi @Chuck Kandzierski 

If you'd like to to do it in Jira natively, here you can find the information on how to do export with the REST API. 
If you consider third-party apps, then in Planyway you can either export this data at a click with Export feature, or get a more robust report in-app.

Cheers!

[Kate Gondarovskaya]

Hi @Chuck Kandzierski 

It sounds like you are looking for more granular time tracking and reporting than what Jira natively offers, and specifically, a way to export time data per employee, per ticket, and within a selected time period.

You might want to check out TMetric, a time tracking and reporting plugin that integrates with Jira. It helps you:

1. track time per issue and user
2. set custom time ranges for reports
3. generate and export detailed time reports filtered and grouped by the required parameters.

Might be just what you need! 

You can find more about the plugin and integration here: TMetric for Jira

Best,
Kate

[David Nickell]

Did somebody say time reporting through the REST API?  I can provide that.  I built this for a client last year and I own the IP.  I hosted it for them most of 2024 after which they took a copy of the code and turned it over to their own BI team.

I'm in the midst of turrning it into a product -- but the groceries have to be paid for now :-).

I can demo with their data to a select few (I have permission).  

Let me know if you'd like me to help cobble a version together for you.  Shouldn't take long meaning I could be ready over the weekend if you like.  In fact, I can give you my Atlassian User ID and if you add me to your instance with the right permissions, magic happens and we can do a demo pretty quickly. 

[David Nickell]

I should add -- this code runs in PowerQuery which is transferrable between PowerBi and Excel.  So if you just want the data in XLS, we can make that happen as well.

[Trudy Claspill]

Hello @Chuck Kandzierski 

Jira does not have a native feature available in the UI to generate that type of report.

You could build something custom using the Jira REST API, or you could look at a third party app.