Appaq Labs

A Jira timesheet by person and day, without a time-tracking tool

For teams that already log time in Jira · Updated November 2026

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

None of these answers "how many hours did each person log on each day last week".

Build it in a spreadsheet

  1. Search with JQL for the period, for example worklogDate >= startOfWeek(-1w) AND worklogDate < startOfWeek().
  2. Export → Export Excel CSV (all fields). Worklogs come out in Log Work columns as comment;date;author;seconds.
  3. Unpivot those columns into rows (one worklog per row), split the four parts, keep only dates inside your period.
  4. 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:

Read-only, runs on Atlassian, free for up to 10 users. How it works →