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


Latest update: - George Cavalevu

Objective

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

Setup

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

Steps

  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

Image_2018-11-13_at_10.58.56_AM.png

Additional Information

Formatting your CSV File using Open Office 

Powered by Zendesk