CSV not properly shown

[JarnoNijzing]

When i download a csv i get just one colum with every information in it...

which makes it unreadable.. any suggestions for this unlogical problem?

[mad2k]

I got the same problem couple a weeks ago and I change a file extension to txt and next open in spreadsheet and  I've got a good structure.

maybe it will help you

[donford]

Is it possible to just use Excel's data tab "Text To Columns" and split the data on commas or whatever the delimiter is?

I haven't had this issue before but that may help with the CSV if you use Excel.

[mad2k]

sorry donford I'm mac user but I've notice on other computer with MS system and and brand new ms office that when opens csv it exchanges e.g. 459/2011 (agreement no/year) to date. Nobody could supply me a solution for this issue, so I added a space before the number and now I read it as text

MS in his save the world mission sometimes add features that are not really helpful

[berget]

I am still struggling with this. I am using Numbers on my Mac, and I have tried to change the file extension to txt, but I'm still seeing everything in one column.