We're making it easier to get around Constant Contact with a brand new left navigation. Not all accounts have that change yet, so if your navigation looks different from our articles, that's why–but everything from the top can now be found on the left!

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.

Format a file before importing a contact list into Constant Contact

Article: 000005297
Updated: September 24, 2024

Check that a contact list is in a compatible file type and is formatted correctly to prevent import errors when uploading to Constant Contact

Before you import a file of contacts into Constant Contact, it's a good idea to make sure you have the right file type and that the data is formatted correctly. To ensure all contacts get imported, each one needs at least an email address.

 

Light Bulb IconDid You Know? Not all errors prevent your file from being imported. After you upload a spreadsheet of contacts, you can check for errors that are keeping contacts from being added to your list, and correct them if you have any.

 


Compatible file types

The following file types are compatible for upload into Constant Contact:

  • .XLS (Microsoft Excel)
  • .XLSX (Microsoft Excel open format)
  • .CSV (Microsoft Excel, Open Office Calc, Google Spreadsheets)
  • .VCF (vCard electronic business card)
  • .TXT (Microsoft Notepad)

If your list is saved in a different file type, copy the data into a new sheet and use the "Save as type" drop-down menu to choose one of the compatible file types.

 

File organization

To prevent file import errors, there are a couple of things to look for before uploading your file:

  • Email addresses - Each contact is required to have an email address. Contacts without an email address won't be imported into Constant Contact.
  • Column headings - Column headings make it easier for our system to match your information onto the corresponding contact fields. Each column in your spreadsheet needs a unique label. Labeling your headings to match our standard contact fields or creating your own custom fields ahead of time makes the import process go more smoothly. If you don't use column headings, you'll need to label each column manually before the file can be fully imported.
  • Hidden fields - Hidden fields in your spreadsheet can cause errors when we try to process the information. Show all fields, or delete the fields you don't want imported.
  • Blank first row - Make sure that the first row of your spreadsheet or file isn't left blank.
  • Multiple worksheets - If you've got information on multiple worksheets (or tabs), make sure you consolidate it into the first worksheet and delete the extras. 
  • Special characters or extra spaces - Special characters or extra spaces in the middle of an email address won't prevent you from uploading your contact list, but you have to remove them before you can finish uploading the affected contacts.
  • Tags - In order to import a contact list that includes a column for tags, you have to create the tags in your account first. If you have new tags included in your spreadsheet, they're ignored during the import process.
  • Data generated by a formula - Data in a cell that is generated through a formula won't import correctly. If you're using formulas, please convert them to values before importing.

File headings, email addresses, contact names, and any other content in your file isn't case sensitive when you import it. Names that start with lower-case letters won't be auto-corrected and are imported exactly as you have them in your spreadsheet.

 

Spreadsheet (.XLS, .XLSX, .CSV, .VCF) example

  • Each contact should have its own row.
  • Each column should include a single piece of information. For example, don't combine First Name and Last Name into the same column. Columns with multiple pieces of contact information can be split from one cell into two manually.

    Formatted Spreadsheet
     

 

Text File (.TXT) example

  • The first line should be the column headings.
  • Following the headings, each contact should have its own line.
  • Different types of information should be separated by tabs. Don't worry if the information doesn't line up as nicely as it does in a spreadsheet.

    Formatted Text File
     

 

File name

Using Special Characters in your file name can prevent the file from importing. The most common culprits are:

  • -
  • ~
  • !
  • &
  • %
  • $
  • #
  • *
  • (  )
  • Spaces

To separate words or format dates in your file name, use an underscore. For example: new_clients_2021

 

File size

For Excel spreadsheets, Text files, or vCards, the largest file size that can be imported into your Constant Contact account is 2mb, and it can't have more than 40,000 rows of data.

Exclamation Point IconImportant: Excel spreadsheets with more than 40,000 contacts can cause import errors. If you have a large Excel file, convert it to a CSV file or split it into separate files before importing. You can combine the separate XLS/XLSX files again by adding them to the same list during the import process.

 

Large list customers:

For CSV files, you can import files with up to 1 million contacts or up to 100mb of data if your account is enabled. 

Clock IconSave time: If your list is large, we can help you import it. Please contact premiersupport@constantcontact.com and provide the following information:
  • Your account username.
  • A phone number where we can reach you if we have questions.
  • The contact spreadsheets that you want to import.
  • The names of the lists you want to add the contacts to.
We will contact you within 48 hours, during our regular business hours (Monday to Friday9 a.m. - 8 p.m., EST), after receiving your request.

 

Any links we provide from non-Constant Contact sites or information about non-Constant Contact products or services are provided as a courtesy and should not be construed as an endorsement by Constant Contact.


Questions?

Ask the Community

Did this article answer your question?


Constant Contact Logo

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