Favorite places of your favorite city
Home
Add to preferred sources on Google

CSV Splitter

Turn one CSV into smaller, usable parts. Choose rows per file or a precise byte limit, then download each part.

Source file

File processing happens in your browser. A sep= line is ordinary data; remove it from the source if needed.

Split settings

Input separator

Encoding and output format

Input encoding

Output line ending

Output is UTF-8. Cell values stay unchanged, but quoting and outer line endings may differ from the source.

How to split a CSV file

  1. Choose a local CSV, TSV or TXT file and set its separator, encoding and header options.
  2. Choose data rows per part or an exact byte limit. Analyze the whole file before downloading.
  3. Review part ranges and byte counts, then download individual files or a small ZIP.

What the splitter handles

  • Counts quoted multiline records as one data row and never cuts a record in half.
  • Budgets exact UTF-8 bytes, including repeated headers, quotes, line endings and each part’s BOM.
  • Preserves cell strings, their order, duplicate rows and positional headers, including blank or repeated labels.
  • Reads file slices in a worker and creates one individual part at a time.

When to use it

  • Divide a large export into batches with the same column header.
  • Fit a CSV under a file size cap measured in bytes, MB or MiB.
  • Hand off selected row ranges without copying data into a text editor.

Understand the output

A data row means one logical CSV record. A quoted cell may contain several physical lines. The optional header does not use a row quota; it stays in the first part even if repetition is off.

The size limit applies to encoded output, not input size or ZIP size. Each record, delimiter, quote, outer line ending, repeated header and optional UTF-8 BOM counts. A record that cannot fit in an empty part causes an error instead of a truncated file.

Cell strings remain unchanged, including leading zeros and Unicode. The output uses UTF-8, your selected separator and CRLF or LF. Original quoting, encoding and byte layout may change. A sep= line remains data.

Up to 100 MiB input, 2 million logical records, 256 columns, 1 million text units per record, 1,000 parts and 25 MiB per part. ZIP is limited to 100 parts, 25 MiB of uncompressed CSV and 30 MiB of archive bytes. Larger results still offer individual downloads.

Privacy and spreadsheet safety

File processing happens in your browser. The file is not uploaded by this tool. The page may make normal site requests. CSV values that resemble formulas may run in spreadsheet software; quoting is not a safety fix. Spreadsheet imports may also change long IDs or leading zeros.

CSV splitting questions

Yes by default. You can turn repetition off; the header then stays in the first part only.

Yes. It measures exact UTF-8 output bytes for each part, including its BOM, header and CRLF or LF terminators.

No. A quoted multiline record remains intact. If it cannot fit with required header and BOM bytes, the tool reports an error.

CSV Delimiter Converter

Convert CSV separators, preview real columns and spot import problems. Works locally with CSV, TSV and text; values remain unchanged.

Open tool — CSV Delimiter Converter

Compare Two CSV Files

Match rows by a key column and find added, removed and changed records.

Open tool — Compare Two CSV Files

CSV Duplicate Finder & Remover

Find exact duplicate CSV rows or repeated IDs. Review conflicting values, keep original data and download retained, removed and unresolved records.

Open tool — CSV Duplicate Finder & Remover

CSV Merger

Combine rows from several CSV files by exact column name. Preview alignment and download CSV with a merge report.

Open tool — CSV Merger