We all started somewhere! Share your experience on the Get Advice: Let's Get Started Sweepstakes thread and be entered to win a $100 credit on your Constant Contact account.

Uploading Contacts from Excel File

SOLVED
Go to solution
PlasterC9
Occasional Participant

Uploading Contacts from Excel File

Sometimes I upload lists that are greater that 200 and constant contact will only import 63 or so of the contacts. I've also saved multiple files to eliminate columns, but constant contact still have the additional columns that I've deleted from the excel file.
1 ACCEPTED SOLUTION
William_D
Moderator

Hello @PlasterC9 ,

 

Can you confirm that all the contacts have an email address, and that there are no duplicates? Can you also confirm if they are all 100% brand new contacts, and not contacts that already exist in your account? Do you only have one column devoted to email addresses? 

 

Unless you explicitly DELETE the column in whatever program you use for your spreadsheet, the file will still contain "blank" data for previously-filled cells, which will then force our system to read. If you're having trouble truly deleting the empty cells, you can copy-paste the cells with actual info into a fresh file, and that will generally cause the program to not recognize the empty cells when saving your file.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William D
Community & Social Media Support
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Did I answer your question? If so, please mark my post as an "Accepted Solution" by clicking the Accept as Solution button in the bottom right hand corner of this post.

Anyone can be a marketer! Visit our Blog & Resources page to brush up on the latest tips and tricks.

View solution in original post

3 REPLIES 3
William_D
Moderator

Hello @PlasterC9 ,

 

Can you confirm that all the contacts have an email address, and that there are no duplicates? Can you also confirm if they are all 100% brand new contacts, and not contacts that already exist in your account? Do you only have one column devoted to email addresses? 

 

Unless you explicitly DELETE the column in whatever program you use for your spreadsheet, the file will still contain "blank" data for previously-filled cells, which will then force our system to read. If you're having trouble truly deleting the empty cells, you can copy-paste the cells with actual info into a fresh file, and that will generally cause the program to not recognize the empty cells when saving your file.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William D
Community & Social Media Support
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Did I answer your question? If so, please mark my post as an "Accepted Solution" by clicking the Accept as Solution button in the bottom right hand corner of this post.

Anyone can be a marketer! Visit our Blog & Resources page to brush up on the latest tips and tricks.

View solution in original post

PlasterC9
Occasional Participant

Thanks so much, I had to delete the columns that I didn't want (in excel), and then copy the information into a new sheet, as suggested. After that, the contacts and all pulled just fine. 

Glad to hear it. If you run into any other issues while uploading contacts from a file, our phone general support teams can work with you to securely receive the file and perform live troubleshooting with the file copy. Have a good day!


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William D
Community & Social Media Support
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Did I answer your question? If so, please mark my post as an "Accepted Solution" by clicking the Accept as Solution button in the bottom right hand corner of this post.

Anyone can be a marketer! Visit our Blog & Resources page to brush up on the latest tips and tricks.