Link Leads Blog · October 21, 2026
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.
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.
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.
For a one-off cut you won't need to repeat, the built-in filter beats writing a formula:
Data > Filter in
Google Sheets, or Ctrl+Shift+L in Excel.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.
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.
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.
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.
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.
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.