How to fixed .csv file separator incompatibility in windows

csv delimeter

Note: this issue happened since windows used separator/delimeter base on your region.

  1. Select all and go to Data > Text to columns.

    text-to-column

  2. Choose delimeted and click Next

    csv-delimeted

  3. Choose what separator your region is using. In this case we will check semicolon as delimeter then click Next.

    csv-semicolon

  4. As you can see from Data Preview the semicolon converts into columns. Click Finish and save your file.

    csv-general

0
    0
    Your Cart
    Your cart is emptyReturn to Shop