# Error Import CSV

**URL:** https://forum.mautic.org/t/error-import-csv/5886
**Category:** Product Support
**Created:** [February 23, 2016, 12:22pm UTC](https://forum.mautic.org/t/error-import-csv/5886 "2016-02-23T12:22:59Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Waremidia](https://avatars.discourse-cdn.com/v4/letter/w/c67d28/32.png) [@Waremidia](https://forum.mautic.org/u/Waremidia)
#### Post date: [February 23, 2016, 12:22pm UTC](https://forum.mautic.org/t/error-import-csv/5886/1 "2016-02-23T12:22:59Z")

</div>

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)"

---

<div class="post-metadata">

### Author: ![Waremidia](https://avatars.discourse-cdn.com/v4/letter/w/c67d28/32.png) [@Waremidia](https://forum.mautic.org/u/Waremidia)
#### Post date: [February 23, 2016, 12:22pm UTC](https://forum.mautic.org/t/error-import-csv/5886/2 "2016-02-23T12:22:59Z")

</div>

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)”

---

<div class="post-metadata">

### Author: ![lewisone](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/lewisone/32/91_2.png) [@lewisone](https://forum.mautic.org/u/lewisone)
#### Post date: [June 15, 2017, 1:05pm UTC](https://forum.mautic.org/t/error-import-csv/5886/3 "2017-06-15T13:05:10Z")

</div>

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](mailto:email@email.com),  
[email@email.com](mailto:email@email.com),

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

name, \<—changed  
[email@email.com](mailto:email@email.com),  
[email@email.com](mailto:email@email.com),

This imported all the contacts perfectly.

I hope this helps.
