Lists of insurance agents licensed in Wisconsin are available in self-extracting files (for a Windows environment) and may be downloaded using the information below. Both report formats are free of charge and the data is updated weekly. The data is available in simplest form for use in a variety of systems and/or applications of the users' choice. Note: The Office of the Commissioner of Insurance does not provide support for downloading or use of this data. Records questions can be directed to ocirecords@wisconsin.gov.

Agents or companies must update agent information through procedures found at the following link: address change. The licensed agent must always resolve missing or incorrect information. The data provided in these files reflect information about agents and not the companies that they represent. Agents may represent numerous companies and possess authorities that a given company may not possess.

The data provided below can be used to import into data bases or spreadsheets. The user assumes all responsibility for choosing an appropriate tool and manipulation of the data while using that tool.


Format 1 - An All Agent List

This report contains all insurance agents licensed in the state of Wisconsin. The data is provided in a self-extracting DOS executable file. The extraction will create a text file. The data is stored in a fixed column format as follows:

Starting
Column
Ending
Column
Field name (includes authority
codes where appropriate)
Characters
18License Number8
943Last Name35
4468First Name25
6993Middle Name25
94133Address One40
134173Address Two40
174198City25
199200State2
201211Zip Code11
212213Agent Authority (Casualty-11)2
214215Agent Authority (Property-12)2
216217Agent Authority (Automobile-13)2
218219Agent Authority (Accident and Health-14)2
220221Agent Authority (Life-16)2
222223Agent Authority (Title-18)2
224225Agent Authority (Credit-30)2
226227Agent Authority (Legal Expense-31)2
228229Agent Authority (Personal Lines P & C-32)2
230231Agent Authority (Crop-39)2
232233Agent Authority (Surety-40)2
234235Agent Authority (Travel-41)2
236237Agent Authority (Variable Life/Variable Annuity-42)2
238247Expiration Date (MM/DD/YYYY)10
248257Status Date (MM/DD/YYYY)10
258329E-Mail Address72
330334License Type
LSB=Life Settlement Broker
II=Insurance Intermediary (Agent)
MGA=Managing General Agent
RI=Reinsurance Intermediary
SL=Surplus Lines
N=Navigator
5

The File for Format 1 - All Agents

Please note the file format was modified to include License Types as of September 30, 2013. al_all.exe (Last Modified: 09/29/14, File Size: 8,052) is a self-extracting executable file. The extracted file is a column delimited text file. Click on the link above (al_all.exe) and save the file to a PC in any location (e.g., your Windows desktop or a Windows folder of your choice). Once the file is saved to a PC, double-click it to start the self-extraction process. The result will be a text file named al_all.txt.


Format 2 - Agents by Company Appointments

This report contains a list of all insurance agents by insurance company name. Due to the size of this report it has been split into numerous parts for ease of use in standard office applications. A comprehensive list of all agents and all companies, or customized representations of agent information, is not available from the OCI and requesters desiring such custom lists should contact Sircon Corporation as referenced above.

As in format 1, the data is provided in a self-extracting DOS executable files. Each extraction will create a text file. The data is stored in a fixed column format as follows:

Starting
Column
Ending
Column
Field name (includes authority
codes where appropriate)
Characters
110Requested OCI Number10
1182Company Name72
8392Appointment Date (mm/dd/yyyy)10
93100Agent License Number8
101135Agent Last Name35
136160Agent First Name25
161185Agent Middle Name25
186225Agent Address One40
226265Agent Address Two40
266290Agent City25
291292Agent State2
293303Agent Zip Code11
304305Agent Authority (Casualty-11)2
306307Agent Authority (Property-12)2
308309Agent Authority (Automobile-13)2
310311Agent Authority (Accident and Health-14)2
312313Agent Authority (Life-16)2
314315Agent Authority (Title-18)2
316317Agent Authority (Credit-30)2
318319Agent Authority (Legal Expense-31)2
320321Agent Authority (Personal Lines P & C-32)2
322323Agent Authority (Crop-39)2
324325Agent Authority (Surety-40)2
326327Agent Authority (Travel-41)2
328329Agent Authority (Variable Life/Variable Annuity-42)2
330339Expiration Date (MM/DD/YYYY)10
340349Status Date (MM/DD/YYYY)10
350421E-Mail Address72

The Files for Format 2 - Agents by Company Appointments

Please note that company names can change. Current company names may be reviewed by going to the Licensed Insurers page on this Web site before performing a download.

Each file below is a self-extracting, executable file. Click on the filename that contains the name of the company for which you seek a list of agents (for example, Acuity is in the al_1st-al file, Sentry is in the al_s file). Select "Save" to save the file to a PC in the location of your choice. Once the file is saved on the PC, double-click it to start the self-extraction process. (Note: The file created/downloaded will be the same name as listed below but will have an ".exe" file extension.). Select where you want to save the extracted file and click on "Finish." An uncompressed work file of the same name will be created with a ".txt" extension in the location you chose. Once the extraction process is complete, navigate to where you stored the extracted file and double-click on it to open it in Notepad. The file is now ready for you to use in the application of your choice.

Please note the file format was modified to include additional lines of authority and e-mail address as of March 29, 2010.

Choose a compressed
file for download
Last ModifiedFile Size
al_1st-al.exe09/29/142,904
al_am.exe09/29/143,152
al_an-b.exe09/29/143,467
al_c.exe09/29/142,911
al_d-e.exe09/29/142,242
al_f.exe09/29/142,326
al_g.exe09/29/142,450
al_h-i.exe09/29/144,118
al_j-l.exe09/29/143,643
al_m.exe09/29/143,287
al_n-o.exe09/29/143,281
al_p.exe09/29/144,614
al_q-r.exe09/29/14879
al_s.exe09/29/143,677
al_t.exe09/29/143,354
al_u-v.exe09/29/143,246
al_w-z.exe09/29/141,858

SUPPORT: Please note that these files are made available "as-is" and no support will be provided in the use of, or translation of the data. Records questions can be directed to ocirecords@wisconsin.gov.