Worksheet Splitter
Export every sheet in a workbook as its own file.
One click turns a 40-sheet workbook into 40 files. Each sheet keeps its formatting, column widths and print setup, and file names come from the sheet names so nothing needs renaming afterwards.
- Rating
- 4.8(966)
- Monthly uses
- 118K
- Price
- Free
or drag it here
.xlsx, .xls, .ods · processed locally, never uploaded
Files stay on your device
What it does well
- Per-sheet selection so you can export just the ones you need
- Column widths, freeze panes and print areas preserved
- CSV mode for feeding data pipelines
How to use Worksheet Splitter
- 1
Upload the workbook.
- 2
Tick the sheets you want exported — all are selected by default.
- 3
Choose XLSX or CSV output.
- 4
Download the zip of individual files.
Watch a walkthrough
Common problems and fixes
An exported sheet is empty.
Its content came from formulas referencing other sheets. Enable “Convert cross-sheet formulas to values” before exporting.
File names have odd characters.
Sheet names containing / \ : * ? are sanitised. Rename the sheets, or switch the naming pattern to use an index.
Frequently asked questions
What people say
Handled a file with well over 200,000 rows without complaining. That is more than I can say for the desktop add-in we pay for.
Small thing, but the error messages actually tell you what to fix. Worksheet Splitter flagged a hidden character that had been breaking my lookups for weeks.
Exactly what I needed. Worksheet Splitter used to be a twenty-minute job with a macro I did not trust; now it takes one drag and one click.
More merge & split tools
Combine dozens of workbooks into a single file, or break a large workbook into per-sheet, per-value or fixed-size chunks in seconds.
Browse Merge & Split