CSV Splitter

How to use

1. 1Paste your CSV into the input, drop a file onto Open CSV file, or click Load sample to try the tool.
2. 2Confirm the input delimiter (auto-detection picks comma, tab, semicolon, or pipe) and whether the first row is a header. The header is added to every output file when this is on.
3. 3Pick a split strategy: By max rows per file (enter a row cap), By number of files (enter how many chunks you want), or By value in a column (pick a column to group on).
4. 4Tune the output base name, output delimiter, and line ending (LF or CRLF) so each chunk matches the tool you are importing into.
5. 5Click Download next to any chunk to save it, or Download all to save every file in one sequential burst. Use Copy to grab a chunk's contents to the clipboard.

About this tool

CSV Splitter takes a CSV (or TSV, semicolon-separated, or pipe-separated file) and slices it into several smaller files, each ready to import into a tool with a row limit or to share without sending the whole dataset. Three strategies cover the situations people actually hit. Split by max rows per file: enter a row cap (for example 1,000 for a Mailchimp import, 5,000 for a Salesforce data loader, 50,000 for a Postgres COPY batch, or 1,048,576 for an Excel row ceiling) and the file is cut into consecutive chunks of at most that size. Split by number of files: enter the number of chunks you want and the data rows are spread as evenly as possible across that many outputs (the first few chunks each take one extra row when the count does not divide cleanly). Split by value in a column: pick one column and every unique value in that column becomes its own output file (every region, status, plan, or category in your data turns into a named file), with filename collisions resolved by adding a numeric suffix. The parser follows RFC 4180 with full support for quoted fields, escaped double quotes (""), embedded newlines inside quoted cells, and four delimiters (comma, tab, semicolon, pipe) with auto-detection from the first 30 lines. The header row, when present, is duplicated at the top of every output file so each chunk stays a complete, importable CSV on its own. Output delimiter and line ending (LF for Unix and macOS, CRLF for Windows and Excel) are independent of the input, so you can ingest a Windows CSV and ship LF Unix files for a Postgres pipeline (or the other way around). Filenames are derived from a configurable base name (the input file name is used automatically when you open a file) plus a zero-padded part index or a slugified column value. Every chunk shows a preview of its first lines, a row count and byte size, a Copy button for the chunk contents, and a Download button for the individual file; a single Download all button triggers a sequential download burst for every chunk so you do not have to click each one. The whole pipeline runs locally in your browser using the File API, an in-process RFC 4180 scanner, and Blob URL downloads, so the data (customer lists, marketing exports, transaction logs, lead lists, support tickets, study data) is never uploaded to a server. Useful for breaking a marketing list into batched imports, splitting a transaction export by region or fiscal quarter, sharding a survey response file for batch processing, preparing per-tenant exports from a single multi-tenant CSV, chunking a large dataset before parsing in a tool that loads everything into memory, and any workflow where a single CSV needs to become several smaller, self-contained files.

Free to use. Works in your browser. No signup, no login.