Missed Team ’24? Catch up on announcements here.

×
Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

JIRA plugin for Excel data format

Pete Piro October 6, 2021

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 

1 answer

0 votes
Levente Szabo _Midori_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
October 12, 2021

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events