Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 13 Current »

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.

MK Documentation Updates (53).png

You can also export data from the gadget.

MK Documentation Updates (54).png

After clicking the Export button the export modal will appear.

image-20240625-124536.png

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

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

MK Documentation Updates (51).png

  • 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.

MK Documentation Updates (52).png

Selecting both the ‘Include total for all entries’ 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.

MK Documentation Updates (55).png

The selected fields will be available under ‘Details’ tab in the exported file.

MK Documentation Updates (57).png

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.

MK Documentation Updates (56).png

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).

  • No labels