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

Question

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 (;)?

Rade Radumilo · Answer

The problem is that in my corner of the world, MS Excel uses smicolon as a list separator. That's because in our language comma is the decimal separator. 
When Windows and Office are set to our language, the use of these characters is as follows:

1. Comma - decimal separator.

2. Semicolon - list separator.

3. Full stop - thousand separator.

Export from JIRA can't be opened from MS Excel directly. It has to be run through data import wizzard.

I can't believe that a software solution that elaborate as JIRA doesn't support such a simple feature as configuring a CSV separator.

Derek Fields _RightStar_ · Answer

@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