Focus:  The focus of this self-help article is to provide steps and information to import your Contacts  via CSV.

What is a CSV?: A “CSV”, also known as a “comma separated value”, is a file that can be generated by many different types of programs to export contact information.

Used in Cliently?: CSV files can be used by Cliently in order to upload your contacts directly into “My Clients” and have the ability to assign to a specific “Pipeline” and “Stage”.

Maximum upload at one time. Please note, you can only import via CSV with a total of 500 records for each import.

Importing more than 15 contacts and assigning a flow?: If so, please note Cliently has a throttling system in order to send out the emails. We will stagger the emails over a period of time so your mail will be sent out with no issues. May take hours if you have a large number of contacts.

Step 1: Find Import. Under My Clients, find “Import/Export”.

Step 2: Selecting a file. Next, under “Import”, click on “Choose a file” and select the file from your computer.

Step 3: Configure CSV to be imported… Next, you will need to match up the CSV fields to the Cliently fields. Please Note: Cliently will do its best to match your current CSV fields to Cliently fields, but we do suggest to review each field.  Please take your time and make sure that all fields are matched up to Cliently fields. 

The fields available for import are:

Contact First Name
Contact Last Name
Contact Job Title
Contact Phone
Contact Email
Contact Street
Contact Street 2
Contact City
Contact State
Contact Zip Code
Contact Country
Company Name
Company Phone
Company URL
Company Street
Company Street 2
Company City
Company State
Company Zip Code
Company Country
Company Description

When completed, Click Next.

Step 4: Adding into Cliently.  For the Final steps of setup, we will cover each option to select for import.

Step 4-A: Update existing Contacts - Our first option, if you have this option checked, “a contact with the same email address already exists in Cliently, it will update the contact/company fields with data from the import file. If this option is NOT checked, existing contacts will be skipped (not updated).

Step 4-B: Pipelines and Stages - You can choose which “Pipeline” the contacts will be imported to. By Default, “Pipeline 1” will be selected, however you can select any Pipeline you have inside of your account.  

Next, you can assign “Stage”, by default “New Lead” is selected, however you can change this to any Stage you see fit.  

Step 4-C: Add Leads to Workflow?:  Next, if you are have setup “Workflows”, you can assign Contacts to be associated with any workflows you have created.  If you plan to use this feature, we suggest you test your flow on a dummy contact (such as yourself) and make sure all emails are sent. 

Step 4-D: Move existing contacts to selected workflow. If you selected the option above in Step 4-C, you can choose this option for existing contacts. “If a contact with the same email address exists and is in a workflow, it will move the contact to the newly selected workflow and enable it. If this option is NOT checked, existing contacts will remain in their current workflow.

Step 4-E:  Start Immediately or Start on…. If you selected the option above in Step 4-C, you can choose when you want the flow to begin. Do you want to start Immediately or do you want to choose a specific date and time?  Select your option; once ready, click on the blue “Import” button to begin.

Please note:

Immediately - Choosing this option will send out the first action in your flow and the following will use your schedule for your flow settings.

Start on (future) - Choosing this option will NOT send out the first action in your flow, it will follow your schedule you set for your flow.

Please see STEP 3 - Schedule on our Flows FAQ for details on your setting up your flow schedule. 

Please note: If you plan on adding flows to your contacts to send out emails/video messages, we suggest that you only import 50 contacts at one time to reduce the risk of your account being flagged as spam. Once you are ready, click on “Import”.

Step 5: Completion notifications. Once the import has been completed, you will receive two types of notifications.

In app message:

Example Email sent to you:

Congratulations, you have successfully imported your CSV into Cliently.

Step 6: Review Contacts. Once the import has been completed, you can open the contact and  review the “Lead Source” field to let you know which file was used and when it was imported into Cliently. If the contact was updated, it will let you know which CSV file was used and when it was updated.

Troubleshooting Import via CSV:

Multiple contacts under 1 Company in your CSV?: In order to minimize space taken up by contacts on your My Clients page, deal cards are created based on Company name. Any contacts who share a Company Name will be added to the same card. You can manage these individual contacts all from within the one Company Card, via the dropdown arrow.

If you have multiple contacts working for the same Company in your CSV file, those contacts will all bundle into and appear in that one Company’s Card. The contacts will be added in the order they are listed in your CSV file, with the first contact listed being the name that is visible on that Company Card.

Need Help? If you need any help with importing contacts into Cliently via CSV, please login to your Cliently Account and click on the red “Help/Chat” icon found on the bottom right side of your account.

Did this answer your question?