To import contacts to LeadCenter, use the contact import page.
Before uploading contacts to LeadCenter using CSV upload, make sure to prepare all contact fields in LeadCenter that have predefined values. Examples of contact fields with predefined values are contact status, contact categories, contact stages, and custom fields with dropdowns, checkboxes, or radio buttons, etc. For example, if your CSV file contains the value lead under the client status column, you have to make sure to add lead in the client status settings page. Below is a full list of contact fields with predefined values:
The next step is to prepare the CSV file to make sure all the data you want to import is in the right format. One easy way to do that is to download the sample CSV file. The sample CSV file link is available in the first page of the import screens.
Use the following format for date fields: MM/DD/YYYY HH:MM. For example 05/13/2024 10:55 for May 13th, 2024 at 10:55 AM.
It is recommended to use the international format for phone numbers. The international phone number format includes <country code> <city code> <phone number>. For example, if a client's phone number is (281) 976-2234, enter it using the following format 12819762234 where 1 is the country code for the United States.
Tip: To bulk update columns in Excel, use the following Microsoft formulas cheat sheet.
The Add to Pipeline column allows you to control if the contact will show in the sales pipeline or not.
If the value is set to 1, the contact will show in the sales pipeline and sales pipeline reports. Make sure to set the stage column so the contact will show under the right stage in the sales pipeline. If you don't set a stage for the contact, the contact will be added to the stage New in the sales pipeline.
If the value is set to 0, the contact will show in the contacts dashboard, but will not appear in in the sales pipeline.
Mediums are the way leads can be captured and assigned to sources. LeadCenter can capture leads, and associate with sources, from 16 different mediums including Phone calls, website forms, Zapier, API integration, etc. This page has the complete list.
If you don't know the medium for this contact, enter CSV Upload under the medium column.
In the sample file, custom field columns will be at the end of the sheet. The header row for custom field columns follows a certain format. the format is: <custom field group title>.<custom field name>. For example, if the custom field group title is additional information and the custom field name is number of employees, the column header name will be additional-information.number-of-employees. - will always replace space in the custom field group title and name.
Created at column gives the opportunity to enter a contact created at value. If this column is left empty, the contact created at date will be set as the date and time the CSV file is uploaded.
Closed at column allows entering a contact closed at date. The contact stage must be set to a closed stage, otherwise this field will be ignored.
Contact client since field provides compatibility with other financial advisors CRM's that you are importing data from. If you will fill the client since column, follow these recommendations:
You can upload up to three phone numbers and three email addresses for each contact using CSV upload. Each email or phone will have two columns.
For email, you can enter one of the following types:
For phone, you can enter one of the following types:
Once you have prepared the CSV file, follow the steps on the contact import page to upload it.
LeadCenter offer free assistance in uploading contacts and data migration. If you need help, please send an email to support@leadcenter.ai.
If you can’t find the answers you’re looking for, our support specialists are available to answer your questions and troubleshoot if necessary.