Email and Digital Marketing
How can we help you?
Search our help articles, video tutorials, and quickstart guides

You've got this. You've got us. Search our Knowledge Base to quickly find answers to your questions.

Resolve warning and error messages after importing contacts

Article: 000006400
Updated: November 11, 2026

Understand and resolve the different error or warning messages that can happen after importing a file of contacts

Checking your Activity page after you import a spreadsheet of contacts lets you know if there are any errors that occurred during the upload. We can help you understand the different types of errors and warnings so you can fix them:

 

Clock IconSave time: To ensure your file is formatted correctly from the start, you can download a CSV file that's pre-formatted for you. Click Contacts in the left-hand menu, click Add contacts > Upload from file, and then click the "Download an example file" link at the bottom of the Import contacts page.

 


Errors that allow file import but prevent contacts from being added

Typos and formatting errors:

Typos happen, and when they do, we don't prevent your whole file from being uploaded. Review your errors carefully for typos that are easy to miss! Supported formats for each contact heading and custom field can be found here:

 

Here are some examples of common typos that cause import errors:

  • An email address that's missing the @ symbol, like jsmithyahoo.com
  • An email address with invalid or non-printable characters, like jsmith□yahoo.com
  • An email address with a comma following it, like jsmith@yahoo.com,
  • An email address with spaces, like j smith@yahoo.com or jsmith@ya hoo.com
  • An email address that is missing the domain, like jsmith.com instead of jsmith@yahoo.com
  • An email address with more than 3 characters after the last dot, like jsmth@yahoo.comm
  • An email address with more than 80 characters
  • Mismatched North American state/province and country values, like Mass instead of MA, or FLA instead of FL
  • A birthday or anniversary date with an unsupported format
  • A missing SMS messaging consent date or an SMS messaging consent date with an unsupported format
  • A missing SMS messaging number or an SMS messaging number with an unsupported format

 

Once these types of errors are resolved, the affected contacts are imported into your account and added to the list you chose when you started the import process. Here's how to resolve these types of errors:

  1. From the Contacts page, click the button with the three dots in the upper right-hand corner, and select the "View import errors" option from the drop-down menu.

    Contact page with expanded overflow menu and View import errors option selected

  2. Fix the errors in red, using the formatting information below the error to help you.
    Important: Clicking the Delete All Errors button at the top of the table deletes all the contacts with errors and prevents them from being uploaded. Contacts without errors are imported as intended.
  3. (Optional) Click "Remove Field" to remove the field from the contact record. If you remove an email address from and email-only contact or an SMS number from an SMS messaging-only contact, it prevents the contact from being imported.

    Contact import errors page with multiple list uploads, Multiple error email and SMS errors with description of error, and Remove Field link, and Delete all errors button

 

Missing email addresses or SMS messaging information (email-only or SMS messaging-only contacts)

A contact must have either an email address or an SMS messaging phone number. A missing email address prevents a contact from being uploaded if they also don't have SMS messaging information, and missing SMS messaging number prevents a contact from being uploaded if they also don't have an email address.

If the information is missing from a handful of contacts in your file, only the impacted contacts are prevented from being uploaded. You can manually create a new contact with missing information later, but if you have lots of contacts with missing information, first check to make sure the column of your spreadsheet has the correct header or add the missing email addresses or SMS messaging information, and then import your file again.

 

Warnings that allow import and don't prevent contacts from being added

Light Bulb IconDid you know? When you re-import a file of contacts, existing contacts are updated when the email address in the updated file matches the email address on file in your Constant Contact account. New contacts are only created when the email address does not already exist in your account.

 

Character limits

Contact fields in Constant Contact have a character limit that dictates how much information can be stored there. When fields containing more than 50 characters are imported, those fields are automatically cut off, or truncated, and a warning is included on your Activity Page.

  • If a physical mailing address is more than 50 characters long, we recommend splitting it between "Address line 1" and "Address line 2". You can do this in your contact file, then re-upload it into your account. Any contact with a truncated address is updated to show the complete information.
  • If the first and last names are in one column of your spreadsheet, you can separate them into two columns before re-importing it.

 

Importing unsubscribed contacts

Our contact management system keeps track of unsubscribed contacts, even if you delete them from your account. If you upload a spreadsheet with contacts that have previously unsubscribed, they're still added to your list, but remain in the "unsubscribed" status and you're unable to email them.

 

Missing email or SMS messaging information (email and SMS messaging contacts)

Before you can send emails to a contact, they must have an email address on file. If you're missing the email address for a contact when you import your list, or if you remove the fidle to resolve an error, your contact is added as SMS-only.

  • If you fix the errors in your spreadsheet and re-import it with a properly formatted email address, you contacts is also updated and eligible for email.

 

Before you can send SMS messages to a contact, they must have both a valid SMS number and SMS consent date on file. If you're missing the SMS messaging number or SMS consent date for a contact when you import your list, or if you remove the field to resolve an error, your contact is added as email-only.

  • If you fix the errors in your spreadsheet and re-import it with a properly formatted SMS consent date and SMS number, your contact is also updated and eligible for SMS messaging.

 

Errors that prevent file or contact import

There are times when your whole import file or a contact is prevented from being uploaded into your account:

 

Importing an incompatible file type

Not all file types are compatible for importing into your Constant Contact account. To prevent errors, check your file type and make sure it's a CSV, TXT, XLS, XLSX, VCF file, or Google Sheet, and make sure the file is formatted correctly.

 

Internal Server Error 500 message or Requested Operation Failed

If you see either error message while importing, resave your file with a CSV extension and try uploading it again.

 


Questions?

Ask the Community

Did this article answer your question?


Constant Contact Logo

Copyright © 2026 · All Rights Reserved · Constant Contact · Privacy Center