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:

A,B,C

D,E,F

G,H,I

(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.