📊
Split CSV
Split large CSV files into smaller files
split
Convert
About this tool
Split large CSV files into smaller files
Input: .csv
Output: .zip
Ready to convert
Select a file and click Convert to get started
Split CSV files by rows, parts, or column values
Split CSV divides one uploaded CSV file into smaller CSV files and packages them in a ZIP archive. You can limit the number of data rows per file, request a number of balanced parts, or separate records according to values in a chosen column.
When splitting a CSV is useful
- •Prepare smaller batches for an import system with a per-file row limit.
- •Divide a large export into manageable sections for review.
- •Separate records by department, status, region, or another column.
How to use this tool
- 1.Upload one CSV file and select the delimiter used in the source: comma, semicolon, or tab.
- 2.Choose a split mode: By Number of Rows, Into Equal Parts, or By Column Value. Enter the corresponding row limit, part count, or column name.
- 3.Run the split, download the ZIP archive, and check the headers and row counts in the extracted CSV files.
How the three split modes work
- By Number of Rows creates consecutive CSV files with up to the selected number of data rows. Each file repeats the header row.
- Into Equal Parts distributes data rows as evenly as possible. If more parts are requested than there are data rows, only nonempty parts are created.
- By Column Value creates one CSV per distinct value in the named column, including blank values. Filenames are sanitized and numbered to avoid collisions.
Example: split five orders into four parts
Suppose orders.csv has a header row and five order records. Choose Into Equal Parts and enter 4. The downloaded ZIP contains four CSV files with 2, 1, 1, and 1 data rows respectively. Every part includes the column headers. Choosing By Column Value with a status column instead creates one file per distinct status.
What to know before splitting
- This tool accepts one CSV source file per request. The generated parts are delivered together in a ZIP archive.
- CSV fields are read as text to preserve values such as 0012, but CSV does not contain spreadsheet formatting, formulas, or cell types.
- The first row is treated as column headers. Duplicate or blank headings may be renamed during parsing, and completely empty source rows may not be retained.
- Processing happens on the server. Avoid uploading secrets or sensitive personal information, and verify results before importing them elsewhere.
If the output is not what you expected
- Columns are combined or shifted: select the source delimiter and inspect quoting around embedded separators.
- Column splitting fails: check that the entered column name matches a header in the CSV, including capitalization and spaces.
- Fewer files than requested: check whether there are fewer data rows than the requested number of parts.
- An import fails: extract the ZIP and review the output headers, encoding, and row counts.
Continue the workflow
Return to Data tools, or continue with a complementary tool:
Questions about this specific tool
Does each CSV part include column headers?
Yes. Each generated CSV file repeats the column headers.
What if I request more parts than there are rows?
The splitter creates only nonempty parts, up to the number of available data rows.
Will leading zeros be preserved?
The CSV splitting reader treats field values as text, preserving identifiers such as 0012 in the generated CSV. Spreadsheet applications may interpret those values as numbers when opened.
Can I split rows with blank column values?
Yes. Blank values are included as a separate group in By Column Value mode.
Can I upload multiple CSV files together?
No. Upload one source CSV at a time. Its generated parts are returned in a ZIP archive.