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

Question

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:

* 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)
* 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.

Alina Kurinna _SaaSJet_ · Answer

Hi @Danilo Simic

If you're open to using Marketplace apps, I'd recommend giving SLA Time and Report a try.

I know you mentioned you're looking for a no-cost solution, and this app might still work:You can use it for free if you have fewer than 10 users, or test it out with a 30-day trial. That’s usually enough time to see if it improves your workflow and helps solve pain points like SLA exports.

With the app, you can easily export various types of SLA reports in a clean, usable format - no weird values or broken timestamps.It’s also flexible and simple to use: configure your own logic, automate actions, and monitor performance with clear visual reports that highlight bottlenecks.

If you have any questions, feel free to reach out. I'd be happy to help!Regards.

cathrine.chanslor · Answer

@Danilo Simic

This question is pretty old but as I found it while struggling along the same lines, I thought I'd tell you what just worked for me.

Initially, I exported my list with "Export Excel CSV" and got the unusable SLA data, similar to what you reported. I then exported my list with "Export CSV" and then imported it into Excel (Data -> From Text/CSV) and it imported perfectly.

I hope that helps you or anyone else who may have any issues in the future.

Cheers!

Hannes Obweger - JXL for Jira · Answer

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