Home › Excel tools › Split Excel sheets
Runs in your browserSplit an Excel workbook into separate files
A workbook with one tab per client, per month or per region eventually has to be broken up — usually because one of those tabs needs sending to someone who shouldn't see the others. Each sheet comes out as its own .xlsx, and because nothing is uploaded, the tabs you're separating are never transmitted anywhere either.
How to use it
- Choose your .xlsx file.
- Click Split.
- Download the sheets individually or all together as a zip.
Questions
Is my file uploaded anywhere?
No. This page contains the whole tool — the JavaScript that does the work runs inside your browser tab, on your own machine. There is no server to upload to. You can confirm it yourself: open your browser's developer tools, switch to the Network tab, and run the tool. You will not see your file go anywhere. You can also disconnect from the internet after the page loads and it will still work.
Are the other sheets really gone from each file?
Yes. Each output is a new workbook built from one sheet's contents, so the others were never written to it. This is the relevant difference from deleting tabs and saving a copy, where remnants can survive in the file.
What happens to formulas that referenced another sheet?
They become their last calculated value. A formula pointing at a sheet that no longer exists in the file would show as an error, so the value is written instead — which is almost always what you wanted when separating tabs.
Is formatting preserved?
Cell values are, formatting largely isn't — colours, column widths and conditional formatting don't survive. If the appearance matters more than the data, duplicate the file in Excel and delete tabs instead.