Jira Export to Excel

[Luis Dominguez]

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.

[Hannes Obweger - JXL for Jira]

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

[Aron Gombas _Midori_]

I can't find the "Last Comments" field on our Jira site, so I guess it isn't a built-in one. If so, you could try to contact the developer of the app that provides this.

Alternatively, you can try the calculated fields offered by the Better Excel Exporter app. These field values are exported to 3 strong-typed Excel cells:

1. Last comment text
2. Last comment user
3. Last comment date

...or there is "Last comment" which is a "merge" of these 3 values, if you prefer that output format.

See them in action in this sample export:

(Discl. it is a paid and supported app developed by our team. Free for 10 users!)

[Luis Dominguez]

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

[Aron Gombas _Midori_]

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