Ask Your Question

Revision history [back]

I had the same problem. If I just start Calc & do file > open and name the .csv file, calc produces something very strange. Here is a sample file:




(the extra line spacing is an artefact of the forum software). Calc produces a single cell that looks like this:


Excel reads the same file correctly.

Thank you ve3oat for your reply. When I did what you said: select the text from the .csv file & copy & paste into calc, it gets read correctly.