There are no carriage return/line feeds in the file.
Everything is separated by commas and commas alone.
So you will indeed end up with one long row.

Suggest you recreate the text file and save the file as csv format rather than txt.