Exporting and Importing Reports

Most Time Reports for Jira Cloud can be exported to .csv or .xls formats. You can also import worklogs in .csv format.

To export Time Reports:

1. Set up the report for how you want to export.

   Exports are available for all reports, except Calendar and Pie Chart. Several User Preferences can help you set up the export look (such as Time Tracking Columns, Time Balance Columns, Columns For Export, and Duration Type For Export).

2. From the report page, select the Export/Import icon.

   

3. Select whether you want to export the report data as .xls or .csv, or the report view as .xls.

4. Change the file name if necessary.

5. Select the destination.

Use URL Links to Export Timesheet Reports

You can set up and use URLs to export Time Reports. This can be convenient if you want to share these URL links in project wikis. The URLs follow a defined structure and you can copy them directly from the Export/Import menu or obtain them manually.

To export reports using a URL:

1. From the Export/Import menu dropdown, select the Copy Link icon next to your preferred report.

   

   The link is copied to your clipboard.

2. To derive the links manually:

   1. Set up the report as needed.

   2. Copy the URL, and append &export=xls, &exportData.csv, or &exportView.xls to the end of the URL.

      For example: https://YOURDOMAIN.atlassian.net/plugins/servlet/ac/jira-timereports/timereports#!pivotTableType=Timesheet&export=xls for Time Reports.

Importing Worklogs

You can also import worklogs in .csv format from the importTimesheet.csv option in the Export/Import menu. Your imported file should contain at least the Key and Time Spent.

Example of recommended format:

Issue Key, Date Started, Time Spent, Comment

NGEN-1,2020-09-16 09:00:00Z,2h,test

NGEN-2,2020-09-14 09:00:00Z,2h 30m,comment with spaces

NGEN-3,,1h,test

A header is not required, and the order is not essential, so the following line is acceptable: test,NGEN-4,1h

Worklogs are created for the current user, unless Log Work For Others Groups is active. You can also specify a specific user with their account id. For example: DEMO-1,2021-03-23 09:00:00Z,1h,test,accountid:557058:7f5bbab3-79c0-446c-b480-834e4fbcaf7c