How to split a CSV or Excel file into multiple files by column

Sending each region its own rows, or each manager their own team, usually means filtering, copying and saving the same sheet dozens of times. It is one step when the tool writes one file per value for you.

Split a file in three clicks

Open NoEgress and drop your file. On the Start page, find Split into files, pick the column to split by, for example region, and click Download ZIP.

You get one CSV per value of that column, each with the header row, named after the value: East.csv, West.csv and so on. The ZIP is named after your file and the column.

Pick a column with a handful of values

Splitting works best on a column like region, department or country, where each value covers many rows. Splitting on an ID column gives you one tiny file per row, which is rarely what you want.

NoEgress preselects the first text column with few distinct values. Up to 1,000 files are written per split.

What happens to blanks and odd names

Rows where the column is empty go into a file called (blank).csv, so nothing is dropped. Characters that aren’t allowed in file names, such as / or :, are replaced with an underscore.

Values that differ only in capitalisation, like "east" and "East", get separate files: east.csv and East (2).csv.

Clean or filter before you split

If the recipients shouldn’t see every column, remove or mask them first. Remove personal data on the Start page masks names, emails and IDs; the Table view can drop columns. Then split the cleaned table.

To split only part of the data, filter it in SQL, save the result as a dataset, and split that.

SELECT region, customer, revenue
FROM orders
WHERE order_date >= DATE '2026-01-01';