Excel Imports Only One Record

[Jillian Trish]

Using ACT Premium 2012, Excel 2010. 

Duplicate Checking enabled, match on field C-email.  When I begin the import it reads 307 records (correct).  For Contact Options, I have selected MERGE if records match, and ADD if records do not match.  When I complete the import, it has only imported one record, which is the third line of the spreadsheet.  There are only three fields on the import.  What am I missing?

[Jillian Trish]

Anyone have any ideas? 

[ghollister]

A couple of things:
- Make sure there are no empty rows in your spreadsheet
- Add the Contact name field to your duplicate checking

Also, what does the import log say? Click the import log link on the finish screen of the import wizard to view this.

Remember, the "merge" option will not add any records if duplicates are found - only add data to empty fields for that you have mapped for duplicate contacts.