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 tab comes out as its own .xlsx file, with nothing from the other tabs in it.
Your file stays on this computer. There’s no upload button here, because there’s nowhere to send it. This tool runs inside the page you opened — like a calculator on a web page, it keeps working once it has loaded. How this works, and how to check it →
How to use it
- Choose your .xlsx file.
- Click Split.
- Download the files one at a time, or all together as a zip.
Questions
Is my file uploaded anywhere?
No. The whole tool is inside this page, so the work happens on your computer. There is no server to send it to. If you'd rather check than take our word for it: use the tool once, on a sample file, with the settings you want. Then turn off your wi-fi and do exactly the same thing again in that tab, without reloading. It still works, because everything it needs is already here.
Are the other tabs really gone from each file?
Yes. Each file is built fresh from one tab's contents, so the other tabs were never written into it. Use this when the others shouldn't be seen.
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.