Issues with data exported in Excel CSV from filters. Excel unable to display correct format.

Question

The image below is what happens when I export these 2 columns which are time until SLA breach. (e.g. 0:29 means 29 minutes until SLA breach for response same applied to SLA for resolution).

However, the data with negative values (meaning SLA breached) will have "=" added in front of them, and some of the hours and minutes are flipped. The columns where SLA is met will not have any issues.

Has anyone have any similar experience with this, and how was it resolved for you?

Hannes Obweger - JXL for Jira · Answer

Hi @ISJ Support

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, you may want to have a look at 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 time elapsed of your SLAs. You have full control over how these values are formatted and exported.

This is how it looks in action:

In this case, I've configured the time elapsed column to use Jira's w/d/m/s format, but I could also configure it to show the values in e.g. hours or minutes.

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

ISJ Support · Answer

Thanks @Dave Mathijs,

The selected '0' cell actually has a value in the Excel formula bar of =-5:31 which can be seen at the top of the image.

When opening this csv file using other applications (Notepad++, Visual Studio Code etc.) there are no issues with the data in this particular column. This issue only occurs when using Excel.

I found that prepending the data in the column with a space or single quote (uploading to ChatGPT and asking it to do it for me) will make Excel treat the data type as text and display the expected values that would normally be seen when opening the file using anything other than Excel.

Dave Mathijs · Answer

Hi @ISJ Support Welcome to the Atlassian Community!

The 'Export issues from Jira Cloud in CSV format' is quite limited.

When you look up these issues in Jira, what does the "Time to resolution" custom field S=(SLA) display for the issues that have a '0' in the export?