This just started happening recently and happens to old files that used to work correctly. I did notice that older files had commas in the correct place when opened in Notepad, but newer files have a comma after every word.
There is not “columns” in a .csv type file.There are “separator characters” only.
You can set the actual separator character at Import and Export of the .csv file.
The name CSV means: Comma (Character) Separated Values.
The usual separator characters would be one of the: Comma, TAB, Space, Semicolon, and maybe others)
But you can not use Spaces in the values when the Separator is the Space. (Or you can not use the Space as separator, when the values contain Spaces): Any software can not distinguish between the two function of the same space characters.
In the dialog you get for import check wich separators are set AND check the option for other charters to the right. If you have an invisible Space here allowed as separator a csv would be imported as you describes - and Calc remembers last settings.
PS:
With additional quoting “aaa bbb” would be possible, but his file has obviously no quotes.
… or the proper quotation mark is not defined in import options.
As long as the OP shows nothing but a […] screenshot out of calc, we can only guess about the real content of the .csv file.
@Jaytee123: Attach a csv (plain-text file) consisting of the first 5 lines of your actual source,… You can split it off the source using notepad, e.g, without any additional editing. (Save under a different name!!)
Having that sample at hand, everybody here can tell you what you need to do.
The new files have invalid headers. Skip the first row.
