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

[Ragurathan Sivasubramanian]

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

[Kool Test]

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.)

[Sofia David]

This answer is very useful.

[gentlalaar]

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

[Shaji A]

Dear Team , 

I faced the same issue while importing my test cases into Jira from csv file , I got below errors

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

2) "Line 957 is invalid, it should contain 2 values instead of 40"

Cause of above errors would be multiple reason , but cause of the my issue is below.

Cause: My CSV file has unwanted "Alt + Enter" (Line breaks) [Single excel box has multiple lines]

Solution: All "line breaks" need to be removed from the CSV file , manually removing this line breaks is almost impossible , we can remove this line breaks easily by using "Find and Replace" option ( Ctrl+F) 

In the Find What field, enter Ctrl+J. It will look empty, but you will see a tiny dot.

In the Replace With field, leave empty. then press replace all 

this will remove the all line breaks from your csv file , now try the import test from saved csv file, it will be successful if your cause of the issue same as mine .

Vote me if it is helped you.

Thank you , 

Shaji A (Shaji Ayyappan)

[MubarakBitbuket]

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

[Vatlav Mihailevski]

The same problem 

[Gagandeep.Garha]

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

if yes, could you please help?

[Nic Brough -Adaptavist-]

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

[Nic Brough -Adaptavist-]

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

[Bastian Stehmann]

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.