I could not open the .csv files from my bank. For some reason Libre Office did not get the correct file format. So I opened the file in gedit. The formatting looked all right. Then I tried a save as - and then the problem became obvious.
The image above demonstrates the problem. The file was exported as a iso-something file with Windows new-lines.
- Open the file in an editor.
- Choose save as
- Save as utf-8 with linux/unix new-lines
Then it's possible to open the file in Libre Office & friends.