Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Simplify importing a .csv file that was exported from Jira Cloud back into Jira Cloud.

I hope this isn't duplicated.  I received an error when I submitted this last time.

Is it possible to simplify how to import into Jira Cloud a Jira Cloud .csv file it exported?  An option for importing a previously exported Jira Cloud formatted .csv would be awesome.   My goal is to use Excel to clean up the content  instead of using the Jira web UI.  Specifically, fix spelling, edit start/completion dates, and reorder the items (including key numbers) so the list goes Task 1 then the subtasks to Task 1, Task 2 then the child subtasks to Task 2...etc.  

We tried the manual method.  I only changed contents in the rows (text, dates, key #s), not column headings or column positions..  Some challenges my admin and I encountered include:
1) best if done by an Admin
2) the column headings choices when importing don't match up 1:1 to the column names that were exported.   
3) the format the date in the exported file is different than the format Jira provides when importing the file. 
4) the format of the assignee/owner names in the exported file e.g., "John Smith" is different than the format required when importing back into Jira (numeric or email format).   

All of those issues we've been able to overcome.  Where we are struggling is that the task/subtask start and stop dates imported don't match up with what is in the spreadsheet.  It's almost as if the month from one cell was combined with the day from another cell in that row.  Not sure how to fix it other than go to the web UI and edit each date separately.  

Any ideas?

1 answer

0 votes
Jack Community Leader Jun 25, 2021

You can use CSV import to update fields. You need to include the issue key. Note that you cannot change the issue key as you have indicated.

Thanks.  We did use the CSV export and the CSV import.   One thing I forgot to mention is that my admin created a brand new project so we wouldn't impact the original file.   As it turned out, Jira imported the tasks in the new order I put them in but assigned them all new keys that were different that what I gave them.  The key numbering being different didn't seem to be an obstacle.  

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
Community showcase
Published in Jira

⏰ Day in the life of a Jira Admin!

Hello Community! We thoroughly enjoyed this just-for-fun conversation in the Jira Admin Group about what it's like to be a Jira Admin. For #JiraJuly, our talented designers created these graphics t...

705 views 2 21
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you