Mautic Community Forums

Error Import CSV


I'm the Next Error importing CSV lead contacts

1 created , merged 0 , 5790 ignored

ERROR

"The number of data columns is more than the number of columns header ( the first row)"

I’m the Next Error importing CSV lead contacts

1 created , merged 0 , 5790 ignored

ERROR

“The number of data columns is more than the number of columns header ( the first row)”

Hopefully you figured this out before a year later, but Here is what I figured out to solve this.

I noticed on my csv file that my header was named and in the file had a few commas after the email like this:

name
email@email.com,
email@email.com,

So I added comas after my header like this as a placeholder for the missing information

name, <—changed
email@email.com,
email@email.com,

This imported all the contacts perfectly.

I hope this helps.