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

[L.C.]

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.

[Hannes Obweger - JXL for Jira · Accepted solution]

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:

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

[Manoj Gangwar · Accepted solution]

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

[Glen Cochrane]

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

[MobilityStream]

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