JIRA plugin for Excel data format

Pete Piro

Hi,

is there a way to specify data format types when importing data to Excel using the JIRA plugin?  

For example, JIRA shows Time to Resolve as a number 2:14 but Excel displays the information as text 2h 14m.  It would be nice if the time value stayed numeric.

 

Pete 

Levente Szabo _Midori_

Hi @Pete Piro 

Data formatting is one of the downsides of Jira Cloud for Excel, which doesn't currently have a solution. JCE doesn't use templates and it doesn't allow you to determine what Jira data to display in what format.

An alternative solution will be Better Excel Exporter, which will provide a fuller Jira Cloud Excel export experience for those who need quality. The Early Access Program is still open, so you can try the app for free until it comes out on the Marketplace. Please shoot me an email if you would like to get Better Excel Exporter now: levente.szabo@midori-global.com

If you each out during Apptoberfest, you can even secure an extra free month of usage once your official trial has ended. Check out and like Better Excel Exporter on the Apptoberfest for more details.