You can import client data from your existing CRM, Outlook, or Excel into Insureio using a CSV file. First, download Insureio's demo CSV file to use as an example. The data your current CRM exports will need to be converted to the format used in the demo CSV in order to import correctly. We'll walk you through the process below. This tutorial will show you how to export data from your current CRM or email client, reformat it, and upload it to Insureio. It's best to do a trial run first, using fewer than 5 clients. If everything imports as expected, you can repeat the process with a larger list. If you need help, contact our support team at 877-935-6755. Need a customized upload with more data than our sample CSV files contain? The Insureio Team can parse, convert, and upload your data for you for a fee. Contact our support team at 877-935-6755 for pricing.

Jump to a section:

Download the Appropriate Sample CSV Export Your Current Data Prepare Your CSV for Upload Upload Your Sample CSV Final Steps Reference: Insureio's CSV Data Import Fields - Contacts Only Reference: Insureio's CSV Data Import Fields - Contacts & Policies

Download the Appropriate Sample CSV File

1. Click Contacts Management in your left-hand main menu. Next, click the Import CSV button on the top right. CSV Import: Contacts Management
2. Download the appropriate sample. Click the first link if you're uploading contacts only. Click the second link if you want to upload contacts and their policy data. CSV Import: Download a Sample, Step 3
3. Your browser will download an Excel spreadsheet. If you chose a contacts-only upload, it will be called Contact_Record_Only_Sample.csv. If you chose to upload contacts and policies, it will be called Contact_Record_with_Policies_Sample.csv. CSV Import: Download a Sample, Step 4
4. Open the file in Excel.

Export Your Current Data

1. Select a few clients (1-5) whose data you will export as a sample. Doing a test with <5 clients will familiarize you with the column headings (or “fields”) your CRM or email client exports.
2. Export the data into a .csv file. Your application’s Help function will tell you how to do this. Your application may refer to “.csv,” “comma separated value,” or “comma delineated.” These will all work. A few common applications are listed below.
a. In Outlook: File / Options / Advanced / Export. Click here for Microsoft Office's tutorial for Outlook 2016, Outlook 2013, Office for business, Office 365, and more.
b. In Excel: File / Save As / CSV. Click here for Microsoft Office's tutorial for Excel 2016, Excel 2013, Excel 2010, and Excel 2007.
c. In LinkedIn: Connections / Settings / Export. Click here for LinkedIn's tutorial.
d. In MailChimp: Lists / Manage Subscribers / Export List. Click here for MailChimp's tutorial.
TIP: If your application only allows you to export to Excel, do so – and simply open that file in Excel and “Save As” to turn a standard Excel file into a .csv.
3. Save the file somewhere you'll be able to find it again, such as your desktop.

Prepare Your CSV for Upload

1. Open your client data .csv file, saved in the previous step.
2. Compare your data’s column headings to the column headings in the Insureio sample .csv you downloaded in step 1. Delete any columns in your spreadsheet that don't have a corresponding column in the Insureio Sample CSV. In the example below, you'd delete columns like "Title," "Suffix," and "Company" from the My Exported Data spreadsheet since they do not have a corresponding column in the Insureio Sample CSV.  (If you really need that information, you can always ask us to do a custom upload for you to preserve all that data.) CSV Import: Compare Exported and Sample Data
3. Rename columns in your .csv as needed so the headings correspond with the headings in the Insureio sample .csv. Not sure what some of our column headings mean? Click here to jump down the page, where we explain each of them.
TIP: Copy the Insureio headings and paste them into your exported document instead of retyping them. For the data to import correctly, the heading must match exactly, from the spelling to the capitalization.
a. Correct import: “gender” --> “gender”
b. Incorrect import: “Gender” --> “gender”
4. Format the data in your client data .csv so that it matches the formatting used in the Insureio sample .csv. In most cases, you'll need to transfer first, middle, and last names into one column, as well as enter a numeric code to indicate the client's state of residence. Some policy information, such as the carrier name, will also need to be entered as a numeric code rather than a name. Do not skip this step or your data will not import correctly. We included samples and links to the codes at the bottom of this page - click here for contact-only import or click here for policy data plus contacts.
PRO TIP: Sorting your spreadsheet by the state, carrier, health class, or other field will make converting to the appropriate codes faster and easier.
5. Save your file in a location you can remember and access easily, such as your desktop.

Upload Your Sample CSV

1. Return to the Contacts Management section from your left-hand main menu. Click Import CSV. CSV Import: Contacts Management
2. Click Choose File to select the sample .csv file you prepared. Click Upload. CSV Import: Choose File to Upload
3. Sit tight while Insureio uploads your data. When the import is complete, you'll see a message telling you how many contacts imported successfully. CSV Import: Success Message
4. Click Contacts Management from your left-hand menu. Use the search function to find one of your uploaded contacts, and browse their record to make sure the information you just uploaded appeared. Upload Your CSV: Checking Results
a. If you followed our suggestion to do a small trial run first, remember to keep track of the name(s) you just imported. You don't want to import them twice if you follow this trial run with an upload that contains the rest of your data. Duplicate contact records in Insureio cannot be deleted - you should only resubmit new data or data that failed to import.

Final Steps

Now that your test run was successful, it's time to import the rest of your contacts.
  1. Export your remaining client data. Repeat the steps to export your client data, but this time, export all your data, not just a few sample records.
  2. Prepare your CSV. Repeat the steps to prepare your CSV - be sure you have deleted any client records already successfully uploaded.
  3. Upload your CSV. Repeat the steps to upload your CSV.

For Reference: Insureio's CSV Import Data Fields

Contact Record Only
agent_id - click here for instructions on finding your agent ID
profile_id - click here for instructions on finding your profile ID
full_name – include first and last name in the same column
gender - "Male" or "Female"
birth – client's birth date, formatted like this:  MM/DD/YYYY
ssn – client’s social security number; format with dashes in your .csv if you want those dashes displayed in Insureio
dln - client’s driver’s license number
dln_state_id - numeric code for the state issuing the driver's license - click here for codes
marital_status – integer indicating the client’s marital status:
1 = single
2 = married
3 = divorced
4 = widowed
address1.street - client's street address, including apartment or suite number
address1.city - city
address1.state_id - numeric code - click here for codes address1.zip - client's zip code phone1.phone_type_id - integer indicating type of phone number:
1 = home
2 = work
3 = mobile
4 = fax
phone1.value - client’s phone number; format with dashes in your .csv if you want those dashes displayed in Insureio
phone1.ext - client's phone number extension, digits only
email1.value - client's email address
 
Contact Records with Policies
All the fields listed above PLUS additional columns for:
case1.quoting_details1.carrier_id - numeric code designating the carrier; click here for complete list
case1.policy_number - policy number; can be letters and/or numbers (i.e., B123456)
case1.effective_date - date formatted like this:  MM/DD/YYYY
case1.quoting_details1.plan_name - policy plan name (i.e., Select-A-Term 20)
case1.quoting_details1.face_amount - the policy's face amount in dollar value (i.e., 50,000)
case1.quoting_details1.category_id - numeric code designating the category (policy length); click here for complete list
case1.quoting_details1.carrier_health_class - the health class assigned to the client by the carrier (i.e., Standard NT)
case1.quoting_details1.premium_mode_id - integer describing the premium mode:
1 = annually
2 = semi-annually
3 = quarterly
4 = monthly
case1.quoting_details1.planned_modal_premium - the policy's planned modal premium in dollar value (i.e., 2789)
case1.sales_stage_id - integer describing the specific sales stage of this case:
1 = opportunity
2 = contacted
3 = app fulfillment
4 = submitted to carrier
5 = placed
case1.quoting_details1.sales_stage_id - integer describing the sales stage at the time the case was quoted, if the case is not placed; if case is placed, use a stage_id of 5:
1 = opportunity
2 = contacted
3 = app fulfillment
4 = submitted to carrier
5 = placed
case1.stakeholder_relationship1.genre_id - integer describing the policy's stakeholder:
1 = person
2 = trust
3 = company
case1.stakeholder_relationship1.relationship_type_id - integer describing the relationship type:
1 = parent
2 = sibling
3 = spouse/domestic partner
4 = other
5 = business
6 = child
7 = grandchild
8 = sibling
9 = stepparent
10 = stepchild
11 = trust
12 = creditors
13 = ex-spouse
case1.stakeholder_relationship1.full_name - first and last name if a person, trust name if a trust (i.e., My Insurance Trust)
case1.stakeholder_relationship1.gender - use "Male," "Female," or "Trust"
case1.stakeholder_relationship1.birth_or_trust_date - date formatted like this:  MM/DD/YYYY
case1.stakeholder_relationship1.ssn - stakeholder’s social security number; format with dashes in your .csv if you want those dashes displayed in Insureio
case1.stakeholder_relationship1.trustee - trustee first and last name; leave blank if no trustee
case1.stakeholder_relationship1.is_beneficiary - use "true" to indicate a beneficiary; "false" to indicate a non-beneficiary
case1.stakeholder_relationship1.contingent - use "true" to indicate a contingent beneficiary; "false" to indicate a non-contingent beneficiary
case1.stakeholder_relationship1.percentage - number between 1 and 100