How to export SLAs to csv or Excel in a usable format

[Danilo Simic]

I have created a filter with a set of JSM tickets and for that filter I have included 1 specific SLA that we want in the report.

When I export filter fields to CSV or Excel, for the SLA I get an unusable value. It appears in 2 variations:

1. As a date, where the date is 01/01/1900 and then a random time (note that in the cell itself the remaining SLA timer is shown properly example: 34:42 - 34h 42min)
2. As #VALUE, I assume because the data starts with "="

Is there a way to format the data or a better way of exporting it so that the data is usable?

Using an app from the marketplace is only an option if the app is free.

Thank you.

[Marc - Devoteam]

Hi @Danilo Simic 

ootb you would need to recalculate that in Excel.

Otherwise a marketplace app is required and there are no free SLA related apps or excel export apps that are free, that offer the functionality you require.

[Hannes Obweger - JXL for Jira]

Hi @Danilo Simic

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, this would now be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a long list of so-called smart columns that aren't natively available, including the columns for the various properties of your SLAs - like their time elapsed, start, finish, and breach time, etc. All these smart columns are included in the right format in JXL's Excel or CSV exports.

This is how it looks in action:

As every JXL sheet is powered by a JQL statement or saved filter, you have full control over which issues should be included.

I should also add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes