Ask Your Question

problems with saving csv file [closed]

asked 2014-05-23 15:09:42 +0200

Alexdep gravatar image

I have no problems with open an original .csv file, but when I change the file and save or save as It and re-open it, it will be open corrupt. I try many thinks, but is doesn't work. This problem I have never before with LibreOffice, do I something wrong?

I hope sombody could help me.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-23 11:59:38.932273

1 Answer

Sort by » oldest newest most voted

answered 2014-05-23 17:02:46 +0200

Pedro gravatar image

updated 2014-05-23 17:04:29 +0200

The problem is possibly related to the Field Delimiter used in the original file and the delimiter used by LO when you save after changes (unfortunately LO is not smart enough to keep the same delimiter ).

What you need to do is open an original file in Notepad, take note of the Field Delimiter used (e.g. Tab) and then in LibreOffice instead of Save do Save As > Text CSV (.csv), check the "Edit filter settings" box and then in the Export Text File dialog, make sure you use the same delimiters as the original file


edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-05-23 15:09:42 +0200

Seen: 882 times

Last updated: May 23 '14