The add-in you’ve been waiting for: Jira Cloud for Excel 🙌

106 comments

Diego_Moralles April 1, 2020

@Mark Jones , 

 

I found a solution. If it happens to you again, do the following:

1: Locate the following path on your computer: C: \ Users \ LOGIN \ AppData \ Local \ Microsoft \ Office \ 16.0 \ Wef

2: Delete the WEF folder

3: Open Excel;

4: Activate the JIRA Component;

5: Authorize access to JIRA with your credentials;

It worked for me.

See you,

Helle Hagen Rasmussen April 15, 2020

Hi,

This add on have appeared on our JIRA without me as an Admin having known about it, which probably means that some random user have just tried downloading it, and it is now available for everyone. I have not yet concluded whether it is something we want all users to be capabale of doing, with the risk that they make bulk changes to a lot of issues by mistake, so is there any way of 1) removing the add on again, or 2) change permissions, so only some users can use it (as it goes for the Bulk change global permission)?

Best regards,

Helle 

Tanguy Crusson
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
April 15, 2020

@Helle Hagen Rasmussen : hi! All this add-on lets you do is export Jira issues that you have access to via your permissions to a spreadsheet (Microsoft Excel or Google Sheets) so you can create reports. You can't push any changes you make in the spreadsheet back to Jira, so there is no bulk change possible from the spreadsheet. So that should hopefully alleviate this concern. 

Helle Hagen Rasmussen April 16, 2020

Hi    @Tanguy Crusson 
Thanks for your quick reply. Ah that is great for our specific situation. Thanks for clarifying :)

Best regards,

Helle

Kumudu_Samarakoon April 27, 2020

Hi,

When I am using JIRA() function it returns "Start import... " text, imported row count, and also field names as headings with data. I want to get only data. Is there any way to get only data while importing?

Daria Koshelieva
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
April 27, 2020

Hello @Kumudu_Samarakoon , thank you for the comment.
Unfortunately there is no way to get only data,
JIRA() function was implemented to return number of imported rows (issues), as well as headings, date, time and User who initiated import.
Will be happy to assist if there are any other questions.
Thanks
Best regards,
Dasha

Kumudu_Samarakoon April 27, 2020

Hi @Daria Koshelieva , thanks for the quick reply to my question. 

Patricia Paguio May 3, 2020

Hi, I am looking to have this feature be used by my team but we currently use Office 2016 Pro Plus. I was wondering if this was compatible with this version or not?

I would assume not as I have tried to install it to no avail, and also see that it's not compatible with Office 2016 and Office 2019 Pro Plus. But it's worth double-checking just in case.

Sanjeev Angadi May 5, 2020

Love it, works great overall. Much needed add-in, excellent work by Atalassian team

Daria Koshelieva
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
May 7, 2020

Hello @Patricia Paguio 
Thank you for a question.

Add-In is supported for Excel 2016+ ; Excel 2016 for Mac ; Excel Online (https://appsource.microsoft.com/en-us/product/office/WA200000556).
Could you please describe installation steps you perform and if it is possible share screenshot of actual result received?

Thanks
Kind regards,
Dasha

Sean Pham May 21, 2020

I see a screenshot in the comments regarding a refresh sheet data button, however this does not exist in the most current version. Is the "refresh" now simply clicking "Get data now" again with the saved parameters?

John Croll May 26, 2020

I have this excel add-in enabled and am using the JIRA.JQL function in excel to query the status of specific issues.  If I enter =JIRA.JQL({issue key}, "status"), I get 4 rows worth of results (see below), only one of which is what I actually want-namely the status of the issue.  Is there any way to limit/modify how the results are displayed?  Having 4 rows returned for each row containing the JIRA.JQL function prevents me from applying this across multiple adjacent rows

 

excel jira add in screenshot.PNG

Daria Koshelieva
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
May 26, 2020

Hello @Sean Pham ,
Thank you for the question.
Now there is 'Get Data Now' button that changes to 'Refresh Data' after the first import on the Sheet, and back to 'Get Data Now' if at least one import parameter was edited after that.
Will be glad to assist if any other question comes up.
Kind regards,
Dasha

Daria Koshelieva
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
May 26, 2020

Hello @John Croll ,
Thank you for the question.
If I understand correct you are asking if it is possible not to show the following three rows :
1 - "Starting Import ...'; 2 - "<number> rows imported in ..." ; 3 - "<table header>".
Unfortunately for now there is no way to make them not to appear.
Will be glad to assist if any other question comes up.
Kind regards,
Dasha

Ken List June 10, 2020

Are there any plans to enable changes made in Excel to be posted back to Jira? Would be useful.

Daria Koshelieva
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 11, 2020

Hello @Ken List ,

Thank you for the question. Such feature is not planned to be implemented for this Add-In.
Will be glad to assist if any other question comes up.

Kind regards,
Dasha

Amitava Mallick July 30, 2020

I do not use Office 365, and use G-Suite. How can I get this Microsoft addin of excel for Jira?

Maksym Yokha
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 31, 2020

Hi @Amitava Mallick!

There's a lot of people who use G-Suite over MS Office and Atlassian has Jira Cloud for Sheets app which would be handy for you!

Amitava Mallick July 31, 2020

Thanks a ton for the guidance @Maksym Yokha 

Shari Lowe November 18, 2020

Would LOVE to see the ability to update ticket status, at a minimum, from the Excel side and push to update Jira - this would be HUGE!! Otherwise, this makes running my meetings a lot more user-friendly for the team - thank you! 

Wolfgang Essl November 24, 2020

I am not able to do a correct login from Excel. A web page is opened in a browser and I can select a Jira sites for which I want to authorize this app. After clicking "Accept" this error message is displayed:

state is not one of ours

Any suggestions?

Thanks 

Daria Koshelieva
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 26, 2020

Hello @Wolfgang Essl , 
Thank you for the question.

Do I understand correct that you have access to selected Jira site?
If it is possible could you please try to select some other Jira to which you also have access?

May I also ask you to try the following flow: Jira  'Filters' -> Run some saved Filter (or create and run some JQL Query) -> click on ‘Open In Microsoft Excel' button ‘Excel On Desktop’ / 'Excel Online’.

Looking forward to hearing from you.

Kind regards,
Dasha

Wolfgang Essl November 28, 2020

Dear Daria,

many thanks for picking this up. In a nutshell, this is solved. Thanks

 

To answer your questions:

Do I understand correct that you have access to selected Jira site?

Yes, the user is SITE_ADMIN on this Jira site and has a M365 license.

 If it is possible could you please try to select some other Jira to which you also have access?

Sorry, this is the only Jira site I have access to.

 

Excel On Desktop:

- A web page is displayed for Jira Cloud for Spreadsheets would like to 
access my account.

- after accepting, an Excel spreadsheet is created and downloaded. It 
opens in Excel desktop as expected.

 

Excel Onine:

- Microsoft requests me to login. I am using my M365 account, which is 
different from my Jira account.

- After successful login a new page is opened requesting access from 
Jira Cloud for Excel to my data

- after accepting another web page is displayed for Jira Cloud for 
Spreadsheets would like to access my account.

- after accepting, a new browser tab is created with Exel Online 
featuring requested data.

- when selecting "Open in Excel" a second time, it immediately opens 
Excel Online in a new tab. Great!
Melanie Jones December 30, 2020

Does any one know what type of connection this add-in uses? Needing to know for security reasons at work

Olexandr Danchenko
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
January 8, 2021

The App uses HTTPS and WSS protocols

Comment

Log in or Sign up to comment
TAGS
AUG Leaders

Atlassian Community Events