Send feedback

Coming from the page: Split Excel File

One moment…

By column valueHeadings in every fileNothing uploaded

Split Excel File

Split a large file into smaller ones: one per sheet, every N rows, or one per value in a column.

Your files never leave your device: they are read and saved inside the browser.

How to split an Excel file

1

Choose the file

Choose an Excel or CSV file, or drop it in the box.

2

Pick how to split

Each sheet as a file, a fixed number of rows per file, or one file per value in a column. The parts and their row counts show before you download.

3

Download

Download one part with its button, or every part in a ZIP file.

Ways to split

WayExample
Each sheet as a fileA workbook with a sheet per month becomes 12 files, each named after its sheet.
Every N rowsA 25,000-row customer list becomes 25 files of 1,000 rows plus the headings, for a platform that accepts no more at a time.
By a column’s valueA sales report with a “Branch” column becomes one file per branch, or one sheet per branch in a single workbook.
What goes into the parts? Values, numbers, dates, number formats and column widths, and formulas as their calculated results. Colors, fonts and images are not kept. Completely empty rows are not counted when splitting by rows or by value.
Your files stay on your device. Everything runs inside your browser: your files are not uploaded to any server and nothing is kept, and the tool keeps working offline once the page has loaded.

FAQ

How do I split an Excel file into multiple files by column value?

Choose “By a column’s value”, then the sheet and the column (like city or branch). Each value gets a part with its row count, and every part has the heading row. Empty cells in that column go into an “empty” part.

Is the heading row repeated in every file?

Yes, while “First row is headings” is on. Turn it off if your file has no heading row.

How do I save each sheet as a separate file?

Choose “Each sheet as a file”: every sheet becomes a file under its name, with its merged cells and column widths.

Can I get the parts as CSV?

Yes, choose the CSV format; the files are saved in UTF-8, which keeps every character readable in Excel.

Is my file uploaded to a server?

No. The file is read and split inside your browser and never leaves your device.