The contacts importer tool gives you the option to upload a comma-separated value (CSV) file with multiple custom data fields, copy and paste contacts from a spreadsheet, or type info directly into the import table. In this article, you'll learn how to use our import tool to add and update contacts on Kajabi.
In this article:
Import File Requirements Overview
The Kajabi Contact Importer tool uses intelligent column mapping.
In other words, Kajabi will recognize column headers in your .CSV file and then organize the data accordingly. This allows you to upload your contacts with up to 25 data fields and up to 100 tags per upload. Yes, that's right... 100 tags per upload!
But, in order for the intelligent mapping to do its thing, you will need to prepare your .CSV file for import.
To prepare a downloaded .CSV file from a third-party CRM for Importing
For the Kajabi Contact Importer to organize your contacts' data best, it is critical to label the column headings in the first row of the spreadsheet.
For the best results, start with Email Address, followed by Name, and then the other fields you would like to retrieve.
Keep in mind the maximum number of Header Fields Kajabi can import is 20.
To prepare a blank .CSV file for importing:
- Get started by opening an existing .CSV file or a blank worksheet in a spreadsheet application like Google Sheets or Excel. Or, feel free to download this template!
- Create and label a column in the first row. We recommend naming the first column Email Address:
-
In the next column of the same row, create and name additional columns, such as; First Name, Last Name, and other information fields you would like to import to Kajabi:
-
Then, paste the contact information into the relevant cells in the spreadsheet:
Import Your Contacts to Kajabi
To import your contacts to Kajabi using the contact Importer:
- Click on the People tab from the Dashboard.
- From the People Manager dashboard, click the + Import Contacts button in the top right of the page.
- Then choose how you would like to import your contacts:
Upload File
- Click Upload File and select your prepared .CSV file into the file picker.
Copy/Paste from File
- Click Copy and Paste from file and then copy and paste the rows from a prepared CSV file into the text box.
Add a single Contact
- Click Add a single contact to manually add a single contact's information into the provided fields.
Column Mapping
The Kajabi Contact Importer uses intelligent column mapping. This means that Kajabi will recognize column headers and then organize the data accordingly.
Review and Edit the Recognized Columns.
Though the Kajabi Contact Importer is pretty awesome, it's not perfect. Make sure to review and edit the columns from the .CSV file. When clicking on the icon in the top right corner of the column, Kajabi will give you the options:
- Existing Field: Choose an existing field from your people tab.
- New Field: Create a new field that will be saved to your people tab.
- Skip Column: Skip the column and waive the accompanied data.
Create new custom fields during the import process
If the field is not recognized, Kajabi will then prompt you to create a new Custom Field.
For instance, if the header is something specific such as a company name, Kajabi will ask to create a new field.
This field will then be recognized when importing future contacts.
Bulk Actions
- Grant an offer: Grant your newly imported contacts an Offer upon import.
- Add Tags: Add an existing tag to your newly imported contacts or create a new tag on the fly.
Subscribe to email marketing: Click the checkbox to subscribe to your newly imported contacts to your email marketing list. Keep in mind, this could harm your deliverability if your contacts did not opt-in to your mailing list.
Click here to learn more about Email List best practices!
Confirmation
Kajabi will send a confirmation email to the email address associated with your account once the upload is complete.
This email will include a count of new contacts created, the count of existing contacts that were updated, and a link to a file that explains which contacts weren't uploaded along with the error reason.
The file of rejected contacts includes a record of rejected contacts and rows, along with an explanation of the error.
Automatic emails sent after import
When importing your users onto Kajabi they will be created as Contacts or as Members.
Learn more about the differences between contacts, members, and subscribers.
Importing Contacts
A user is imported as a Contact when they are added to your Kajabi list without being granted an Offer:
Contacts will not receive an automatic email of any kind when you import them to your Kajabi list.
Learn about the automated emails sent by your site
Importing Members
A user is imported and created as a Member when they are granted an Offer during the import process:
Members will receive the:
- Member Welcome Email
- As well as the Offer Grant Confirmation email.