How do you open this
If you just choose File > Open, a text file will open in Writer.
Here's how to open it as a spreadsheet.
Choose File > Open.
In the File Type list, select Text CSV. The easiest thing is to click in the file type list and type T four times.
Then select the file you want and click Open.
You'll see this window. It might not look right at first.
So be sure to select the right delimiter (and deselect the wrong ones) in the Separated By section.
If it's a fixed-width file, select Fixed Width then drag the field separator to the right spots.
Click OK. You'll see the file in spreadsheet format.