Link to Jira Cloud for Excel

[Nilesh Thakkar]

The export to Excel works well, however what if I want to make edits in Excel and import back into Jira.  Anyone know if this is possible?

[Alex Koxaras -Relational- · Accepted solution]

Hi @Nilesh Thakkar and welcome to the community,

You have to save the file as csv, make a few modifications and re-import it following the instructions which can be found here:

https://support.atlassian.com/jira-cloud-administration/docs/import-data-from-a-csv-file/

[Nilesh Thakkar]

thanks Alex, that's helpful. Shame there's no auto publish built into the integration in a similar vein to ADO or others.  Thanks though!

[Hannes Obweger - JXL for Jira]

Hi @Nilesh Thakkar

welcome to the community!

Whether it is an option or not depends on your exact use case, but you may want to have a look at the app that my team and I are working on, JXL for Jira; perhaps you don't have to export your issues at all.

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. In other words, you can work on your issues just like you would work on an Excel sheet, but directly in Jira. This is how it looks in action:

You can also bulk-edit your issues (via copy/paste); within JXL, or between JXL and pretty much any other app. With this, you can update any number of issues in one action.

As said above, whether JXL would be an option for you or not depends on your exact use case - but if it would be, it would almost certainly save you a significant amount of time.

Any questions just let me know,

Best,

Hannes