Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Contact Us
  • Home
  • Print/Export

Exporting Data

Written by rob g

Updated at February 27th, 2025

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Pipeline & Search Menu
  • CRM Capability
  • Integrations
  • WC Policy Details
  • Retirement Data
  • Health Data
  • OSHA
  • DOT
  • Mobile App
  • Reports
    Interactive Reports
  • Print/Export
  • Settings
  • LossRunner
  • Class/Industry Look Ups
  • Data Availability
  • User Questions
+ More

In this category:

Table of Contents

Overview

Downloading

Search Results can be downloaded by clicking the Export button located at the bottom of your List View‍ 

Multiple Record Export (not the whole list)

Use the Picklist to select multiple records from a list

Single Record Export

You can export a single record from the modal (business details section)

Location Schedule Export

You can export the Location schedule from the Locations tab

Export File

CSV

Not to be confused with an Excel file, the export is a CSV file (comma-separated values). CSV files can be opened with a number of applications including Microsoft Excel, Apple Numbers, LibreOffice, Google Sheets, etc.

If you do not have Excel, we recommend Google Sheets, however these instructions will apply to most other applications-

  1. Open Sheets
  2. Choose "file" - "import" - "upload"
  3. Select the file and follow prompts to import

Standard Export Fields


Standard Fields

  1. Company ID - this is our internal ID
  2. FEIN
  3. Name - business name
  4. Lat/Long - the latitude & longitude of business address
  5. ID - list order
  6.  Address - street address
  7. City
  8. State
  9. Zip
  10. Phone
  11. County
  12. Effdate - WC renewal date of coverage (label needs correction)
  13. Class - primary WC class code of business's operations
  14. Classdesc - class code description (as available)
  15. Baserate - class code Loss Cost
  16. PEO
    1.  = non-PEO policy type (> or equal to 2 indicates leasing/PEO type policy)
  17. Residual
    1.  = voluntary market
    2.  = assigned-risk
  18. Agency - name of agency
  19. Employees
  20. Sales
  21. in_states - the states the business has an active policy in
  22. Website
  23. NAICS
  24. Notes - user's notes
  25. Contact info
    1. contact fields are numbered (i.e. email1, email2, name1, name2, phone1, phone2, position1, position2, etc)

Premium Search add-on Data Fields


Premium Search Add-On Data Fields

  1. Carrier - Incumbent WC Carrier
  2. LCM - carrier's current LCM filing (as available)
  3. Premium - WC premium (as available)
  4. Payroll (as available)
  5. Policynum - WC policy number
  6. PEO Provider
  7. Dot Drivers - number of drivers based on DOT data
  8. DOT Units - number of units based on DOT data


Premium Search add-on

this add-on enables the Carrier & PEO Provider targeting in your Search Menu‍ and adds the data to your export file. Note you do not need this add-on to view the information in your Details Modal‍ 


Number of Employees Formatting

Excel interprets the value as a date (i.e. 5-9 = May-9)

To fix - highlight/select the column, right-click and choose Format cells

Choose the Number tab, followed by the Custom category

Input the following - mm-dd


Experience Mod Exporting

Info

Experience Mod data is available in the following states: DE, MN, NC, NJ, PA, MA

Exports from these states' datasets will include Exp Mod data fields

Note

Renewal mods are released approximately 90 days in advance of a renewal. If a renewal mod is issued for an account you have exported it will be the first mod value in the sheet ('mod'). Users are advised to check a couple listings' Business Details‍ screen to verify if renewal mods have been issued. Renewal mods display in the upper left pane of the Modal, while current and historical mods are displayed with the coordinating policy in the Carrier History section. 


Exporting Limitations

Starter

Record Count - 200 exports per billing cycle (exports do not count against policy view count)

Date range - 90 days in advance, based on renewal date of coverage. i.e. if it is 3/1 you can export up to 200 records renewing through 5/30 (3/1 to 5/30 is 90 days, 6/1 would be 92 days..)

Agency Monthly

Record Count - up to 4,000 records per export. Unlimited exporting.

Date range - 90 days in advance, based on renewal date of coverage. i.e. if it is 3/1 you can export records renewing through 5/30 (3/1 to 5/30 is 90 days, 6/1 would be 92 days..) 

Agency Annual

Record Count - up to 4,000 records per export. Unlimited exporting.

Date range - annual plans are given a 14 month window for exporting. For example, if your subscription starts on 3/1/21 you can export businesses renewing through 5/1/22. For obvious reasons we cannot allow annual plans to export an annualized list on the last days of their subscription, so we include a 2 month buffer to allow for continued activity.

* we can waive this restriction with a written confirmation of your subscription renewal, via email. 

Note

The Export Package increases the per export limit of Team plans from 1,000 to 4,000 records per export. This add-on does NOT increase the single-user plan's cap of 200 exports per billing cycle.


Common Questions

Export Count is Lower than my Search Results

  • this is due to one of the above limitations (i.e. double check the date range of your search)

LCM Values are Inconsistent

  • Possibility 1 - we store LCM's historically. So the same carrier may have two different LCM filings in your export, which will depend on a given prospect's renewal date and the effective date of the Carrier's LCM filing. The easiest way to check for this is by checking out the Carrier History section of the Business Details - in this scenario, the 5/1 renewal has the 'old' LCM, however a 9/1 renewal with the same carrier may have the 'current' LCM. 
    ‍
  • Possibility 2 - multi-state accounts. as of this writing we are in the process of resolving a glitch, which causes the LCM from another state's policy coverage to export. For example, if you export a business based in NC that also has operations (and active coverage) in TN, the LCM value from the TN policy may show up on your NC export. This is limited only to businesses which have active coverage in multiple states. The easiest way to check for this is by checking out the Carrier History section to see if multiple states are listed.



Was this article helpful?

Yes
No

Related Articles

  • Pipeline
  • Search Results/List View
  • Printing

Links

  • Terms of Service
  • Privacy Policy
  • PEO
  • Loss Runs

Contact Info

support@insurancexdate.com

1-888-567-4119

Recent Posts

  • 2021 – Q1 Updates – Mobile App, CRM Enhancements, Integrations & New Tools
  • WC Class & GL Lookup
  • CA Data Available

InsuranceXdate, LLC

Definition by Author

0
0
Expand