Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,361,385
Community Members
 
Community Events
168
Community Groups

Import a csv file with test cases

Hello,

I am new here at Jira and trying my first testcase csv file upload. I found a blog which details how to import using csv. Do i need to have the headers exactly as mentioned below or can i use custom headers?  Thanks in advance

Summary, Assignee, Reporter, Issue Type, Description, Priority
"Test issue", admin, admin, 1, ,

 

2 answers

2 accepted

1 vote
Answer accepted
John Funk Community Leader Aug 26, 2022

Hi Ebe - Welcome to the Atlassian Community!

Just put the values in a Spreadsheet with whatever headings you want. Then save it as a CSV file.

Then when you import, you can map your spreadsheet values to the fields in Jira. 

@John Funk

 

Will try that and update here.  Thank you John

Like John Funk likes this
0 votes
Answer accepted

Hello @Ebe 

Welcome to the community.

If you are using the native Jira CSV import functionality you can use whatever names you wish for your headers in your CSV, with limitations. As you use the import wizard you will see that there is a step where you provide a mapping of your headers to the corresponding Jira fields to which the data will be added. With that mapping, it doesn't matter what names you use in your headers.

The limitation is when you are trying to import a value into a multi-select list, such as the Components field. In that case, each value you want to import is under a separate "header" but the names of those headers are all identical. If you wanted to add two values to the Components field, for example, you would include in your data:

Summary, Issue Type, ComponentValue, ComponentValue
Summary text, Story, value1, value2

Hi Trudy,

Thank you very much for your response. As mentioned, this is my first try in Jira and am trying to digest the information.  I will try to import the file and update if I am able to...

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
TAGS
Community showcase
Published in Jira Software

An update on Jira Software customer feedback – June 2022

Hello Atlassian Community! Feedback from customers like you has helped us shape and improve Jira Software. As Head of Product, Jira Software, I wanted to take this opportunity to share an update on...

5,069 views 18 32
Read article

Atlassian Community Events