Export reports to Excel | Colined Help Center

This article lists several advantages that Worklogs Report provides compared to Jira’s built-in Issue Navigator, especially for exporting work items within an Excel Workbook.

Why should you use Worklogs Report to create an Excel file?

Jira’s Issue Navigator lacks a native export to Microsoft Excel. Instead, you can only export as CSV, Excel CSV, or through a Jira add-on. Additionally, exporting more than 1,000 work items at a time using the Issue Navigator’s export feature is unsupported by Atlassian, requiring a workaround for larger exports.

Worklogs Report addresses these limitations by enabling you to export an Microsoft Excel workbook without additional configurations or add-ons.

This ensures you avoid formatting work items, eliminates the need to separate text into columns, and allows you to quickly explore and share data.

For example, once a report is downloaded into an Excel Workbook, you can analyze its contents, create custom charts, or embed a copy into presentation slides.

Features and use cases

Export contents from each report section

The exported workbook contains two sheets, one for each section.

Summary section

The Summary sheet contains a user column, a field column (if you selected one for Group By), and columns for the selected interval such as Day, Week, or Month.

Breakdown section

The Breakdown sheet contains the following default columns: Worklog By, Priority, Issue Type, Issue, Summary, Worklog Date, Time Spent (Hours), and Comment.

The Issue and Summary columns are hyperlinked to your Jira instance, matching their behavior in the Breakdown section of the report.

If you select up to three additional fields in the report, they are added as columns in the Breakdown section.

How can you export a report into an Excel Workbook?

To create an Excel Workbook, click on Excel in the header section , and access the resulting Excel Workbook for this tab.

FAQ

How is the content exported in the Excel Workbook?

The exported Excel workbook is organized as follows:

First worksheet: Contains the Summary section.
Second worksheet: Contains the Breakdown section, if enabled.

How will the Workbook be named?

The exported Excel workbook is named using the report source and the selected date range.

For example, if a report named Worklogs uses the Demo space as its source, includes worklogs for all users, and its date range is Last Month, clicking Excel in the header during July 2026 downloads a file named:
worklogs-wl_demo_all_users_260601_260630.xlsx

How will time-based values appear?

When you export a report, all time-based values are converted to hours.

For example, 30 minutes appears as 0.5 hours.

For values expressed in days or weeks, the conversion follows the Global time tracking settings defined in your Jira instance.

For example, if one day equals 8 hours and one week equals 40 hours in your settings, the exported report reflects those values.

Troubleshooting

Can you encounter errors while exporting?

Yes. You may encounter errors while exporting data to Excel from Worklogs Report on Server/Data Center, as mentioned in a related article.

If you have questions or need assistance, contact our support team via email or service desk. Our team is available Monday through Friday (9:00 AM to 7:00 PM GMT+7) to help with technical challenges or discuss improvements.