Split one Excel sheet into several files

A company-wide sheet to hand out by department, or a huge export to cut into chunks: drop it in, choose “By a column’s value” and click the column — every distinct value becomes its own file (blanks get their own) — or “By row count” and set the size. Every part keeps the header. Download a ZIP (one Excel per part) or a single workbook with a sheet per part.

Runs in your browser · no upload · no sign-up

怎麼用

  1. 1 Drop an Excel or CSV file
  2. 2 Choose split by value or by row count
  3. 3 Download as a ZIP or one workbook

能做

  • By value: one file per department or city
  • By rows: every N rows
  • Every part keeps the header
  • ZIP of files, or one workbook with many sheets

不能做

  • Formats, colours and formulas are not kept
  • No splitting by a combination of columns
  • File names come from cell values; special characters are replaced

常見問題

What about blank values?

Rows with a blank in that column go into their own part, named “(blank)”.

How are files named?

By value: the cell value (e.g. “Sales.xlsx”); by rows: “Part 1, Part 2…”.

Does each part keep the header?

Yes, every part starts with the original header.

How many parts can it make?

No limit — by value, you get as many parts as there are distinct values.

How does this differ from Split CSV?

This outputs Excel and can split by value; Split CSV cuts big CSVs by row count and keeps CSV.

Is the file uploaded?

No, it all happens in your browser.