Lead Gen & CRM
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.

Importing Double Opt-In Lists

Article: 000050469
Updated: October 31, 2024

Maintaining a quality email list is vital to the success of your marketing campaigns. Lead Gen & CRM lets you import your existing double opt-in list as a .CSV file that by including an IsOptedIn column.


Users:
Administrators 
Company Managers 
Marketing Managers 
Sales Managers 
Salespersons  
Jr. Salespersons  

Important Information Regarding Imports

The Import Tool uses information from .CSV files and creates contact lists from this information. These files contain only alphanumeric data and are presented in a table format.

Any .CSV file that you import should be structured similar to the following:
 

First NameLast NameEmailIs Unsubscribed
GalileoGalileig@polymath.com

0

Edwin Hubblespace@extragalatic.com

0

Hipparchus math@trig.com

1


When importing .CSV files, be aware of the following:

  • Header rows are required. Header rows are necessary for mapping Lead Gen & CRM fields to imported fields.
  • Email fields are required. The Import Tool requires that your .CSV file contain a column mapped to the Email field. You will still need to include the Email column when a contact does not have an email address. 
  • Is Unsubscribed fields are required. For Lead Gen & CRM to successfully import a .CSV file, the file needs one column header that is labeled as Is Unsubscribed. The Is Unsubscribed field should be a boolean field, where 0 is for leads who are opted in, and 1 is for leads who are not opted in.
  • Utilize first and last names. For the import to be successful, a first and last name are suggested in the event that you do not have an email address for that contact. Use both as often as possible.
  • Values must match. When importing custom field values, ensure that they are formatted to match the custom field values. For example, picklist and checkbox values are case-sensitive.
  • When importing data with picklist and checkbox fields, the fields must be present in the file import in order to appear. Ensure that the picklist or checkbox fields in your file exist before importing. Otherwise, the data may not import properly.
  • When importing to a checkbox custom field, the data cannot have spaces between values and commas. An example of this would be value1,value2,value3. 


Creating Files

Double opt-in lists require .CSV files.

To create a double opt-in list .CSV file, do the following:

  1. Create a .CSV file in Unicode with all of your contacts.
  2. Include a column titled isOptedIn in your .CSV file.
  3. Set the isOptedIn field value for list members.
  4. Enter relevant contact information in the .CSV file.
  5. Save your .CSV file.

    Excel Spreadsheet

     

Note: The isOptedIn field should be a boolean field, where 1 is for leads who are opted in, and 0 is for leads who are not opted in.

 



Importing Lists

Once you have created the .CSV file, you can import the list.

To import a double opt-in list, do the following:

  1. Click Contacts in the left toolbar.
  2. Click  12more.png  Options > Import Contacts.

    Importing double opt in lists

     

  3. Scroll to the bottom of the Import Tool page.
  4. Select the appropriate delimiter from the Select delimiter drop-down menu.
  5. Select the appropriate date format from the Select date format drop-down menu.
  6. Select the appropriate time format from the Select time format drop-down menu.
  7. Click Choose a File. Choose the applicable .CSV file. 
  8. Click Upload .CSV File.

    Importing double opt in lists

     



Creating New Lists

You can create double opt-in lists from imported .CSV files.

To create new lists, Import a double opt-in .CSV file and do the following:

  1. Select the New List radio button in Import Contacts List Settings.
  2. Enter a list name. 
  3. Select the appropriate option from the drop-down menu in the How Should We Handle Duplicates? section.

    Importing Double Opt in Lists

     

  4. Select one of the following in the 
    Import New Leads in List As... drop-down menu:
    • Open
    • Unqualified Leads
    • Qualified Leads
    • Contacts
    • Customers

    Importing Double Opt in Lists

     

  5. Optionally, do the following:
    • Click the Assign to a campaign? box
    • In the drop-down menu that appears, select the desired campaign
  6. Optionally, do the following:
    • Click the Assign leads to a particular user? box
    • In the drop-down menu that appears, select the desired user

    Importing Double Opt in Lists

     

  7. Locate Opted-In in .CSV Columns. Type Is Opted In into the text box.
  8. Click Import.

    Importing Double Opt in Lists

     

  9. Type Confirm.
  10. Click the I confirm that my unsubscribed contacts are mapped correctly and that this list is not purchased checkbox.
  11. Click Import.

    Importing

     

Note: Do not click the Make Custom Field checkbox.

The import may take a few minutes to process, depending on size.
 



Updating Existing Lists

You can update an existing list to include double opt-in data from a .CSV file.

To update lists, Import a double opt-in .CSV file and do the following:

  1. Select the Use Existing List radio button in Import Contacts List Settings.
  2. Select an existing list.
  3. Select the appropriate option from the drop-down menu in the How Should We Handle Duplicates? section. 
  4. Select one of the following in the Import New Leads in List As... drop-down menu:
    • Open
    • Unqualified Leads
    • Qualified Leads
    • Contacts
    • Customers

    Importing Double Opt In Lists

     

  5. Optionally, do the following:
    • Click the Assign to a campaign? box
    • In the drop-down menu that appears, select the desired campaign
  6. Optionally, do the following:
    • Click the Assign leads to a particular user? box
    • In the drop-down menu that appears, select the desired user

    Importing Double Opt In Lists

     

  7. Locate Opted-In in .CSV Columns. Type Is Opted In into the text box.
  8. Click Import.

    Importing Double Opt in Lists

     

  9. Type Confirm.
  10. Click the I confirm that my unsubscribed contacts are mapped correctly and that this list is not purchased checkbox.
  11. Click Import.

    Importing Double Opt in Lists

     

Note: Do not click the Make Custom Field checkbox. The import may take a few minutes to process, depending on size.
 



Import Completion Statuses

When the import is completed, the following will occur:

check.pngWhen the import has completed, any lead that had isOptedIn =1 will have a green checkmark under the Explicitly Opted-In column.

thumbs.png The Opt-in Status will also display on the contact or lead record to the right of the name.

OptedInToReceiveEmail.png The opt-in event will display on the Life of the Lead

 


Did this article answer your question?


Constant Contact Logo

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