How to import contacts into ActiveCampaign from a CSV file

Our free migration service makes it easy to move to ActiveCampaign from your old email marketing or marketing automation provider.

You never need to worry about losing contacts or automations. When you switch to ActiveCampaign, we help you get up and running fast. We will import your lists, contacts, custom fields, tags and we will recreate opt-in forms, landing pages, automation workflows, and email templates.

Migration_button.png

After creating a list, you can import contacts into your ActiveCampaign account from a CSV file using our import tool.

With the import tool, you can map columns in your file with fields in your account, create new custom contact fields to map a column to, import contacts to a list(s), apply a tag(s) to the contacts, import contacts as Active or Excluded, and choose to update existing contacts while you import. 

This article will show you how to import contacts from a CSV file.

Take note

  • The import tool only works with CSV files
    If your contacts are stored in a spreadsheet, make sure to save the spreadsheet as a CSV file before import. CSV files must also be formatted correctly. To learn more, visit "How to prepare your CSV file for importing contacts."
  • Each contact in your file must have an email address
    If multiple contacts share the same email address, we'll import the first instance in your file and skip the other contacts who share that same email address.
  • Contacts may be added to "Active" automations upon import
    Contacts will be added to automations set to "Active" if (1) the list you are adding them to is used in an automation trigger, (2) if you're tagging contacts during the import process and those tags are used in automation triggers, or (3) if you're importing values to a field and that field is used in an automation trigger. You can turn off 'Trigger Automations' in the Advanced Options of the Import Options section during the import below or you can learn how to prevent this manually.
  • It is not possible to assign an account owner during the contact import process
    If your CSV file contains an "Accounts" column, we'll assign all accounts in your file to the default account owner. To learn more, visit How to assign ownership of accounts.

Watch a video


Import contacts from a CSV file

  1. Click "Contacts" located on the left menu.
  2. Click the "Import" button.
  3. Click the "Import from File" button.
  4. A file browser will appear. Navigate to the file you wish to import and select it.
  5. Your file will process, and you will be redirected to the import screen. Map the columns in your file to fields in your account by clicking the dropdown for each field.
    • If you don't wish to import data from a column, select "Do Not Import this Field"
    • To create a new field directly from the import page, click "[Add New Field]" and follow the prompts
  6. Select Lists (Optional): Click each list that you want to add contacts to. You can add contacts to multiple lists.
  7. Add Tags (Optional): Type the tags you wish to apply to all contacts once they're imported.
    • As a best practice, you may want to apply a tag that indicates the source of these contacts. That way, you can easily find this group if you need to make any bulk edits to them later.
  8. Import Options: Click the "Import Options" dropdown and choose either:
    • Import as Contact
      This option will add the contact as subscribed to any list you have chosen in the 'Select Lists' section.
    • Import as Excluded
      This option will add your contact to your Exclusion List upon import.
  9. Optional: Click the “Update Existing Contacts” box. This will look for a matching email address in your account and add any additional contact data from your file into the contact record.
  10. Advanced Options (Optional): You can choose to leave these on their default settings or click the arrow next to Advanced Options to reveal additional settings:

    Advanced_Options_during_CSV_Import.png
    • Trigger Webhooks
      Turn off completely, no webhooks will trigger, or choose one of the following:
    • Trigger Automations
      Turn this completely on or off:
      • On - imported contacts will enter automations they can trigger, including but not limited to, Tag Added, Create/Update contact, and so on.
      • Off - the import will disregard any automations that could possibly trigger from this import and contacts will not be added to any automations.
    • Create field options when importing new custom field values
      Turn this completely on or off:
      • On - If a value is imported within a dropdown, list box, radio button, or checkbox custom field that does not match an existing field option, the import will create the option in that field. For example, you may have ‘Cat’ as a field option but it is spelled ‘Catt’ in the CSV. ‘Catt’ will be created as a new option.
      • Off - If the value imported does not match an existing field option exactly, the value will not be imported.
  11. Click the "Import Now" button once you're done configuring settings.

The length of time it takes to import contacts will depend on the size of the CSV file. 

When finished, you can view your import results

Was this article helpful?
29 out of 64 found this helpful

Have more questions? Submit a request

Start free trial