Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

using =jira.jql() in an excel cell


when I use the following in an excel cell, the task pane just says "1 of 1 rows imported. Saving..." and never actually brings back the query result.


I get a momentary #BUSY! message in the cell, then an "Import started at..." message in the cell. That's all.

I'm just trying to insert the Summary field value into the excel cell, not bring back a table or a property for multiple issues.

Edit: I tried this a different way, using a blank workbook and the following was the result, using 4 cells -- the cell I used the formula in, plus the 3 cells below it. This is not what is expected. Why would the 1st 3 rows come back from this usage? It seems poorly implemented if this is what was expected.

Import started at November 14, 2019 2:25 PM by Rob Wickham
1 rows imported in 2 seconds
Risk management and customer requirements embedded within each process definition

1 answer

0 votes
Jack Brickey Community Leader Oct 22, 2021

@Rob Wickham , just looking to clean up old issues. Is this stigma question for you or did you find the answer?

I stopped using it altogether because it didn't feel ready for prime time. Has the code improved in the last 2 years?

Found myself looking for an answer to this and arrived here - still seems to be the same, i.e. 3 additional/unwanted/useless rows output - what is the point of these?!

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you