02 November, 2014

CSV import problem



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.

Recipe:

  1. Open the file in an editor.
  2. Choose save as
  3. Save as utf-8 with linux/unix new-lines
Then it's possible to open the file in Libre Office & friends.