Jira Export to Excel

Question

I have a filter that includes the "Last Comments" field, displaying when comments were last added to an issue. This field presents the information in date format, such as '2 weeks' or '3 days'.
However, when I export this filter from Jira to a Microsoft Excel spreadsheet, the field appears as various numbers instead of dates. How can I resolve this issue? I attempted exporting using CSV and other features, but it included fields not part of the filter and was unhelpful.

Aron Gombas _Midori_ · Answer

I don't know about a built-in feature, but don't forget that even your current solution probably relies on an app!

Luis Dominguez_hb1uaj · Answer

Is there an option that does not require an app from the market place.

Hannes Obweger - JXL for Jira · Answer

Hi @Luis Dominguez

as already suggested, I don't think that the Last Comments field is a built-in field. Do you happen to know where it comes from?

For an immediate resolution: 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 number of so-called smart columns that aren’t natively available, including the last comment, the date/time of the last comment, and the time since the last comment. All these values can be exported to Excel or CSV in just two clicks.

This is how it looks in action:

I should 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