Can I use CSV import for creating issues?

光野 かおる
Contributor
December 19, 2024

Hello, Jira community. 

Our team is using two JIRA project.
One is the project we use with our customer and another one, we only use this in the team.
Some of these tickets are same but others are not because the project we only use in the team have more tickets that are broken down from the tickets we created from customer.

It is pretty much work to make same tickets for two projects.

So what I want to ask : Can I make CSV file and import and let it create ticket from it ?
How can I make the proper CSV style to make it apply to the JIRA import ?

Thank you.

 

3 answers

0 votes
光野 かおる
Contributor
December 22, 2024

@Vishal Banshraj Gupta Hello!
Thank you for your help !

I read the article and I thought it would be easier for me to sheet in excel and change it into 
CSV format. 
So I made the excel sheet like down below, putting some category that i want to show on Jira.
(Don't mind about the blank. I didn't fill in categories since I made it for the translation, I have my own CSV already filled in)

スクリーンショット 2024-12-23 150318.png
I also want to put Epic so that the issue on the sheet get categorized into the indicated Epic.

So What I want to know :  How can I make the issues categorized into the indicated Epics by CSV importing?)
Although I tried to find the category called Epic,I couldn't fine it from field mapping. 

 

 

Vishal Banshraj Gupta December 22, 2024

Hi @光野 かおる

So, you want to import issues with a parent-child relationship. If that's the case, then you need to consider the Parent & ID column of your Sheet.

For Example I want to import 2 Epic & it's child my Sheet will look like this

csv img.png

 

While Importing Mapping will be

CSV Column                ---->                          Jira Field

Issue Type                   ---->                       Issue Type        Check the Box

Id                                ---->                       Issue ID

Summary                    ---->                       Summary          Check the Box

Parent                         ---->                       Parent

 

Thanks,

Vishal

0 votes
Prachi Bolar
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
December 19, 2024

Hello @光野 かおる ,

Welcome to community :) 

Please find the document for the same : https://support.atlassian.com/jira-software-cloud/docs/create-issues-using-the-csv-importer/

Thank You

Prachi

0 votes
Vishal Banshraj Gupta December 19, 2024

Hi there,

 

Welcome to Atlassian Community!!

 

Please follow this link where you will get the basic idea on How to create issues through CSV Importer of Jira.

 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events