Can't export to CSV files

AkisM

Whenever I try a CSV output, the file comes out looking like this, all mushed up in the same column:

Place,Age,Address,Description,ZIP

My understanding is that if you set comma as the delimiter (which I have), there will be separated columns. Anyone knows what the issue is? I tried using dot as a delimiter too just in case, and it's the same issue (mushed up in 1 column), but instead it looks like this

Place.Age.Address.Description.ZIP

danilang

Hi @AkisM 

It looks like there are 2 ways to modify the CSV, both with drawbacks

The 1st is to use semi-colon ";" as the delimiter.  This is the default that excel looks for when a comma is used as a decimal separator.  This opens properly with "999 999,99" but opens in one column if your settings are "999,999.99" 

The 2nd is to add a an extra first row with the text "sep=," as in   

"sep=,"
Bank Account,B0008,,2018-01-14,,302,random.descrp@hotmail.com,,,EUR,33.99,Customer,C0004

adding the extra line, automatically makes the file Excel specific.  The csv format is now broken as far other programs, including Alteryx, are concerned causing errors on input 

The choice is up to you.

Of course a 3rd option is to follow @Jonathan-Sherman's sage advice and save to .xlsx if you can. 

Dan