Follow

Can I Import Contacts from an Excel Spreadsheet into the CRM?

Our Welcome Team is happy to assist you with importing your Contact/Client Information from an Excel Spreadsheet! You will find our Formatted Spreadsheet available for download below along with a printable key. If you would like to import contacts from Outlook please see this post.

First time filling out the template? Check out our Frequently Asked Questions page!

The following outlines some of the frequently used fields for this type of import (for additional fields, please see the Import Spreadsheet Guide at the bottom):

A1: Type - Redtail defines contacts into Individuals, Businesses, Associations, Trusts or Unions. If this column is left blank, but a name is listed in Columns C1- F1, then this will default to Individual.  If this column is left blank, but a name is listed in Column J1 (Companyname), then this will default to Business.

C1: First Name, E1: Middle Name, F1: Last Name – If you are importing a married couple, domestic partnership, life partner, etc. then this is where you enter the information for the Head of Household. If your contact/client is a single person, their name will be listed here as well.  (Please see the columns labeled with “Spouse” to enter spouse/partner information.)

I1: Family Name - Family name is an open text field and is what you would like to appear in a mail merge document or letter sent to a family. For Example: Mr. and Mrs. Jim Smith, Jim and Mary Smith, The Smith Family, etc. If the Client is single, he or she can still have a family name, if needed. Ex, Jim Smith.  This field does not link Family Members back to the listed Head of Household.

J1: Companyname - For Employers, Business Contact/Clients, Associations, Trusts & Unions. A separate record is created for this field.  If listed as an employer, it will be linked back to the person listed in Columns C1-F1 as the contact’s employer

M1:  Spouse First Name, O1: Spouse Middle Name, P1: Spouse Last Name  - These columns will create a separate contact record, which will be linked back to the Head of Household (Listed in Columns C1-F1) under the Family Name section. If the spouse is also on this spreadsheet on a separate line, completing this field will create a duplicate record for this name.

AB1:  Client Status & AC1: Spouse Status - Open Text field, examples include Client, Inactive, Prospect, Lead, Vendor, Professional Contact, etc.

AD1: Client Category & AE1: Spouse Category - Open Text field, examples include A, B, C - OR - Gold, Platinum, Silver, Etc.

AF1:  Client Source & AG1: Spouse Source - Open Text field to indicate where the client/spouse came from, ex, Yellow Pages, Seminar, Referral, etc.

CP1- CR1: Primary Contact Name, CQ1: Primary Contact Phone, CR1: Primary Contact Email - Used for Business Records – this can be the name of an Assistant or other Primary Point of Contact for a Business, Trust or Association. The information listed in these fields will not be added to the Head of Household/Spouse Contact Card section.

CS1: Keywords - Keywords are used to group various Contacts together, and can be used in an Advanced Search and to create Quick Lists. To add more than one Keyword to a Contact Record, please use Semicolons. Example: Keyword1; Keyword2; Keyword2

CT1: Tag Group Name - Tag Groups offer an alternative method of putting your contacts into easily accessible groupings that you can return to as needed. To add more than one Tag Group to a Contact Record, please use Semicolons. Example: TagGroup1; TagGroup2; TagGroup2

CU1 – DN1: UD Fields - User Defined Fields, to be used to keep track of additional fields not already listed. The UDF Title should be listed at the top of the column, replacing the generic “UD#” already listed. Please let us know if you would like your UDF Field Type to be changed from the default “Any Text” to one of the following: Date, List of Values, Number, True/False, or Yes/No.

DO1: Important Information - These notes will be imported to the Important Information section on each contact's Overview page. The type of information you track here is up to you, as it is a freeform field, and is completely editable. Notes entered here will not have a date/time stamp, and do not meet compliance standards for Client Notes that require that information.

When filling out the spreadsheet, please DO NOT change any of the pre-titled column names as this could cause issues/delays in the import process. 

>>> Once your spreadsheet is ready, please attach it in an email to support@redtailtechnology.com. In the body of the email, please be sure to include your Redtail Username and the first two contacts listed on the spreadsheet for verification.

Was this article helpful?
3 out of 4 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk