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:
| Save 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. |
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:
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:


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.
| Did 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. |
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.
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.
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.
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.
There are times when your whole import file or a contact is prevented from being uploaded into your account:
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.
If you see either error message while importing, resave your file with a CSV extension and try uploading it again.
Copyright © 2026 · All Rights Reserved · Constant Contact · Privacy Center