CSV file messed up

[nans]

I cannot convert my exported CSV file to a proper excel sheet. The data is mixed, so converting doesn't work. Some rows have all data in the first cell (column), some rows have data in first AND second cell..

Anyone a solution?

yaIKsZz

[nans]

OpenOffice did the trick.. Excel also did ask me what to use (comma), but it just did gave me the right results.

Thanks!!

[Textbroker]

Hi Nancy,

It looks like you're opening a comma-separated CSV with a different delimiter. My first suggestion is to see if there's a way to open the file with a comma delimiter. The delimiter is the character that tells the CSV to start a new cell or row.

If you can't find one, I'd recommend downloading OpenOffice (it's free and legit, run by Apache) and opening the file in it. The great thing about OpenOffice is that, unlike Excel, it asks what delimiter you want for your data. Choosing a comma should do the trick, and you should see the data line up correctly in the preview pane.

We have this issue in reverse -  we provide CSVs that are semi-colon separated by default. Our European customers open them easily. Our American customers need this work-around.

Good luck!