Split CSV by column value: one file per country, owner or status
In short: Upload a list and choose a column. Each different value in it becomes its own group with a row count, and each group downloads as its own CSV with every column kept. Case and spacing differences can be merged, and blanks get their own file. Limit: Values are grouped as written; different spellings of one thing stay separate unless they differ only in case or spacing.
Upload the list and choose the column, for example Country or Owner. Every different value becomes a group and the page lists each with its row count. Download any group as its own CSV with all columns kept. Case and spacing differences can be merged into one group, and rows with no value go in a blank group.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. Check your list free nowSee pricing
Sample result
A list of six becomes three files: United States 3, Canada 2 and blank 1.
- Files
- 3
- Column
- Country
- Rows in all
- 6
What this means for you
Each file is a ready send list with every column kept.
- Split on any column
- Case and spacing merged
- Blank values kept
- One download per file
- Split
- CSV
- Segments
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Each file is a ready-made send list.
- Download the group you want to send, or use the check button under the result.
- Upload or paste it at /verify. Every address gets a live mailbox check, and the first 100 email checks are free with a Google sign-in, no card.
How do I split a CSV into one file per column value?
- Upload the .xlsx or CSV, or paste the cells with the header row first.
- Choose the column to split on, and leave the box ticked to treat United States and united states as one value.
- Read the groups and their row counts, then download the ones you need or the summary table.
- Check the addresses in each file before you send it.
Example
- You enter
- Six leads with a Country column:
United States,united states,Canada, a blank,United StatesandCanada, split with case differences merged. - You get
- Three files: United States with 3 rows, Canada with 2 and blank with 1. One spelling difference was merged. Each file keeps the header row and every column.
- Limits
- Runs in your browser; nothing is uploaded. Files up to 25 MB.
What can I split on?
Any column: country or state to send in the right local hours, owner to give each rep a file, status or stage to separate leads from customers, source or campaign name to keep batches apart, or a tier or score band. The values are used as they are written, so a column with many different values makes many groups; the page lists the largest first.
How are spelling differences handled?
With the case box ticked, values that differ only in capital letters or surrounding spaces become one group, named after the first spelling met, and the page says how many were merged. Real spelling differences, such as USA and United States, stay apart; fix them first with find and replace in CSV or the country name normalizer.
How is this different from splitting by size?
The email list splitter cuts a list into parts of a set size, and the email list segmenter splits by address properties such as domain or provider. This tool splits by what is written in any column you pick.
Who uses this tool, and for what?
- Cold email senders
- Split a list by country or time zone group to send at local hours.
- Sales ops
- Give each rep or territory its own file.
- Agencies
- Separate one client's list by campaign before upload.
What can’t this tool tell you?
- Values are grouped as written; different spellings of one thing stay separate unless they differ only in case or spacing.
- A column with very many different values makes very many groups.
- The page shows the 50 largest groups as download buttons; the summary lists all.
- Output is CSV; an .xlsx file is not written.
Common questions
- What happens to rows with an empty value?
- They go in a group named (blank), which downloads like any other.
- Does each file keep the header row?
- Yes. Every file starts with the header row and keeps all columns.
- Is there a limit on groups?
- The page shows the 50 largest groups to download one by one; the summary table lists every group.
- Can I download all the files at once?
- Each group has its own download button. Browsers may ask before saving several files in a row, so download the groups you need.
- Does it work on .xlsx files?
- Yes. Upload an .xlsx or CSV, or paste cells with the header row first.
- Is my file uploaded to SimpleVerifier?
- No. The file is split in your browser.
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
Plans from $9 a month, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.