Import contacts

This article applies to:

Import your csv, xlsx, and xls files

Before you import, make sure that your data is in csv, xlsx, or xls file format and that they have been properly prepared.

  1. Click Contacts from the navigation menu
  2. Click the Import button
  3. Select import type
  4. For a CSV file either click to upload or simply drag your file and drop into the Import window
    Click to view large
  5. For an Excel file (xls or xlsx) spreadsheet with multiple tabs, you can indicate the one you want to import. Note that you can't add multiple tabs of data at once.

Your post-import contact count

The post-import displays the total count of existing contacts in your Keap app against the threshold of contacts allowed in your current contact package.

Mapping fields

Fields will automatically map to your Keap fields. However, if there are fields that cannot be matched match the Keap fields on the right to your CSV file columns on the left. 

Click the "Show matched fields" link at the bottom of the screen to view the auto matched fields

See sample data below CSV field on left side of field mapping pair

CSV File display

In the top left corner of the field-mapping screen, it will display the name of the uploaded CSV file. Use this as a reference for what file you are working while matching fields.


Keap checks existing company records to prevent duplicate items. 

Companies are not case sensitive, so contacts with companies of "keap", "Keap", and "KEAP" will all be imported under one company record. If the company does not yet exist in your CRM, the first instance of the company will determine the case used by Keap and can be edited.

Keap also disregards any spaces before or after company names when importing information, which means " Keap" and "Keap " are treated as the same company.

Custom fields

Create custom fields on the field mapping screen

  1. Click the Create custom fields option in the drop down menu
  2. The name of the header in the CSV will automatically be added as the name of the custom field
  3. Text will default field type
  4. Click the drop down to select your field type
  5. Click "Save"
    The custom field is created and the data in the CSV will auto map to that field when the import is completed.

  6. Click "Next" at the top right


  • Duplicate contact checking is based on the contact's email address and will happen automatically; contacts with the same email address will not get imported twice.
  • Contact info is updated/replaced when importing CSVs with an existing email address
  • You can locate a drop down item in field mapping by typing the word of the field that you want to map i.e. You want to quickly find "tags" you can start typing it with the drop down open and will be taken to that part of the list.

Indicate permission

The last step is to indicate if you have Explicit permission to send marketing emails.

  • If you do have permission check Yes (Make sure to review the Acceptable Use Policy)
  • If you do not have permission check No  (You can send emails directly through the contact record but wouldn't be able to send bulk emails from an Email Broadcast or automation sequence) until your contact opts in.

Add tag(s)

You can automatically tag contacts upon import by either choosing:

  1. An existing tag
  2. Or creating a new one on-the-fly
  3. Click Finish Import when you're done

You can also use a Tags column in your spreadsheet to create new tags. Be careful: any column imported as a tag without commas separating the values will result in incorrect tag names.

View import

Click the View contacts to pull up your imported list of contacts

Pro-Tip! By clicking "View contacts" you can then quickly send a broadcast or add to an automation. To learn more, click here

Update contacts

You can use our import tool to update multiple existing contacts already in your application based on their email. To update your contacts, create a .csv, .xlsx, or .xls  that includes the contact's email and any other information you wish to update, then import the file as normal.