Number of columns in CSV does not match CSV format

alexbuckland

I'm having trouble importing a csv into a list with custom fields. This is the error I get
Number of columns in CSV does not match CSV format example (as shown below).

Everything seems as it should in the csv but I'm getting this error no matter what I try.

Ben, I've sent you a PM with a link to the file. Im running latest version 1.1.1.3

Ben

Hey Alex, I just checked the CSV. Some columns have 'commas' in them.

As each column in the CSV is comma separated, having 'commas' in any columns will result in an increase in the total column count, that's why you get the error 'Number of columns in CSV does not match CSV format example'.

There are 6 entries in your CSV that contains a comma in one of the columns, I have replaced it with a dash. Now it can be imported. I'll PM you the CSV.

Thanks.

alexbuckland

Such a schoolboy. That should have been first thing I checked. Thanks!

Ben

You're welcome!