Split Excel File

Break a large workbook into manageable pieces.

Split by sheet, by the value in a column, or by a fixed number of rows. Each piece keeps the header row and the original formatting, and everything downloads as a single zip with predictable file names.

Price
Free
Your files
Never uploaded
Runs
In your browser

or drag it here

.xlsx, .xls, .csv · up to 50 MB · processed locally, never uploaded

Excel and spreadsheet files only. Export from Google Sheets as .xlsx or .csv.

Files stay on your device

What it does well

  • Split by column value — one file per region, department or client
  • Header row repeated in every output file
  • Naming templates using the split value, index and original file name

How to use Split Excel File

  1. 1

    Upload the workbook you want to split.

  2. 2

    Choose the split mode: per sheet, per column value, or every N rows.

  3. 3

    Set the file naming pattern.

  4. 4

    Download the zip containing every part.

Watch a walkthrough

How to use Split Excel File

2 min 18 s · captions included

Watch on YouTube

Common problems and fixes

Hundreds of tiny files were produced.

The split column has high cardinality. Pick a coarser column, or use the row-count mode with a larger chunk size.

The zip is missing some groups.

Groups with a blank key are skipped by default. Enable “Include blank group” to get them as a file named _blank.

Frequently asked questions

More merge & split tools

Combine dozens of workbooks into a single file, or break a large workbook into per-sheet, per-value or fixed-size chunks in seconds.

Browse Merge & Split