Link Leads Blog · October 21, 2026

How to filter an aged insurance lead CSV by state and age before you dial

An order builder lets you set a state list and an age band before you buy. It doesn't stop there — splitting that file further, by state for a team or by a narrower age band for one vertical, is a spreadsheet job you'll do after delivery. Here's the fastest way to do it correctly.

Why you'd filter a file you already filtered once

Buying a 20-state, 18–64 order gets you a file shaped the way you asked for it at checkout. That's rarely the last cut you need. A common case: one order covers five states because the volume pricing works out better that way, but only one producer is licensed in each state — so the file has to be split back apart by state before anyone can legally work their slice. Another: an order spans the full 18–64 band because that's what the source supports, but this week's campaign is a mortgage protection push aimed only at the 55–64 band. Both are the same spreadsheet operation — filter columns you already have, not a new purchase.

The columns you're working with

Every Link Leads SMS file ships as First Name, Last Name, State, Zip Code, Cell Number, Age — plain columns, no merged cells, no notes field swallowing the data. That matters for this exercise: state and age are their own columns, so a filter or formula can target them directly instead of parsing them out of a blob first. Confirm your header row before you start; if a CRM export has renamed or reordered columns, fix that first so the formulas below point at the right place.

Fastest method: AutoFilter (Excel and Google Sheets)

For a one-off cut you won't need to repeat, the built-in filter beats writing a formula:

  1. Select the header row, then turn on filtering — Data > Filter in Google Sheets, or Ctrl+Shift+L in Excel.
  2. Click the State column's filter arrow and check only the states you want. For a single state this is instant; for a short list, uncheck "Select all" and check the ones you need.
  3. Click the Age column's filter arrow, choose Number filters > Between in Excel or use the condition menu in Sheets, and enter your low and high bounds.
  4. Copy the visible rows into a new sheet or file. Filtering only hides rows — it doesn't remove them — so always copy the filtered result out before you export, or the next person to open the file sees the full list again.

Repeatable method: one formula, every criterion at once

If you're going to re-cut the same file by different state/age combinations more than once — say, one slice per producer — a formula is faster than re-clicking filter menus each time. In Excel 365 or Google Sheets, FILTER() takes a range and one or more true/false conditions multiplied together:

=FILTER(A2:F20000, (C2:C20000="FL")*(F2:F20000>=55)*(F2:F20000<=64))

Read that as: return every row from A2:F20000 where the State column (C) equals "FL" and the Age column (F) falls between 55 and 64. Each condition in parentheses evaluates to 1 or 0 for every row; multiplying them together means a row only survives if every condition is a 1. Change the state code and the two age bounds in a cell reference instead of hardcoding them, and you can re-run the same formula for every producer by just updating three inputs.

For a list of states rather than one, swap the equality check for a lookup: ISNUMBER(MATCH(C2:C20000, {"FL","GA","TX"}, 0)) in place of C2:C20000="FL" catches any row whose state matches one in the list.

Splitting a multi-state order across a team

For handing a state-by-state slice to each producer, a pivot table is the fastest way to see the shape of the file before you export anything: drop State into rows and Cell Number (or any column) into the value area set to Count, and you get a per-state row count in seconds. That tells you which states are worth a dedicated slice and which have too few records to bother splitting out on their own — small states are often better left combined into one "remaining states" file for whoever's licensed broadly. Once you know the breakdown, repeat the AutoFilter or formula step per state and save each as its own CSV, named so the dialer import log is self-explanatory later — something like FL_55-64_2026-10-21.csv beats leads2.csv the first time you need to trace an issue back to a specific batch.

Don't let a re-slice reintroduce duplicates

If you're pulling multiple orders into the same working file before you filter — last month's Florida order plus this month's addition, for instance — check for duplicate phone numbers before you split and distribute, not after. A quick way: a helper column with =COUNTIF($E$2:$E$20000,E2)>1 flags any Cell Number value that appears more than once, so you can sort on it and remove the repeats before anyone dials the same person twice from two different slices. It's a cheap check that prevents an avoidable duplicate-call complaint.

Filtering isn't the same as scrubbing

Everything above sorts a file you already own into usable pieces — it doesn't clear any number to be called or texted. A state/age filter has nothing to do with DNC status, and it won't tell you which numbers are landlines rather than mobiles, which matters before anything goes to a texting queue. Run your DNC scrub (see the full scrub walkthrough) and a wireless check on each slice after you've split it, not before — scrubbing the whole file once up front and then splitting is fine too, but skipping the step because "I already filtered it" is the mistake to avoid. We point buyers at Landline Remover for the wireless/landline pass (an affiliate link — we may earn a commission if you sign up through it): upload the CSV slice and it flags landlines, disconnected numbers, and DNC-listed contacts together, so a texting queue only gets numbers that can actually receive the message.

Loading the slice into a dialer

Once a slice is clean, the import step is the same regardless of how you cut it — keep State, Zip Code, Cell Number, and Age as their own searchable fields rather than letting the import merge them into one notes field, so you can still filter and report inside the dialer later. The full column and pacing checklist is in the power dialer setup guide if you're setting one up for the first time.

Get a file to slice

Every Link Leads order already comes filtered by the states and age band you choose at checkout — this is the follow-up step for re-cutting that file by producer, vertical, or a narrower age band once it's in hand. Build an order in the order builder, or grab the free 100-row sample first to see the column layout before you buy.

These are aged data leads (not consented insurance-form leads) and are not DNC-scrubbed. Filtering by state or age changes nothing about DNC or consent status — buyers are responsible for DNC scrubbing and dialing/texting compliance on every slice.