Posts Tagged ‘calc’

Change Column Separator on CSV in OpenOffice Calc

August 3, 2017

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!



%d bloggers like this: