A Jira timesheet by person and day, without a time-tracking tool
If your team logs work in Jira (the Log work button or the time tracking field), the data for a timesheet is already there. You don't need a separate time tracker to see it — you need a way to view worklogs by person and day.
What Jira shows out of the box
- On an issue — the Work log tab lists every entry: who, when, how long.
- In issue search — the Time Spent column shows the total per issue, but not per person or per day.
- Time tracking report (in some project types) — estimates versus time spent per issue, again not per person.
None of these answers "how many hours did each person log on each day last week".
Build it in a spreadsheet
- Search with JQL for the period, for example
worklogDate >= startOfWeek(-1w) AND worklogDate < startOfWeek(). - Export → Export Excel CSV (all fields). Worklogs come out in Log Work columns as
comment;date;author;seconds. - Unpivot those columns into rows (one worklog per row), split the four parts, keep only dates inside your period.
- Pivot: author as rows, date as columns, sum of hours as values.
Check two details: a worklog belongs to the day it was started, and an issue can match your search because of one worklog in the period while also carrying older worklogs outside it — filter by date after the export.
Or open it ready-made
Team Timesheet & Missing Worklogs (our app) shows exactly this table inside Jira, from the worklogs you already have — including everything logged before installing:
- this week, last week, this month or last month in one click;
- click any cell to see the issues and worklog comments behind it;
- narrow with JQL (
project = ABC) and save the view; - breakdown by project, parent and issue; CSV export for billing.
Read-only, runs on Atlassian, free for up to 10 users. How it works →