CanDoYa
All tools
Saved toolsYour favorites

Add to favorites

Saved in this browser only.
Private browser utility / Developer

Free CSV Splitter

Runs entirely in your browser - no upload, no sign-up.

Live workspaceLocal processing

CSV source

Paste data or choose a local CSV, TSV, or text file.

or drop a file hereUp to 8 MB and 100,000 data rows
Your split workspace will appear hereAdd a CSV and choose Prepare CSV to see its rows, columns, and split settings.
Share this tool
csv splitter / browser utility
01 / Overview

What is a CSV splitter?

A CSV splitter divides one comma-separated file into smaller, valid CSV files. You can cap the rows in each file, request a set number of balanced files, or group records by a column value. Every part can retain the original header, and processing stays in your browser.

02

How to use

  1. 01
    Add the CSV

    Paste the source, choose a local CSV or TSV file, drag one into the widget, or load the example.

  2. 02
    Confirm its structure

    Leave delimiter detection on automatic or select the separator, then say whether the first row contains column names.

  3. 03
    Choose a split method

    Set rows per file, request a balanced number of files, or choose a column whose distinct values should form groups.

  4. 04
    Review and download

    Inspect each part's name, row count, size, and preview, then download one CSV or every part in a ZIP.

03

Who it's for

  • Operations teams breaking customer or inventory exports into batches that fit an import row limit.
  • Analysts distributing a dataset across a fixed number of reviewers without manually counting rows.
  • Sales teams creating separate files for each region, territory, owner, or account status.
  • Developers preparing smaller fixtures while preserving quoted commas, line breaks, Unicode text, and leading zeros.

Large exports often exceed an import tool's row limit or become awkward to share. This splitter parses the file before dividing it, so commas and line breaks inside quoted cells do not become false row boundaries. It also detects comma, semicolon, tab, and pipe input while writing portable comma-separated output.

Use a row limit for CRM or mailing-list imports, equal parts for distributing work, or a column split to make one file per region, status, or owner. Review a small preview, download one CSV, or save all parts in a ZIP. The source never leaves your browser.

FAQ

Is my CSV file uploaded?

No. The browser reads, parses, splits, previews, compresses, and downloads your file locally. Your rows are not sent to a conversion service. The page accepts up to 8 MB and 100,000 data rows so the full in-memory workflow stays responsive on typical devices.

Is this CSV splitter free?

Yes. You can use all three split methods, preview every output, copy individual CSV parts, and download a ZIP without payment or an account. The only practical caps are 8 MB, 100,000 data rows, and 200 output files per split.

How many CSV files can I create?

One split can create up to 200 files. If a small row limit or a high-cardinality column would exceed that total, the tool asks you to choose a larger row size, fewer equal parts, or a column with fewer unique values instead of creating hundreds of downloads.

Does every split file keep the header row?

Yes, when First row contains column names is selected. The header is copied into every output file but is not counted against the data-row limit. Turn the option off for headerless input, and the first record will be treated as ordinary data.

Can I split a CSV into a fixed number of files?

Yes. Choose Number of files and enter the desired count. Rows are divided as evenly as possible, with any remainder assigned one row at a time to the earliest files. The tool never creates empty files when you request more parts than there are rows.

Can I split a CSV by a column value?

Yes. After preparing a CSV with a header, choose Unique column value and select a column. Every distinct cell value receives its own CSV, while blank values share a clearly named blank group. Output filenames are sanitized and collision-safe.

Will quoted commas and multiline cells stay intact?

Yes. The parser recognizes delimiters and line breaks inside double-quoted fields, converts doubled quotes back to literal quotes, and re-escapes those values in every output. A malformed closing quote produces a specific error instead of silently splitting the wrong records.

Does the splitter preserve leading zeros and Unicode text?

Yes. Cells stay as text throughout the workflow, so identifiers such as 007 are not converted to numbers. Accents, emoji, and non-Latin scripts remain in UTF-8 output, and downloaded files include a byte-order mark to help spreadsheet applications recognize the encoding.