Skip to content
Menu
HelpExporting to Excel, CSV and PDF

Exporting to Excel, CSV and PDF

Download, among the buttons on the line with Period and Show report, is one menu. Excel and CSV save what is on screen as a file, and PDF saves the billable work as a timesheet to send with an invoice. With hourly rates, Xero and QuickBooks save the billable lines for each one’s invoice import. Copy link, before it, copies the page’s address with the report as it stands, the one Logline opens with included, so whoever opens it sees the same report, with the worklogs Jira lets them see.

The Worklogs view

The Worklogs view goes out exactly as shown, after the filter and the sort, with the work item fields the report shows beside each worklog as columns after the summary. The Excel file has one sheet, Worklogs.

The Timesheet

The Timesheet goes out as a flat list a spreadsheet can add up and pivot: one line per row, with the row above it named beside it, collapsed rows included, then the totals line. The columns come in the order the report shows them: the row’s names, Total (h), then Expected and Billable when they are on, then the period’s days, weeks or months, then the extra columns. A work item’s estimate and its other extra columns appear once, on its first line.

The Excel file has two sheets: Summary, the Timesheet as above, and Worklogs, every worklog the report counts, newest first, in the Worklogs view’s columns. The CSV file is the Timesheet alone. When a report holds too many worklogs to hand to the Download menu, the Excel file holds the Summary only and the line under the buttons says so; a shorter period brings the Worklogs sheet back.

The timesheet PDF

The steps are in Send a timesheet PDF.

With billable time in the report, Download, then PDF, saves it as a timesheet to send with an invoice: the client (or the report’s name), the period, your Jira site and the day it was made; the billable hours, the rate or rates and the amount; then one line per work item and rate, with its hours, rate and amount, and the total. In the Worklogs view each line lists its worklogs under it, oldest first, with the author and the comment when the view shows them; past 2,000 worklogs the PDF lists the work items only. The client is the row a work item sits under when the Timesheet’s rows are spaces, epics or a field such as Client; otherwise the report’s name. Cost and time that is not billable are never in it. Pages are A4, numbered, the header row repeated, and each ends with “Made with Logline · lineset.dev/logline” unless a Jira admin turned it off in Settings. Letters the PDF’s font cannot show, such as ā or ł, print without their accent (a, l); other scripts print as ?, and a line at the end says so: the Excel and CSV files keep every character.

For Xero and QuickBooks

The steps are in Make the invoice in Xero or QuickBooks.

With hourly rates, Download, then Xero or QuickBooks, saves the billable lines as a CSV file in the shape each one’s invoice import takes: one line per work item and rate, the hours as the quantity in decimal hours and the rate as the unit price. Nothing is sent to Xero or QuickBooks; you import the file yourself, and each invoice arrives unsent. Logline does not know your invoice numbers, accounts or tax, so it writes DRAFT-20261103-1 as the invoice number (one per client), the download day as both the invoice and due date, and leaves the account and tax rate blank: set them on the invoice before you send it. The customer is the client the PDF names; it must match your Xero contact or QuickBooks customer exactly. In QuickBooks Online, map the columns on the import screen, pick YYYY-M-D as the date format and Not applicable for Item Tax Code, and turn on Custom transaction numbers to keep the invoice number. QuickBooks takes at most 1,000 lines a file, each marked not taxable; Xero takes about 500 lines a file.

What is in the file

  • Above the table, the CSV file and the Excel file’s first sheet name the report, its scope, the people, the period, the time zone and the day it was downloaded, one to a line, such as “Spaces: HARB, HLAB” and “Counted in America/New_York”, then a blank row and the header, so a file sent on says what it holds.
  • With a billable rule in Logline settings, the Timesheet has a Billable (h) column, and with hourly rates an Amount column, on every line and the totals line; the Worklogs view has Billable (Yes or No) and, with rates, each worklog’s rate and amount. With bill up to the original estimate on, these carry only the billable part: the hours past an estimate are not in them.
  • For people who see cost and margin (the members of one chosen group), the Timesheet adds Cost and Margin after Amount, and the Worklogs view adds Cost rate, Cost and Margin. With budgets on screen, a Budget period column and Budget, Spent, Left and At completion in hours and in money, then Used (%), sit on the first line of each budgeted row, so a column sum counts each budget once. A person who does not see cost never gets those columns. See Set a budget and See cost and margin.
  • A week column is headed “Week of 2026-09-28 (h)”, a day “2026-09-28 (h)” and a month “2026-09 (h)”, or a week’s first and last day for a week the period cuts short. With Expected on, the Timesheet has Expected (h) and Against expected (h), the second signed (−40 is 40 hours under), once per person; the totals line adds up both.
  • The Worklogs sheet and the Worklogs view’s CSV give each worklog’s space by name and key, as on screen: “Harbor Digital (HARB)”.
  • Each sheet of the Excel file has a bold header row that stays in view as you scroll. The first ends with one line under the table, after a blank row: “Made with Logline · lineset.dev/logline”, a link to this site, outside the table, so a sort or a filter in Excel leaves it alone. A Jira admin can turn it off in Settings; the CSV file never has it.
  • In the Excel file each work item key, and each epic in the Timesheet, is a link that opens the work item in your Jira.
  • Hours are numbers in decimal hours, so a spreadsheet can add them up, and every column of hours says so in its header, such as Total (h).
  • Dates are YYYY-MM-DD. In the Excel file the Worklogs sheet’s dates are real dates, so a pivot by month needs no conversion; so are its created, updated, resolved and due dates. Its Started column, in place of the CSV’s Time, is the date and time the worklog started, a real date-time in the time zone the report counts in. Several values in one work item field, such as two fix versions, share one cell, separated by commas.

Where the file is made

The files, the PDF included, are built in your browser; nothing is sent anywhere.