Split a file into smaller partials

How Split works

Drop one file. Pick how you want it cut (by row count, by file count, by byte size, by column value). MessyMatch parses the file in your browser, repeats the header in every partial, names the parts predictably (file_0.csv, file_1.csv, file_2.csv) and offers them as a ZIP download.

1. Load a single CSV, TSV, TXT, XLSX, JSON or SQL dump.
2. Pick a split strategy: by rows per file, by number of files, by max byte size or by the value of one column.
3. Choose the output format (CSV, TSV, XLSX, JSON, JSONL).
4. Click Split. The engine streams the file and writes every partial without loading the whole thing into memory.
5. Download the ZIP. Every partial includes the original header and a predictable name.

When people split a file

Split is built for the moment your file is too big or too unstructured for whatever needs to read it next.

• File too big for Excel

  Excel caps at 1,048,576 rows per sheet and slows down long before that. Split a 3M-row CSV into three chunks of 1M and open each independently.

• CRM or marketing import caps

  HubSpot, Salesforce, Mailchimp, Pipedrive and Klaviyo all cap rows per import. Split by row count to the limit your tool expects and import each partial in order.

• phpMyAdmin / cPanel SQL imports

  Shared hosting panels usually cap SQL imports at 50 MB or 100 MB. SQL split preserves the preamble (CREATE TABLE, SET, LOCK) in every partial so each chunk is independently importable.

• Split a list by column value

  Orders by country, customers by region, transactions by year. Pick the column and Split writes one file per distinct value, named after the value.

• Sample for testing

  Cut a clean 10k-row sample out of a million-row export. Use the sample for development and keep the original untouched.