Save each sheet as its own .xlsx, or cut one sheet into files by rows or column value
Processed in your browser. Nothing is uploaded. Checked against sources on 16 Oct 2026.Excel Sheet Splitter saves each sheet of an .xlsx workbook as its own .xlsx file in your browser, keeping formatting, column widths, merged cells, images and charts. Formulas that read a removed sheet become their values. Workbooks up to 200 MB split, and nothing is uploaded.
Press Select a workbook, or drop the .xlsx file on the page; its sheets are listed, all ticked.
Untick any sheet you do not need as its own file.
Leave Formulas on Keep formulas, or choose Values only to send plain numbers. To cut one sheet instead, choose Rows per file or Column value under Split by.
Press Split into N workbooks, then Download all as ZIP or each file on its own.
A workbook with one sheet per region, month or person often has to go out in pieces: each manager gets their own tab, each month is archived on its own, each client sees only their data. In Excel that means Move or Copy for every sheet, or a VBA macro.
How it works. An .xlsx file is a ZIP of XML parts joined by relationships. For each sheet the page copies the whole package and trims it: the other sheets go, along with their drawings, charts, tables and comments, and nothing else is touched. That is why every format on the kept sheet survives exactly.
What is adjusted, and why.
| In the copy | Change |
|---|---|
| Formulas reading a removed sheet | replaced by the value they showed |
| Drop-down lists sourced from a removed sheet | removed, with a count |
| Print areas and names of the kept sheet | kept |
| Names pointing at removed sheets | removed |
| A hidden sheet | made visible |
| The calculation chain | removed; Excel rebuilds it |
Formulas within the sheet stay live. Choose Values only to replace every formula by its value, which is useful when the files go to people who should see results, not workings.
One sheet into several files. Under Split by, Rows per file cuts a sheet into workbooks of, say, 1,000 rows, and Column value writes one workbook per region, branch or month in the column you pick, header row in each. These hold values and number formats only; colours, merges and formulas are not copied.
Names. Files are named after the workbook and the sheet, such as Budget - March.xlsx; characters Windows does not allow in file names become dashes. Macro workbooks keep the .xlsm extension.
Tested. Splits were checked by reading every output with ExcelJS, a separate spreadsheet library, for values, styles, widths, merges and formulas, and by checking that no relationship points at a missing part. Nothing is uploaded.
Drop the .xlsx file on Excel Sheet Splitter. Every sheet is listed and ticked; press Split into N workbooks and each sheet becomes its own .xlsx named after the workbook and the sheet, such as Budget - March.xlsx. Download them one by one or all together as a ZIP.
Yes. Each new file is a trimmed copy of your workbook rather than a rebuilt one, so fonts, colours, number formats, column widths, merged cells, frozen panes, images, charts and tables on the kept sheet stay exactly as they were. Only the other sheets and the parts that belonged to them are removed.
A formula such as =SUM(Sales!B2:B9) would show #REF! once the Sales sheet is gone, so it is replaced by the value it last showed. Formulas that only use their own sheet stay live. Choose Values only to turn every formula into its value, which is safer for files you send to others.
Drop the workbook, choose Rows per file or Column value under Split by, then pick the sheet and the number of rows or the column. Each new workbook gets the header row and its rows in order, for example one file per region. Values and number formats are kept; colours, merged cells and formulas are not copied.
Macro workbooks (.xlsm) split and keep their macros and extension. Old .xls files must first be saved as .xlsx in Excel, and a workbook with an opening password must have the password removed under File, Info, Protect Workbook. The page says which case applies.
No. The workbook is unpacked, trimmed and packed again by your own browser, and the new files are created on your device. Nothing is sent to a server, which matters for payroll, client lists and accounts. Up to 200 MB works in a browser tab.
Rates and rules change; check the source before you rely on a figure.
Still stuck? Ask about Excel Sheet Splitter and anybody who knows can answer. No account needed.
Same job, other tools: Word to Plain Text – Take the words out of a .docx and leave the formatting.
On the related tools: Convert Any File – Photos, documents, spreadsheets, archives: drop it and see what is possible.