Community
Showing results for 
Search instead for 
Do you mean 
Reply

Excel Imports Only One Record

Copper Contributor
Posts: 126
Country: USA

Excel Imports Only One Record

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?

Copper Contributor
Posts: 126
Country: USA

Re: Excel Imports Only One Record

Anyone have any ideas? 

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Excel Imports Only One Record

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.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.