Create Excel reports from Tempo Timesheets

Tempo Timesheets is the most widely used time tracking app for Jira. Better Excel Exporter can export all the Tempo-managed custom fields (e.g. Account, Team and Iteration), the Tempo worklogs and the custom work attributes (e.g. Billable) to Excel. To make it convenient and intuitive, you can export not only from the Issue View and from the Issue Navigator, but also directly from the Tempo screens.

Overall, it is possible to build Tempo reports of any complexity with the help of Excel functions, formulas, pivot tables and pivot charts.

Next steps

Export samples

Tempo time estimate vs. time spent report

The tempo-report.xlsx exports the high-level Time Estimate and Time Spent values augmented with the Tempo-managed data (Account, Iteration, Team) for each Jira issue. It offers various pre-configured pivot tables, or can be cloned to create your own Tempo Excel reports.

jira-tempo-timesheets-report.xlsx

Tempo accounts pivot chart

Account is a grouping concept specific to Tempo, yet fully supported by Better Excel Exporter for Jira. This pivot chart example displays the worklog time values aggregated (SUM) by the Tempo Account field.

jira-tempo-timesheets-report.xlsx

Tempo teams pivot chart

This is another example of exporting Tempo-managed data from Jira to an Excel report. This chart shows the total estimated time and total spent time by Tempo teams.

jira-tempo-timesheets-report.xlsx