Split CSV

Splits a big CSV into smaller files by row count or by the value of a column.

CSV or Excel, up to 200,000 rows
Runs in your browser. The file never leaves your device.CSV or Excel, up to 200,000 rows

Next

Email me this report
A short summary of this run: the counts and settings, never your rows. Your file stays in your browser.
The counts from this runThe settings you usedNo file, no rows, no saved link
One email with the report. No sequence, no sales call.
Ken cleans every list you import, then verifies it.
Import once. Ken dedupes, formats and verifies every address, and keeps the flags with each lead.
Start free - 1,000 credits, no card

What split CSV does

It cuts one large CSV or Excel file into smaller ones, either by row count or by the value in a column.

  • By row count: every file gets the same number of rows, and the header row is repeated in each.
  • By column value: one file per value, for example one per country, per owner or per campaign.

The file is read in your browser and never uploaded, and the parts download together.

How to read the result

The preview lists every output file with its name and row count. For a split by column, rows with an empty value go to their own file so none are lost. Row counts across all files add up to the original.

How to use it

Split by row count when a file is too big for a spreadsheet, an import limit or a daily sending batch. Split by column to hand each rep their own territory or to run one campaign per segment with copy written for it. Shuffle the file first if you split by row count for an A/B test, so each part gets a fair mix.

Why it matters for cold email

Sending one generic email to a whole export is what gets ignored. Splitting by industry, country or seniority lets each segment get its own first line and offer. Smaller batches also make problems visible earlier: if the first part bounces badly, you stop before sending the rest.

Questions

How do I split a large CSV file into smaller files?
Drop it here, choose rows per file, and download the parts. Each part keeps the header row, so every file imports on its own.
What is the maximum number of rows Excel can open?
1,048,576 rows and 16,384 columns per sheet. Excel drops anything past that when it opens a CSV. Google Sheets allows up to 10 million cells per spreadsheet across all sheets.
Can I split a CSV by the value in a column?
Yes. Pick the column and you get one file per distinct value, named after the value. It works well for country, state, industry, owner or list source.
Is the header row repeated in every file?
Yes. Every output file starts with the original header row, so each one imports into a spreadsheet, CRM or sending tool without extra steps.
How do I split a CSV on the command line?
On macOS or Linux, split -l 10000 big.csv part_ cuts by lines, but only the first part gets the header, and a quoted field with a line break inside it gets cut in half. This tool parses the CSV properly before it splits.

More in CSV tools

14 tools.