Multiple columns csv data are imported as a single column.

1 posts
tulgaerdene's profile image tulgaerdene posted 3 years ago in General Permalink

I have a CSV file that has 6 columns such as Phone, Source, Leadtype, Email, Date, State. When I import this CSV into a new table, all columns are imported as a single column. I attached the screens of CSV, Dialog, Result.

3 attachment(s):
  • 2022-01-11_18-48-18
  • 2022-01-11_18-48-32
  • 2022-01-11_18-49-54
10429 posts
ansgar's profile image ansgar posted 3 years ago Permalink

You are using the CSV layout detection with a wrong field terminator: you specified semicolon ";" while the file seems to use comma ",".

Please login to leave a reply, or register at first.