Uploading contact error

The contacts I imported have a column from excel titled "cell phone number" however none of the numbers imported at all. How can I ensure they import correctly?


3 replies
Best reply by Chris S

Hi ShanelleJ7.

I'm sorry to hear those numbers didn't pull through. We do have a step by step article to help out https://knowledgebase.constantcontact.com/email-digital-marketing/tutorials/KnowledgeBase/53003-Import-a-file-of-email-or-SMS-contacts?lang=en_US

Since SMS numbers are treated like email addresses (meaning they must be a unique identifier for each contact), the system is very strict about what it accepts. The issue is likely coming from one of these two areas:

1. Duplicates & Conflicts

  • If a phone number in your spreadsheet is already assigned to a different contact in your account, the system won't import it to avoid merging the wrong people.

  • If the same number appears more than once in your spreadsheet, the system may skip them.

2. Formatting

  • Ensure all numbers are US-based; international numbers will not import for SMS.

  • Check that the numbers are formatted consistently throughout the column.

I recommend doing a quick export of your current SMS contacts from Constant Contact and comparing it to your spreadsheet. Remove anyone from your upload file who is already in your account, and double-check that there are no duplicate numbers listed in the file itself.

Let us know if that helps clear it up!

View original

Popular Posts:

The world's largest virtual email marketing conference. November 12-13th.