Is there a plugin available for MS Excel that works with in-premises hosted Jira (not in cloud)?

L.C.
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 26, 2024

The following plugin is available for Jira Cloud:

Jira Cloud for Excel

https://pages.store.office.com/addinsinstallpage.aspx?assetid=WA200000556&rs=en-US&correlationId=ee95d163-b36e-bee8-2910-db56dd718629

Does it also work for in-premises hosted versions of Jira? If it does not, is there an equivalent that works for these? 

My company runs Jira v9.12.5

Thanks in advance,

Best Regards

L.C.

4 answers

2 accepted

1 vote
Answer accepted
Hannes Obweger - JXL for Jira
Atlassian Partner
June 30, 2024

Hi @L.C.

welcome to the community!

while it may follow a slightly different approach than what you have in mind, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. All this happens directly in Jira, on live Jira data. This is how it looks in action:

inline-editing.gif

For more sophisticated use cases, JXL also comes with a range of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting. With these, you can create virtually any issue view or report in just a couple of clicks.

Any questions just let me know,

Best,

Hannes

1 vote
Answer accepted
Manoj Gangwar
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 26, 2024

Hi @L.C. ,

Welcome to the Atlassian Community!!

Please refer to the below plugin - 

https://marketplace.atlassian.com/apps/1222961/excel-365-connector-for-jira?tab=overview&hosting=datacenter

0 votes
Glen Cochrane
Contributor
June 26, 2024

When we were on-prem we would run our query/filter then Export to CSV and save as .xlsx 

It is an option, although a few extra clicks; not necessarily ideal depending on usage/process you are doing.

Glen

0 votes
MobilityStream
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 26, 2024

Hi @L.C. ,

You can try our Excel Integration add-on. It works with Jira Datacenter/Server & Cloud and Excel Desktop & 365. It supports direct downloads of Excel files or data can be directly exported to OneDrive/O365. Exports can be one-time, scheduled, or real-time You can also export much richer data to create more sophisticated reports (Assets, Changelogs, Projects, Sprints, Users, etc.). Everything directly controlled within Jira. Give it a try.

 

Kind regards,

The Mobility Team

Suggest an answer

Log in or Sign up to answer