Skip to content

Number of columns in CSV does not match CSV format

edited November 2012 in Troubleshooting
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

Comments

  • 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.
  • Such a schoolboy. That should have been first thing I checked. Thanks!
  • You're welcome!
This discussion has been closed.