How can I make an export of stories in JIRA using CSV, current fields and then semicolon; ?

[Marije Suvaal]

How can I make an export of stories using CSV, current fields and then semicolon (;) ? I cannot find the option to choose semicolon. When I make an export to Excel, I only get all the informatie provided bij my default settings in one colon. That's not what I need. Can anybody explain how to export CSV, current field, semicolon (;)? 

[C_ Derek Fields]

@Marije Suvaal Welcome to the community.

The export will always be Comma Separated. When you open in Excel, it should automatically recognize the format and separate into columns.

If that isn't happening, then you need to check whether you have updated the settings in Excel to use something other than a comma as the field delimiter. 

If this doesn't help, I suggest posting the first 2-3 lines of your export so that we can see what is shown. You can open the export file in a regular text editor to see what the raw file looks like before Excel imports it. It should look something like this:

Column Name 1,Column Name 2,Column Name 3
"Value in first column",42, john@example.com
"Second value",57,sally@example.com