How to split a lead list by territory
Break one lead list into a file per territory, region, or rep, based on a column value, without filtering and copying by hand.
By Operelio team · Updated July 2026
On this page5
One list, one file per territory
Handing leads to a team usually means splitting one list into a file per territory: by country, by state or region, or by the rep who owns it. The split almost always comes down to one column, the territory value, and a clean way to break the list on it.
Pick the column to split on
Decide which column defines a territory. It might already exist as a Region or Country column, or you might derive it, for example grouping states into regions. Make sure that column is consistent first, so West and west do not become two territories.
Excel's filter treats West and west as the same, but a trailing space does not match, and any tool that splits by exact value sees three territories where you meant one. The quick audit: sort the column A to Z and skim it. Variants, stray spaces, and blanks all cluster together where you can see them. Fix them with Find & Replace before splitting.
If your territory is based on country but you only have phone numbers or addresses, derive a clean country column first, then split on it.
Filtering and copying by hand
The hands-on version, done carefully so no rows go missing:
Sort by the territory column
Data, Sort, by your territory column. Sorted, each group is one contiguous block, and inconsistent values sit next to each other where you can spot them.
Filter to one territory
Data, Filter, then open the territory column's dropdown and tick a single value.
Copy only the visible rows
Select the filtered rows plus the header and copy. Copying a filtered list normally grabs just the visible rows, but if any rows were hidden by hand rather than by the filter, plain copy brings them along too. To be safe, press Alt+; first (on Mac: Edit, Go To, Special, then Visible cells only) to restrict the selection to what you can see.
Paste into a new workbook and save
Paste into a fresh workbook and save it with the territory in the filename, like leads_west.xlsx. If you save as CSV, remember only the active sheet is saved, and reopening that CSV later can drop leading zeros from phone and postal code columns.
Repeat, then reconcile
Clear the filter and repeat for the next territory. When you finish, add up the row counts of the split files; the total should equal the original list. A shortfall usually means rows with a blank territory that no value filter picked up.
A PivotTable can fake a bulk split: put the territory field in Filters, then PivotTable Analyze, Options, Show Report Filter Pages creates one sheet per territory in one click. The catch is that each sheet holds a pivot table, not your raw lead rows, so it suits summaries better than handoffs.
Split on a column value
Operelio's Split File tool, on Pro and up, does the whole job in one run. Point it at your territory column and it creates one file per unique value, each named by that value (leads_EMEA.csv from leads.csv), with every column and the full header row in every file. The output arrives as a single ZIP of CSVs. Rows with a blank territory are not dropped: they land in their own file with an _empty suffix, and the results page warns you how many rows went there, which is exactly the chunk manual filtering tends to lose.
Splitting by value is one of three modes. You can also split into fixed chunks of a set number of rows, useful when an import tool has a row cap, or send groups of columns to separate files. And if you only need one territory rather than all of them, the Filter & Extract tool pulls the matching rows and is free on every plan.
Break one list into a file per territory, region, or rep, based on a column value.
Frequently asked questions
How do I split a lead list by region?
In Excel: sort by the region column, filter to one value, copy the visible rows into a new workbook, save it, and repeat per region. Operelio's Split File does it in one job on Pro and up: pick the column and download a ZIP with one named file per region.
How do I split one sheet into multiple sheets by value in Excel?
The closest built-in trick is a PivotTable: put the field in Filters, then use PivotTable Analyze, Options, Show Report Filter Pages to generate one sheet per value. Each sheet contains a pivot table rather than your raw rows, so for handing off actual lead lists you still end up copying data out.
What happens to rows with a blank territory?
In manual filtering they are easy to lose, because no value filter picks them up; check for them with the Blanks option in the filter dropdown before you finish. Operelio's Split File groups them into a file with an _empty suffix and warns you how many rows landed there, so nothing is silently dropped.
What if my territory values are inconsistent?
Standardize before splitting, or West, west, and West with a trailing space become separate files. Sort the column and skim for variants, then fix them with Find & Replace. If the territory has to be derived, from state groupings or from country, add that column first and split on it.
Can I split a file into chunks of a fixed size?
Yes. Split File's row-count mode divides the file into sequential chunks of the size you set, each with the full header row, which suits import tools with a row cap. In Excel the equivalent is cutting ranges by hand, which is slow and error-prone on anything large.
Ready to get started?
Upload a file and run your first transformation. Free, no credit card required.