ah, I always go half the distance. I never thought of looking in 'Help'.
I assumed openoffice couldn't read .csv format.
To Open a Text CSV File in Calc
1. Choose File - Open.
2. Locate the CSV file that you want to open.
If the file has a *.csv extension, select the file.
If the CSV file has another extension, select the file, and then select "Text CSV" in the File type box
3. Click Open.
The Text Import dialog opens.
4. Specify the options to divide the text in the file into columns.
You can preview the layout of the imported data at the bottom of the Text Import dialog.
I was a bit confused by section 4, as I didn't see 'columns' but did see 'comas' and chose that. It looks fine now. A much better solution! Thanks, atolboo!
Regards, Lisa Marie