Agent/Agency > Online Services > Licensed Agent Data
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.
Other customized formats are sold through Sircon Corporation at (877)876-4450 or sales@sircon.com
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 |
|---|---|---|---|
| 1 | 8 | Agent License Number | 8 |
| 9 | 43 | Agent Last Name | 35 |
| 44 | 68 | Agent First Name | 25 |
| 69 | 93 | Agent Middle Name | 25 |
| 94 | 133 | Agent Address One | 40 |
| 134 | 173 | Agent Address Two | 40 |
| 174 | 198 | Agent City | 25 |
| 199 | 200 | Agent State | 2 |
| 201 | 211 | Agent Zip Code | 11 |
| 212 | 213 | Agent Authority (Casualty-11) | 2 |
| 214 | 215 | Agent Authority (Property-12) | 2 |
| 216 | 217 | Agent Authority (Automobile-13) | 2 |
| 218 | 219 | Agent Authority (Accident and Health-14) | 2 |
| 220 | 221 | Agent Authority (Life-16) | 2 |
| 222 | 223 | Agent Authority (Title-18) | 2 |
| 224 | 225 | Agent Authority (Credit-30) | 2 |
| 226 | 227 | Agent Authority (Legal Expense-31) | 2 |
| 228 | 229 | Agent Authority (Personal Lines P & C-32) | 2 |
| 230 | 231 | Agent Authority (Crop-39) | 2 |
| 232 | 233 | Agent Authority (Surety-40) | 2 |
| 234 | 235 | Agent Authority (Travel-41) | 2 |
| 236 | 237 | Agent Authority (Variable Life/Variable Annuity-42) | 2 |
| 238 | 247 | Expiration Date (MM/DD/YYYY) | 10 |
| 248 | 257 | Status Date (MM/DD/YYYY) | 10 |
| 258 | 329 | E-Mail Address | 72 |
The File for Format 1 - All Agents
Please note the file format was modified to include additional lines of authority and e-mail address as of March 29, 2010. al_all.exe (Last Modified: 05/14/12, File Size: 7,302) 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 |
|---|---|---|---|
| 1 | 10 | Requested OCI Number | 10 |
| 11 | 82 | Company Name | 72 |
| 83 | 92 | Appointment Date (mm/dd/yyyy) | 10 |
| 93 | 100 | Agent License Number | 8 |
| 101 | 135 | Agent Last Name | 35 |
| 136 | 160 | Agent First Name | 25 |
| 161 | 185 | Agent Middle Name | 25 |
| 186 | 225 | Agent Address One | 40 |
| 226 | 265 | Agent Address Two | 40 |
| 266 | 290 | Agent City | 25 |
| 291 | 292 | Agent State | 2 |
| 293 | 303 | Agent Zip Code | 11 |
| 304 | 305 | Agent Authority (Casualty-11) | 2 |
| 306 | 307 | Agent Authority (Property-12) | 2 |
| 308 | 309 | Agent Authority (Automobile-13) | 2 |
| 310 | 311 | Agent Authority (Accident and Health-14) | 2 |
| 312 | 313 | Agent Authority (Life-16) | 2 |
| 314 | 315 | Agent Authority (Title-18) | 2 |
| 316 | 317 | Agent Authority (Credit-30) | 2 |
| 318 | 319 | Agent Authority (Legal Expense-31) | 2 |
| 320 | 321 | Agent Authority (Personal Lines P & C-32) | 2 |
| 322 | 323 | Agent Authority (Crop-39) | 2 |
| 324 | 325 | Agent Authority (Surety-40) | 2 |
| 326 | 327 | Agent Authority (Travel-41) | 2 |
| 328 | 329 | Agent Authority (Variable Life/Variable Annuity-42) | 2 |
| 330 | 339 | Expiration Date (MM/DD/YYYY) | 10 |
| 340 | 349 | Status Date (MM/DD/YYYY) | 10 |
| 350 | 421 | E-Mail Address | 72 |
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 Modified | File Size |
|---|---|---|
| al_1st-al.exe | 05/14/12 | 2,509 |
| al_am.exe | 05/14/12 | 2,989 |
| al_an-b.exe | 05/14/12 | 3,651 |
| al_c.exe | 05/14/12 | 2,593 |
| al_d-e.exe | 05/14/12 | 1,770 |
| al_f.exe | 05/14/12 | 2,003 |
| al_g.exe | 05/14/12 | 2,616 |
| al_h-i.exe | 05/14/12 | 4,719 |
| al_j-l.exe | 05/14/12 | 3,670 |
| al_m.exe | 05/14/12 | 3,560 |
| al_n-o.exe | 05/14/12 | 3,252 |
| al_p.exe | 05/14/12 | 4,872 |
| al_q-r.exe | 05/14/12 | 923 |
| al_s.exe | 05/14/12 | 3,642 |
| al_t.exe | 05/14/12 | 3,565 |
| al_u-v.exe | 05/14/12 | 2,906 |
| al_w-z.exe | 05/14/12 | 1,889 |
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.