Split

CSV Splitter

Break a large export into smaller files, or separate it by region, status or any other column. Every output file starts with the header row, file names are made safe, and multiple files come in one ZIP. Everything is processed in your browser; your data is not uploaded.

Back

1. Data and split settings

Local only

Processed in your browser; your files and data are not uploaded or stored. Formulas, macros and scripts in your data are never run.

2. Files to create

Live preview

CSV downloads use safe export by default: cells starting with =, +, -, @, a tab or a carriage return get a leading apostrophe so spreadsheet apps treat them as text.

Data is processed in your browser's memory. Limits: 20 MB per file, 200,000 rows, 1,000 columns and 3,000,000 cells. At most 500 output files.

About this tool

About CSV Splitter

CSV Splitter breaks a CSV or TSV table into smaller files, either every N data rows or one file per distinct value in a chosen column. Each output keeps the header row, file names are made safe, and several outputs are packaged into one ZIP.

Imports often limit how many rows a file may contain, and teams often need their own slice of a shared export. Splitting by hand means copying headers again and again. This tool does it consistently and shows every file it will create before you download.

How to use

Step by step

  1. Upload or paste the table.
  2. Choose split every N rows or split by column values.
  3. Enter the number of rows, or choose the column.
  4. Check the list of files, their names and row counts.
  5. Download a single CSV or a ZIP of all files.
Key features

What it offers

  • Split every N data rows
  • Split by the values in one column, case-sensitive or not
  • Header row repeated in every output file
  • Safe, unique file names
  • ZIP download for multiple files
  • Limits on output file count with clear messages
Best practices

Tips for best results

  • Check the row limit of the system you are importing into.
  • Split by a column with a manageable number of distinct values.
  • Clean stray spaces first so "North" and "North " end up together.
  • Keep the original file until the split files are verified.
Benefits

Why people use it

Headers kept

Every file is ready to import on its own.

One download

Many files arrive in a single ZIP.

Private

Splitting happens on your device.

FAQ

Common questions

Enter how many data rows each file should have, for example 1,000. The header row is added to every file and is not counted. The last file holds whatever rows remain.
Choose a column and every distinct value gets its own file, such as sales-North.csv and sales-South.csv. Rows keep their original order within each file. Empty values go into a file named …-blank. You can treat values case-sensitively or not.
Characters that are not allowed in file names (such as / \ : * ? " < > |) are replaced with dashes, spaces become dashes, names are shortened to 60 characters, and duplicates get -2, -3 suffixes so no file overwrites another.
When more than one file is produced. If the settings produce a single file, it downloads directly as CSV or TSV.
Yes, 500 output files. If a column has more distinct values than that, or the row count is too small, the page asks you to change the settings.
Safe export (on by default) adds an apostrophe in front of any cell that starts with =, +, -, @, a tab or a carriage return, so Excel, LibreOffice and Google Sheets show it as text instead of running it as a formula. This includes values such as -5. Choose raw export only for files read by programs; the preview always shows exactly what will be downloaded.
No. Splitting and ZIP creation happen in your browser. Nothing is uploaded or stored.
Private by design

This runs entirely in your browser

No file or text you enter here is uploaded. Encoding and decoding happen on your device using native browser APIs — close the tab and nothing remains on a server.

Install Toolisco Add it to your device for offline, one-tap access.