Change Column Separator on CSV in OpenOffice Calc

If you want to change the existing column separator or the “delimiter” of a CSV in open office, follow the easy steps :

  • open the csv in openoffice calc
  • go to file-> save as
  • opens the typical save dialog boxUntitled
  • Select the Edit Filter Settings option and click save
  • Opens up a dialog box to change all the default settings.Untitled
  • Change whatever you need and click Ok, and thats all.

Its so easy, but so much hidden with weird settings name. Hope it will be helpful for someone. Enjoy and happy coding!



Tags: , , , , , ,

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: