Data glossary

CSV files

How our gzip-compressed CSV files are laid out, and how to open one with more rows than a spreadsheet holds.

CSV files: 1,755,281 rows in the nationwide agent CSV, more than an Excel sheet holds.

What it is

A CSV (comma-separated values) file stores a table as plain text: one row per record, commas between the columns, and a header row that names each column. Almost every CRM, database and spreadsheet can read one.

Our files

Each pack is a gzip-compressed CSV (.csv.gz) in UTF-8 with a header row: 25 columns in the agent file and 27 in the adjuster file. Empty cells mean the record has no value, and multi-value columns are joined with a semicolon and a space. The CSV documentation lists every column.

Opening large files

An Excel worksheet holds at most 1,048,576 rows, and the nationwide agent file has 1,755,281. A nationwide order therefore also downloads as a ZIP of the state files, one plain CSV per state that each fit in a worksheet. For the full file in one piece, use a database or a data tool. The CRM import guide gives the row limits for HubSpot, Salesforce and Pipedrive.

Back to data glossary

Check it yourself first

Open the sample before you spend anything.

insurance-agents-free-sample.csv1,000 real records · 25 columns · all 50 states + DCDownload free sample

Same columns as the paid packs. No signup and no email required. Or browse the state packs