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,296,559
Community Members
 
Community Events
165
Community Groups

Error while importing test case into JIRA - Second line (after header row) in CSV file is blank

HI,

 

I have my manual test cases in excel.I have converted it to CSV file.When i tried to import it says an error message 

 

"Second line (after header row) in CSV file is blank"

 

Am struck at this level and unable to proceed further

4 answers

I have selected commma i.e. CSV Delimiter as ,

but still i am seeing the "Second line (after header row) in CSV file is blank" error. My second line is actually not blank

The same problem 

i am facing the same issue. Did you manage to fix the issue?

if yes, could you please help?

That usually means the second line is empty. Either it genuinely is, or you have ended the first line with something it cannot handle.

Simply just change the colon (;) to a comma (,) in the CSV Delimiter field. That should solve the problem (Don't forget to save the .csv with the acceptable column name and data.)Screen Shot 2019-03-27 at 12.58.19 PM.png

This answer is very useful.

Like gentlalaar likes this

THANKS MAN, I WAS LIKE A BOSS WHEN THE TESTS WERE IMPORTED SUCSESFULLY 

0 votes

That usually means the second line is empty.  Either it genuinely is, or you have ended the first line with something it cannot handle.

0 votes

Hi @Ragurathan Sivasubramanian,

welcome to this community.

Can you please check the csv if the second line is really not empty.

And check, which delimiter is used in the csv and make sure, that you choose that delimiter while importing the issues.

Suggest an answer

Log in or Sign up to answer
TAGS

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