Test JIRA, CSV export - create new line

[Johnny Young]

Hey there community, hopefully an easy one. 

I am trying to export some tests that have been created in JIRA, and the standard, action, data, and expected results are filled as necessary. 

What I after or wanting to know, is when I export to csv it is essentially 1 single line of wrapped text in excel, but my test instructions are "numbered" steps, how can I ensure we get a "new line" for each of these steps? Is it possible? What would the delimiter be if so?

E.g. when exported it currently would be; 

1 test this that 2 test some more 3 testing testing 

When I would expected it to look more like:

1 test this that 

2 test some more 

3 testing testing 

If that example makes sense... 

Many thanks in advance community... 

[Suvarna Gaikwad · Accepted solution]

@Johnny Young Can you try exporting in Excel instead? It might help for formatting I guess.

[Johnny Young]

Thanks so much for replying Suvarna! ... I would try but my only option is to export to csv, so unless I'm doing something wrong I don't have this option ☹

[Suvarna Gaikwad]

@Johnny Young Can you please tell me JIRA version you are using and probably a screenshot of options available for exporting issues?

[Johnny Young]

Thank you Suvarna, 

We are; v8.5.5#805005-sha1:a6982cf

Appreciate your response

[Suvarna Gaikwad]

@Johnny Young Thanks for the screenshot. It helped. Please follow below steps to export in Excel. I tried this in my JIRA instance and it worked.

1. Click on Issues on top Menu Bar -> Search for Issues.
2. In Advanced JQL, use JQL as below
   1. project = projectname AND type = Test
3. In Top right corner, click on Export -> Excel (All Fields)

[Johnny Young]

Wonderful thanks so much! I'll try and see how I go! Appreciate all your time!

[Aron Gombas _Midori_]

Try this in 2 steps:

1. Export to Excel with the app Better Excel Exporter. It will definitely preserve line breaks! (see the shot below)
2. Then export from Excel to CSV using its built-in feature (if CSV is your final target format) and see if it preserves the line breaks (it should).

(Disclaimer: Better Excel Exporter is developed and supported by my team.)