Get answers quicker by searching

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

Number of columns in CSV does not match CSV format
  • 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
  • 3 Comments
  • Vote Up0Vote Down BenBen
    Posts: 3,507Sendy support
    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!
  • Vote Up0Vote Down BenBen
    Posts: 3,507Sendy support
    You're welcome!
This discussion has been closed.
All Discussions