I had a question recently concerning the opening of CSV files in OpenOffice.
Sometimes when we open CSV files, they open in Calc by default, and the Text Import window doesn’t appear.
If this is the case for you, and the data is not being sorted into columns in a format you are happy with, then close the file and go to File >> Open.
Then select the CSV file and the following window should open.
Under “separator options” select the characters, tabs or other delimiters used to separate columns in your data.
You can fiddle with this so that you can see the output at the bottom of this window.