Split a CSV file into smaller files
Split a large CSV or Excel file into smaller CSV files by number of rows or number of files. The header row can be repeated in every part, and you download one zip. Free, and your file never leaves your browser.
When to use it
Some programs refuse files that are too big, and Excel stops at just over one million rows. Splitting a large CSV into smaller pieces makes it easy to open, share or upload.
Choose how many rows each file should have, or how many files you want. The header row can be repeated in every piece, and you get all the pieces in one zip file.
How it works
- Drop in a CSV or Excel file.
- Choose rows per file or the number of files, and whether to repeat the header row.
- Check the preview, then download the zip with all the parts.
Questions
Is there a limit on how big the file can be?
The file is processed in your browser, so the limit is your device memory. Files with a few hundred thousand rows usually work fine. Very large files may be slow on a phone.
Is the header row kept in every file?
Yes, if you leave the header option ticked. The first row is copied to the top of each part. Untick it if your file has no header row.
What if the rows do not divide evenly?
The last file simply holds the leftover rows, so it may be shorter than the others.
Is my file uploaded anywhere?
No. Splitting happens inside your browser tab and nothing is sent to a server.
Did this help?
Tell me what worked, what broke, or what tool you want next. I read every message.
Send feedback