Export Jira worklogs to Excel, one row per worklog
Checked against Atlassian’s documentation on 7 October 2026.
For an invoice, a payroll run or an audit you need the worklogs themselves in a spreadsheet: one row each, with its date, author, work item, hours and comment, for one period. Jira’s export is built around work items, not worklogs. This page shows how to get from one to the other with Jira’s own tools, where it gets slow, then what Logline does.
What Jira’s export gives you
Search for the work items first. JQL finds every work item with time logged in a period, by anyone or by a team:
worklogDate >= 2026-09-01 AND worklogDate <= 2026-09-30 AND worklogAuthor in membersOf("web-team")
Then Export from the search results:
- The current fields export gives one row per work item. Its Time Spent is the work item’s all-time total from every author, not the time logged in your period (Community, January 2026).
- The all-fields export adds the work item’s worklogs as Log Work columns: one cell per worklog, holding its comment, date, author and time in seconds, separated by semicolons (look at one cell before you split them). Every worklog the work item ever had is there, from every author and every month.
From work item rows to worklog rows
To turn the all-fields export into one row per worklog:
- Open the file in Excel and keep the key, the summary and the Log Work columns.
- Unpivot the Log Work columns into rows (Power Query’s Unpivot Columns does it), so each worklog is a row beside its work item.
- Split each cell on the semicolon into comment, date, author and seconds.
- Turn the seconds into hours (divide by 3600) and the date text into a date.
- Filter to your period and your people. Keep the filter and the steps: next month starts again from step 1.
Three things to check before you trust the result. A comment with a semicolon in it splits into too many columns. The day a worklog counts on depends on a time zone: an evening worklog in New York is the next day in UTC, so a month’s edges can move. And the date in the file can be the day a worklog was entered, not the day it was logged for (JRACLOUD-77926, open): time logged on Monday for last Friday lands on Monday, so a timesheet built from the file puts it on the wrong day.
Someone technical can skip the spreadsheet steps with the REST API: the
work item search for the keys, then each work item’s worklogs from
GET /rest/api/3/issue/{issueIdOrKey}/worklog with startedAfter and
startedBefore
(Atlassian).
With Logline
Logline is our app. Its Worklogs view is the export above, already made, for any period and scope:

- Open Apps › Logline, or the Logline tab in a space, and pick the period: Last month, another in the Period list, or a custom range.
- Open the Worklogs tab. Every worklog in the report is a row: Date, Author, Work item, Hours and Comment, newest first.
- Sort it, or filter by a word in the comment, a work item or an author. The count line adds up what is shown, such as “10 of 116 worklogs · 10h”. With a billable rule, Billable only keeps the billable worklogs, and each row has its rate and amount.
- Download, then Excel, takes the list exactly as shown, after the filter and the sort. CSV does the same as a CSV file.
What is in the file:
- Hours are numbers in decimal hours, so the spreadsheet can add them up.
- In the Excel file the dates are real dates, so a pivot by month needs no conversion, and Started is the date and time each worklog started. Each work item key links to the work item. The sheet has a bold header row that stays in view.
- The Timesheet tab exports too: one line per row with the row above it named beside it, then the totals line, ready for a pivot. Its Excel file has a second sheet, Worklogs, with every worklog in the report.
- The files are built in your browser; nothing is sent anywhere.
A report reads up to 50,000 worklogs; above that Logline says so and asks for a shorter period or a smaller scope. Each column is described in Exporting to Excel, CSV and PDF, and the Worklogs view in The Worklogs view. For hours per person rather than worklog by worklog, see Jira worklog report by user and month. More on the Logline home page.
