How to separate your CSV columns (Open Office) by semicolon

Latest update: - George Cavalevu


Formatting your CSV file that uses a semicolon to separate values.


  • Vend for Mac or PC 
  • Open Office for Mac or PC


  1. Open CSV in Open Office
  2. In the formatting window, check the following:
    • Character Set: Unicode (UTF - 8)
    • Language: English 
    • Other options: Quoted field as text
  3. Set Separator options to:
    • Separated by: Semicolons


Additional Information

Formatting your CSV File using Open Office 

Powered by Zendesk