How to update existing tickets in an excel file without erasing what's currently on the file ?

[Monica Tami]

Hi I'm trying to update tickets from different epics I have in my project, but If I try to run the query, everything will be erase from my file 

How I can do that without erasing what I already have in there?

Thanks for your help

[Petter Gonçalves]

Hello @Monica Tami

Welcome to the Atlassian Community!

To properly update your existing issues using CSV import without erasing the current data you have, you can do the following steps:

- Navigate to your Issue navigator and create a JQL filter returning all the issues you want to update

- Then, Click to export it to Excel (All fields):

- In the exported file, add/change the columns you want to modify in the issues and save it, keeping the other columns untouched (Especially the issue-key column).

- Import the updated CSV file back in your Jira site

Doing the steps above, the issues will be updated in your instance but their current values will not be erased.

P.S: Test the steps above with a "dumb issue" first, just to confirm this works as you expected and there are no other concerns.

Let us know if you have any questions.

[Monica Tami]

Thank you this was so useful !!