Skip to main content
Skip table of contents

Data Export in Jira to CSV and XLSX

Time in Status allows data export to CSV and XLSX files.

All the following reports are available to export: Time in Status, Assignee Time, Average Time, Status Entrance Date, Time in Status per Date, Status, and Transition Count.

image-20231227-092758.png

You can export data from the grid to XLSX or CSV files, which you can analyze using tools like Excel or Google Spreadsheets.

Click the necessary file format to start report exporting.

image-20231227-092912.png

Also, on the same tab, you can view all shipped exported reports and delete reports from the history.

image-20231227-094544.png

Export your custom Pivot Table reports to an Excel or PDF files.

image-20231227-094712.png

Note! To extract data for analysis, please choose one of the Decimal time formats (Decimal Hours, Decimal Days or Decimal Weeks).
It will enable you to perform calculations on the exported data and build charts.

The Chart report is available for export as PNG, JPEG, PDF, SVG files.

image-20231227-094750.png

Gadget Export

Let’s learn how you can export your Gadget data. Here are a few steps to perform:

Step 1: Add the Gadget to your Jira dashboard and configure the table view as desired.

image-20231227-094819.png

Step 2: Click on the "Export" button located above the table.

image-20231227-094844.png

Step 3: Select the export format that you prefer - either "XLSX" or "CSV" - in the modal window that appears.

image-20231227-094913.png

Step 4: The file will be automatically downloaded with the name starting with [Gadget].

image-20231227-094942.png

Note: The export process will be canceled if the Gadget is refreshed manually, auto-refreshed by the system, or the tab is closed before the process is finished. 

If you encounter any issues during the export process, please contact our customer support team for assistance.

If you need help or want to ask questions, please contact SaaSJet Support or email us at support@saasjet.atlassian.net

Haven't used this add-on yet? Try it now!

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.