CSV Importing subtasks

[Adam Wantling]

Complete noob here, I have an issue in Jira and I want to import lots of child issues to it from a CSV file. How do I do it? What columns do i need in the excel and what do they need to be mapped to?

[Tony Rossiter · Accepted solution]

@Adam Wantling 

Here's an overview on CSV imports into Jira, including how to bring them in as Sub-tasks: 

https://confluence.atlassian.com/adminjiracloud/importing-data-from-csv-776636762.html

A couple of notes from personal experience: 

1. Unless you're importing to multiple projects, use the import tool's feature to select a specific project rather than using the Project field to map a project.  It's cleaner
2. Date formats are picky.  When you select a format through the import tool, make sure those columns in your .csv are formatted correctly.   The default format it suggests is "MM/dd/yy hh:mm a".  The corresponding format in the .csv is "MM/DD/yyyy h:mm AM/PM"
3. User fields can be tricky but, not having done this in Cloud myself (I only use server), I'd recommend following the advice in the link above