Upload Excel view back into Jira

Question

In Jira you can view Jira issues, tasks, etc. as an Excel worksheet. That workseet can be edited. Is there a way then to upload/import that edited worksheet back into Jira to update the edited fields in Jira?

This would enable a more optimal way to review Jira issues quickly than having to click on each one individually, then edit it, then return to the overview and look at the next issue.

JIRA shot.PNG

Excel Shot.PNG

Makeupchick 101 · Answer

Hello we are wanting to do something similar. We currently upload our schedules to JIRA but we want to schedule right from JIRA instead...however we cant' due to the limited functions...this is what we need or an add on I could get IT to work on....

We basically need a way in JIRA to be able to click on the key reporter whatever like in Excel and select by the data...we know we can click it and it sort by it but we want to actually fill in black information in the future and in order to do this we would need to filter.

Excel Shot.PNGJIRA shot.PNG

unknown · Answer

We would NOT use this capability (if it existed) in the mode you described. We have a weekly staff meeting and review all the task and issue items. We update status of those real time as we review them. Doing this on a spreadsheet is much faster than bouncing around on the Jira web pages. When we are done it would be nice to be able to port that spreadsheet back into Jira format. We would not allow multiple users to view in spreadsheet then port back to Jira.

Nic Brough -Adaptavist- · Answer

No The point of the Excel download is for people to grab information to manipulate for reports. It's a convenience, and it's one-way. It's not "optimal" to do updates that are not within the dataset you want to change, and a download is, by definition, obsolescent the instant you have it, so you really don't want to be updating it anyway. Consider the simple case - you download a sheet, I update the issue summary a couple of seconds later. Your information is out of date, and if you upload a change to summary, you're going to break what I've done without even knowing. A "more optimal" way to review and update is for your users to do it in