Export

Owned by Monika Mo Kaczkowska
Last updated: Feb 27, 2023 by Michał Tkacz
2 min read

See also https://community.atlassian.com/t5/Marketplace-Apps-Integrations/How-to-export-Jira-worklogs-to-a-spreadsheet/ba-p/1684953

The export option allows sharing your Worklogs data. In order to do that, set the table view of your Worklogs and click Export on the right.

You can also export data from the gadget.

After clicking the Export button the export modal will appear.

The first section ‘Totals in exported file’ allows you to choose which totals should be included in the exported file:

  • The grand total is the very last row in the exported data containing the sum of all entries for the selected period.

  • The sub totals are calculated for the data described by category, grouping, and secondary grouping filters. In the exported file the rows will appear directly after the data rows for the given category, grouping, or secondary grouping.

Selecting both the ‘Include grand total’ option and the ‘Include sub total’ option will result in generating an XLSX report that is an exact representation of the Worklogs table. Note: there must be at least two rows of data to calculate a total. Otherwise, the total row is skipped.

In the second section ‘Select fields included in the exported file’ you can configure which fields will be included in your report. By default user, time spent, and issue key is selected. You can also select one field to sort the data by. Disabling the section using the switch button will result in exporting all available fields.

Your Worklogs data can also be shared with a link. To do that, click Copy button in the ‘Copy XLSX link’ section. The link will be automatically saved to your clipboard. Opening the link in a browser will result in downloading the XLSX file.

The exported XLSX file will include two tabs: 

  • Data view which replicates what you see on your Worklogs page - your groupings, filters, date range, and others.

  • Details view which allows you to view all the time entries that were submitted and that contribute to the reported times (in case of exporting a report with selected fields, only the fields of your choice will be included here).