nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Jack Brickey

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.

All comments

Jack Brickey

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.

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

Perfect, thanks I'll have a go.

Stu Carmichael

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud