bulk edit entries in excel

[Kelly Capron (US - Tax)]

I am trying to export entire projects and related tasks and issues to excel, then edit in excel and then reupload the updates. is that possible? 

[Raja Seemakurthi - Appfire]

Hi Kelly,

Using Jira Command Line Interface app action we can update issues in bulk and upload the file data back to Jira. With this, we can see the issues are updated with the new changes.

--action runFromCsv --file "updateissue.csv" --common "--action updateIssue"

For example, prepare the CSV file with your own columns like issue, description, reporter, etc.. and provide the filename in the CLI action. 

Execute the action command and see the issues are updated in the Jira project.

Thanks,
Raja

[jira guy]

yeah....but WHY? 

[jira guy]

You can do csv imports to JIRA. You will probably have to do lot of mappings and import issues per project. 

[Rémi Formica]

He wants to UPDATE, not IMPORT... Import creates NEW tickets. You cannot use the Import feature to UPDATE EXISTING tickets. There are unfortunately only command line tools (Jira CLI) or 3rd party Excel plugins

[Kelly Capron (US - Tax)]

We have a list of tasks in excel already. I wanted to update names in jira to match the names in our existing spreadsheet. trying to get our tracker off google sheets. 

[jira guy]

Take a look at this article. It has detailed steps on how to import using csv(excel)

[jira guy]

Oops...! forgot to paste the link 

https://confluence.atlassian.com/adminjiraserver082/importing-data-from-csv-974356575.html