How to fixed .csv file separator incompatibility in windows

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

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

  2. Choose delimeted and click Next

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

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