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

[Wynter Fenn]

Is there a way to lock the filter so it can't be changed by other users?

[Daria Koshelieva]

Hello @Wynter Fenn
Thank you for the question.

Let me make a guess about the case: some Excel Files (with imported Jira data and Add-In Settings for that) were created using 'Copy' or ‘File → Save As’ flows, or were sent via email. And now if change Filter or JQL Query in Add-In of original File it changes for Add-In in copied File as well and vice versa.

If assumption is correct please avoid those flows of creating Excel Files and use ‘File → New’ flow instead.

If that is not the case could you please share your use case and its details so that we are able to reproduce, analyse it. 

Kind regards,
Dasha

[Deleted user]

Hi Atlassian,

Do you have any documentation for the plug-in with regards to the data transfer security protocols? Is it communicating over HTTPS, with which encryption etc.? I can't seem to find specific information for this plug-in.

Thanks.

[Marcelo Sosa]

CAn anyone help me? I dont need the highlighted rows any ideas on how to import the info just to one cell? I just need the result: PLANIFICADA. 

=JIRA.JQL("Key=proe-196";"status")

Thnx

[Tanguy Crusson]

@Marcelo Sosa Try this: 

=INDEX(JIRA.JQL("key=proe-196", "status"), 2, 0)

[Marcelo Sosa]

Hi Tanguy thank you! That was fast!!

I am getting an unknown error in excel which I am trying to figure now. This is the only thing it does excel 365. This red square with dotted discontinuos lines....but it wont retrieve anything else....

[Marcelo Sosa]

Hi Tanguy I managed to make it work in Google Sheets!!!! Thank youuuu!!!!

[Darrell MacKay]

How do you have separate queries for different spreadsheets? Import Data from Jira on spreadsheet 1, open spreadsheet 2 it is the same query. Change the query in spreadsheet 2, open spreadsheet 1 the query has changed to what was added to spreadsheet 1.

You can disregard. I just read a post where coping an excel file or using save as can cause this issue. That is the workflow I used. I'll correct it.

[Kemal Erdogan]

thanks for the info, does it work with atlassian hosted instances? could we connect it to our local jira instance?

[Aron Gombas _Midori_]

Hi everyone,

Let me suggest an alternative to the official Excel add-in for those who want to evaluate multiple options.

So, we released the Cloud version of our Better Excel Exporter app some weeks ago. It has been popular on the Server/Data Center platforms for a decade, and our users kept asking if we will offer this for Jira Cloud? Now it is available.

Our approach is radically different from what the official app does, and it offers:

• millions of customizations
• support for almost any field types (like SLA, comments, change histories)
• support for scripting (Groovy, VBA)
• integrations with the most popular Jira Cloud apps (Tempo, Zephyr, Insight, etc.)
• seamless interoperability with any tool that works with XLSX files (any version of Excel, Google Sheets, OpenOffice, LibreOffice, Calc, etc.)

🍿 This video gives a 3-minute intro: https://www.youtube.com/watch?v=FtE8CpHLQXo&t=4s

Thanks for reading!

[1058914517]

请求帮忙加入到Jira Product Discovery的内测中，我对这个产品非常感兴趣，同时有一些新的想法，希望与贵团队碰撞，非常感谢

[Jan-Cees van Buiten]

Seems very useful, as I am now exporting from Excel manually, often for the same type of report. But in order to start, I need some information from Atlassian so I our security officer can determine whether or not I can start using this plugin.

How does the login in Jira work from Excel? Where is the password stored and/or what security measures are taken to make sure the data transfer is safely and also the credentials are kept safe?

I know already https is used, but that is just one part. Would appreciate an answer.

[Jack Brickey]

@Jan-Cees van Buiten , maybe create a ticket with Atlassian Support.

[Jan-Cees van Buiten]

@Jack Brickey Thanks, I just did.

[john benjohn]

The "example spreadsheet" link appears to be NOT working.

[john benjohn]

The like to the guide doesn't appear to be working either:

3. Get started

You should see a Jira icon appear in the upper right hand of the Home tab. Click on the Jira logo to begin using the Jira Cloud for Excel add-in.

Want some tips on getting started? Check out our guide here.

                                                                                            ^^^ can't find page SharePoint page.

[Ian _I_ - Aware]

Is it possible to use this plugin to generate two different sets of data inside one Excel tab?

[Stephanie Donnelly]

I would like to share the spreadsheet I have created with other team members, I have set the workbook to refresh on opening but I'm concerned that they need access to the plug-in before this would work?  Can someone confirm if the refresh works without access to the plug-in

[Brian Debler]

@Stephanie Donnelly : From what I can see, each user needs to authorize the plug-in to use it, even for mere refresh cases.

[Stephanie Donnelly]

@Brian Debler thanks, I've ended up setting it up so that it refreshes and gives them a view, which to be honest is what they had before so it shouldn't cause them any problems.

[Dennis Winkel]

Currently I have the problem that tickets appear more than once in the list after an import.
This was not the case a few days ago.
Are there any current problems here?

[Ryan Anderson]

I just moved all users from MFA to an SSO authentication policy via Atlassian Access.

I have a few users who use the Jira Cloud For Excel plugin. These users also work with a vendor who utilizes their own instance of Jira. So, I have a user from my domain logging into Jira via SSO, and trying to access another site using the same login. This works in a browser.

However, we are unable to see any of the filters in use the Jira Cloud For Excel plugin for the vendor’s instance of Jira. This is possible when using the MFA authentication policy, but not when using the SSO policy.

I have attempted to use the “connect another site feature” but I still only see the filters saved on my domain/site. Any ideas on how to resolve this?

[Ricardo Gonzalez]

can work this add-in with Jira Data Center or Jira service management?

[Rudy Holtkamp]

@Ricardo Gonzalez no it can't. Cloud-only

[Thomas Christof]

Hi, is there a way to export the changes that are made in Advanced Roadmap but not saved yet. This would really helpful for planning scenarios that are in progress but not finalized.