Split CSV into Parts
Break a large CSV into manageable pieces by rows, by number of files or by the values in a column. Everything runs in your browser and your data stays local.
- Free, no sign-up
- Files stay on your device
- Header repeated in each part
- Three ways to split
- Runs on your device. Files are never uploaded.
- Free and unlimited. No sign-up, no watermark.
Split CSV into smaller files in three steps
No account, no email, no waiting for an upload.
- STEP 01
Add your CSV
Choose the CSV you want to work on.
- STEP 02
Choose how to split
Every so many rows, into a set number of equal files, or one file per value in a column.
- STEP 03
Download the parts
Parts are numbered 001, 002 and so on. If there are more than 30, they come together in a ZIP.
What Split CSV into smaller files does, and what it doesn't
We'd rather tell you up front than surprise you after the download.
What you get
- By row countSet rows per file, for example 1,000 rows for an importer with an upload limit.
- Into equal filesSay you want 5 files and the rows are shared out evenly.
- By column valueOne file per country, status or department. Use a header name, a letter or a number.
- Header repeatedEvery part starts with the header row, so each stands alone.
- Format preservedYour separator, line endings and BOM carry over to every part.
Good to know
- Memory boundThe whole file is loaded in your browser before it is split. Multi-gigabyte files will not fit, especially on a phone.
- Column split limitSplitting by a column that has more than 500 distinct values is refused, because that would make too many files.
- Quoted line breaksRows are kept intact, including cells with line breaks. Parts are counted in rows, not lines.
Your spreadsheets never leave your device
The tool runs inside your browser instead of on our servers, so there is nothing to upload, store or delete afterwards.
Typical online tool upload
Your file travels over the internet, sits on someone else's computer for a while, and you wait for the upload and the download.
Mediaextractr no upload
The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.
When people use Split CSV into smaller files
Meet upload limits
Many CRMs and email tools cap rows per import.
Send a region its own data
Split customers by country and email each file.
Open a file Excel cannot
Excel stops at 1,048,576 rows. Split first, then open the parts.
Create test samples
Make small slices of a large dataset.
Mediaextractr vs typical upload tools
| MediaextractrPrivate | Typical upload tools | |
|---|---|---|
| Your file is uploaded | Never | Yes |
| Sign-up needed | No | Often, after a few files |
| Daily file limit | None | Often 1–2 free files |
| Watermark | Never | Sometimes |
| Wait for upload & download | No | Yes |
| Speed on very large files | Depends on your device | Depends on their servers |
Choosing a split method
Use rows per file when a system has a hard cap. Use a number of files when you want to share the work evenly, say between four colleagues. Use a column when the data has natural groups, like one file per city.
After splitting
Each part is a full CSV with the same columns. If you need the opposite, Combine CSV files joins them again. To check how many rows you started with, use CSV row counter.
Splitting a workbook rather than a CSV? Split Excel workbook by sheet separates tabs. For a quick tidy before sending, try Remove duplicate CSV rows.
A quick example
Say you have a CSV of 5,000 contacts and an email tool that accepts 1,000 rows at a time. Set rows per file to 1,000 and you get five parts, each with its own header. Set files to 5 and you get the same result without doing the arithmetic.
Questions, answered
How do I split a large CSV file?
Add the file, choose rows per file, number of files or a column, and download the parts.
Is the CSV uploaded to be split?
No. It is split inside your browser, so contact lists and exports stay private.
Does each part keep the header?
Yes, by default. You can switch that off.
Why was my column split refused?
A column with over 500 different values would create too many files. Pick a column with fewer groups.
Can it split files bigger than a gigabyte?
That depends on your device's memory, since the file is read whole. A desktop browser has the best chance.
Will it work on a Mac?
Yes, as well as Windows, Linux and mobile browsers.