When to split an Excel workbook
A single file holds a dozen sheets, but each team only needs one tab—or you want to dedup, export SQL, or email attachments per sheet. Shipping the whole workbook is clumsy.
ComTools Excel Split (Tools/Excel/Split) takes one Excel file and exports each worksheet as its own .xlsx, bundled in a ZIP download.
How split works
| Item | Details |
|---|---|
| Formats | .xlsx, .xlsm, .xltx, .xltm |
| Granularity | One worksheet → one xlsx file |
| Output | ZIP archive: filename_SheetName.xlsx |
| Not supported | Split by row count; CSV split |
Example: Annual2024.xlsx with sheets Jan, Feb, Summary → ZIP containing:
Annual2024_Jan.xlsx
Annual2024_Feb.xlsx
Annual2024_Summary.xlsx
Each file contains only that worksheet, copied from the source.
Steps
- Open Excel Split.
- Upload one Excel file.
- Confirm the name in the file list.
- Click Start split.
- Download the ZIP and extract.
Common scenarios
| Scenario | Approach |
|---|---|
| Distribute tabs to teams | Split; each team gets one file |
| SQL on one sheet only | Split → open target xlsx → Excel to SQL |
| Undo a merge mentally | Inverse of Excel Merge |
| Per-sheet backup | ZIP is easy to archive |
With merge and dedup
Merge files → edit master → split → dedup/import per sheet
- Excel Merge — many files → one workbook
- Remove duplicates — on split single-sheet files
- Excel Compare — diff exports or sheets
Notes
- Row-based split (e.g. every 5,000 rows) is not supported—filter in Excel or segment CSV manually.
- Invalid filename characters in sheet names become underscores.
- Duplicate sheet names in ZIP get
_2suffixes. - A one-sheet workbook still produces a ZIP with one xlsx.
- Server-side processing—use trusted environments for sensitive data.
FAQ
Split CSV?
Not directly. CSV to Excel or save as xlsx with sheets first.
Broken formulas?
Intra-sheet formulas usually survive; references to other sheets may show #REF!—verify after split.
Too many files in ZIP?
Extract and organize; or delete unwanted sheets in the source before splitting.
Same as PDF split?
Similar idea: Excel splits by worksheet; use PDF Split for pages.