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 box
• Select the Edit Filter Settings option and click save
• Opens up a dialog box to change all the default settings.
• 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: calc, change column separator, change delimiter, column separator, csv, delimiter, OpenOffice