How to use the CSV Splitter
- 1. Load your CSVChoose a file or paste text.
- 2. Choose how to splitEvery N rows, N equal files, or one file per value of a column.
- 3. Download the ZIPEvery part is a CSV with the header row repeated.
When splitting helps
Upload forms, email tools and CRMs often limit how many rows they accept, and some spreadsheets struggle with very large files. Splitting every N rows makes batches such as 500 contacts each. N equal files shares the work between people. One file per value gives each region, course or salesperson their own file. Every part keeps the header row, and the files are bundled into one ZIP, named after your file and the part or value. Files are read by your browser and never uploaded.
Worked example
The 10-row sample split every 4 rows gives 3 files of 4, 4 and 2 rows. Split by the Course column instead and you get 4 files: Python, Data Analytics and Full Stack with 3 rows each, and Digital Marketing with 1. File names come from the values, with unsafe characters replaced; blank values go into a file called (blank).
Details
- Each CSV starts with a UTF-8 marker so Excel shows Hindi and other scripts correctly.
- The ZIP is uncompressed (stored), which keeps it fast and compatible; our tests open it with Python's zipfile and check every file's CRC.
- Splitting by a column with more than 500 different values is blocked, because that many files is rarely what you want.
Frequently asked questions
Can I split an Excel file?
Convert it to CSV first with our Excel to CSV converter, then split.
Does the order of rows change?
No. Rows stay in their original order within each part.
Is the CSV splitter free?
Yes. You can open the CSV splitter, load files and set every option without signing up. When you split a file for the first time, we ask once for your name and WhatsApp number; after that it, and every other Uncodemy tool, opens straight away.