Export JIRA backlog to Excel, make changes and then push back to JIRA with updates

[Stu Carmichael]

Hi guys

I'm a JIRA newbie product owner and have come from Dev Ops!!

In DevOps I was able to export data out to Excel, make changes to the data and them push back to DevOps where all the changes to data would be done.

How do I do that in JIRA? I can see how to export but how do I push changes back in?

Thanks for any help.

Stu

[Jack Brickey · Accepted solution]

You can use the CSV importer to accomplish this. Export the issues you desire to change and make your changes then save the file as CSV. One thing you need to be sure of is to have in your first column the issue key by doing that the importer will make updates to those issues based on the rest of the columns.

here is a reference on the CSV importer. create-issues-using-the-csv-importer . It refers to creating issues but the principles are the same. The key is to include the Jira issue key.

[Stu Carmichael]

Perfect, thanks I'll have a go.

[Hannes Obweger - JXL for Jira]

Hi @Stu Carmichael, welcome to the community!

Without knowing the exact problem you're trying to solve - is it a requirement for you to export and re-import?

If you're looking for an Excel-like view on your issues, and if you're open to solutions from the Atlassian Marketplace, you may want to have a look at JXL. 

It's a freely-configurable spreadsheet/table view for Jira that gives you pretty much everything you're getting from Excel, Google Sheets etc. - without ever having to leave Jira. Features include fast inline editing (either of individual issues or in bulk), copy/paste, quick column sorting and filtering, support for issue hierarchies, and much more.

Here's a quick look into JXL, in case this sounds interesting:

https://www.youtube.com/watch?v=SBmY6bCOvnY

(Disclaimer: I work on JXL :))

Hope this helps,

Best,

Hannes

[Stu Carmichael]

Thanks for the quick response Hannes. I'll have a look.