Note
Your organization may have an alternative area where contact imports should be sent. Please check with your internal administration team first.
Total Expert is able to import your contacts for you. All you need to do is add your contacts to a CSV spreadsheet then send that file to Support@TotalExpert.com.
In our ongoing effort to ensure data integrity, Total Expert requires contact imports for a co-marketing agent's account to be submitted by the account holder. The account holder can submit the import by emailing Support@TotalExpert.com or by using the Support chat widget in Total Expert.
TABLE OF CONTENTS
How to Create an Import Contact Data Spreadsheet
- Download the Contact Import Template (located at the bottom of this article).
- Input the required and necessary information (see table below for in-depth column information).
- Double check your file for any typos or spelling errors.
- Note: Total Expert is not responsible for any formatting errors.
- Save your spreadsheet as a CSV file.
- Send your file to Support@TotalExpert.com or use the chat widget.
Data Requirements
- Each contact must have the following in order to be successfully imported:
- First Name
- Last Name
- Email Address OR phone number OR full address
- You do not need to use every column header.
- The spreadsheet must be saved as a CSV file.
- Each column header must clearly indicate what data is being imported.
- Ex: Cell Phone or Contact.phone_cell for the contact's cell phone number.
- Each contact needs to be separated by first and last name. If the contact has a middle name or middle initial, add it to either the "First Name" or "Last Name" column header.
- You must have a "Group" or "ContactGroup.name" column to put a contact into a specific group. To put a contact into a more than one group, enter multiple groups under the "Group" column and separate them with commas (no spaces).
- Ex: Realtor,Seller's Agent,Friend
Duplicate Contacts
- Contacts that do not already exist in your database are imported as a new contact.
- Contacts are not duplicated if there is a contact in your import that matches a contact already in your database. If the name is an exact match and at least one of the contact's contact information matches (email, phone number, address), no duplicate will be imported.
- If a contact already exists in your database and you have updated or added information for that contact in your import, that contact's information is updated if the first name, last name, and contact information match exactly.
Contact Import Template Column Headers
Column Header | Purpose | Example (if applicable) |
Contact.f_name | Contact's First name | |
Contact.l_name | Contact's Last name | |
Contact.nickname | Contact's Nickname | |
Contact.title | Contact's Title | Mr, Mrs, Ms, etc., 10 character limit |
Contact.suffix | Contact's Suffix | Jr, III, etc. |
Contact.email | Contact's Email | |
Contact.ok_to_email | If the contact is opted out of email communication | Opted out = 0, FALSE Opted in = 1, TRUE If not applicable, this can be left blank or not included |
Contact.lead_source | The source of the contact. | Realtor.com, Referral, LOS, etc. |
ContactGroup.name | The name of any groups the contact should be a part of. Multiple groups can be separated with a comma | "Realtors,Clients,Friends" would put the contact into the Realtors group, Clients group, and Friends group within your account. |
ContactNote.notes | Any general notes for the contact | If you need to note anything for the contact that does not fall within another field |
Contact.phone_cell | Contact's Cell Phone Number | |
Contact.phone_home | Contact's Home Phone Number | |
Contact.phone_office | Contact's Office Phone Number | |
Contact.ok_to_call | If the contact is opted out of phone communication | Opted out = 0, FALSE Opted in = 1, TRUE If not applicable, this can be left blank or not included |
Contact.address | Contact's Address | |
Contact.address_2 | Contact's Address Line 2 | |
Contact.city | Contact's City | |
Contact.state | Contact's State | |
Contact.zip | Contact's Zip | |
Contact.ok_to_mail | If the contact is opted out of mail communication | Opted out = 0, FALSE Opted in = 1, TRUE If not applicable, this can be left blank or not included |
Contact.employer | Contact's Employer | |
Contact.employer_address | Contact's Employer's Address | |
Contact.employer_address_2 | Contact's Employer's Address Line 2 | |
Contact.employer_city | Contact's Employer's City | |
Contact.employer_state | Contact's Employer's State | |
Contact.employer_zip | Contact's Employer's Zip | |
Contact.birthday | Contact's Birthday | Can be formatted as MM/DD or MM/DD/YYYY |
Contact.credit_score | Contact's Credit Score | |
Contact.credit_score_date | The date the Contact's Credit Score was checked | |
Contact.credit_score_expire_date | The date the Contact's Credit Score expires | |
Contact.list_date | The listing date of the Contact's property | |
Contact.close_date | The closing date of the Contact's property | |
Contact.referred_to | If you referred the contact to another person/party | |
Contact.referred_by | If another person/party referred the contact to you | |
Contact.spouse_f_name | Contact's Spouse's First Name | |
Contact.spouse_l_name | Contact's Spouse's Last Name | |
Contact.spouse_title | Contact's Spouse's Title | Mr, Mrs, Ms, etc., 10 character limit |
Contact.spouse_suffix | Contact's Spouse's Suffix | Jr., III, etc. |
Contact.spouse_email | Contact's Spouse's Email Address | |
Contact.spouse_phone_home | Contact's Spouse's Home Phone Number | |
Contact.spouse_phone_cell | Contact's Spouse's Cell Phone Number | |
Contact.spouse_phone_office | Contact's Spouse's Office Phone Number | |
Contact.spouse_address | Contact's Spouse's Address | |
Contact.spouse_address_2 | Contact's Spouse's Address Line 2 | |
Contact.spouse_city | Contact's Spouse's City | |
Contact.spouse_state | Contact's Spouse's State | |
Contact.spouse_zip | Contact's Spouse's Zip | |
Contact.spouse_employer | Contact's Spouse's Employer | |
Contact.spouse_ok_to_call | If the If the contact's spouse is opted out of phone communication | Opted out = 0, FALSE Opted in = 1, TRUE If not applicable, this can be left blank or not included |
Contact.spouse_ok_to_mail | If the If the contact's spouse is opted out of mail communication | Opted out = 0, FALSE Opted in = 1, TRUE If not applicable, this can be left blank or not included |
Contact.linkedin_url | Contact's Linkedin Page | |
Contact.other_url | Another Website relating to the contact | |
Contact.website_url | Contact's Website | |
Contact.pre_approval_issued_date | The date the contact was issued a pre-approval |