Home / Office & Sheets / Split Excel Workbook
Split Excel Workbook
Save each sheet as its own file, cut a long sheet every N rows, or split rows by the value in a column.
Free, no uploads, no sign-up. Runs 100% in your browser.
How Split Excel Workbook works
Files are opened in your browser with SheetJS and JSZip. Nothing is uploaded, and your original file is never changed.
Input: XLSX, XLS, ODS, CSV. Output: ZIP, XLSX, CSV.
How to use Split Excel Workbook
- Drop a workbook.
- Choose each sheet, every N rows, or by column value.
- Keep the header row on every part if you like.
- Download a ZIP of files, or one workbook with a tab per part.
Tips
- Excel, ODS and CSV all work. Formulas are read as their last saved values.
- For CSV files with odd characters, save them as UTF-8 first.
Split Excel Workbook FAQ
- Are my files uploaded?
- No. This tool runs entirely in your browser tab. Files are read from your disk into memory and the result is generated locally.
- Is it free? Are there limits or watermarks?
- Free and open source (MIT). There are no file-size caps, daily quotas, accounts or watermarks.
- Does it work offline?
- Yes, once the page (and any engine it needs) has loaded, it keeps working without a connection thanks to the service worker cache.
Related tools
- Merge Excel Files: Combine sheets from many Excel, ODS or CSV files into one workbook, or stack their rows into one table.
- CSV & Spreadsheet Editor: Edit CSV and Excel files in a fast grid: sort, filter, dedupe, find and replace, split and merge.
- Compare Spreadsheets: Find every changed cell, added row and removed row between two Excel or CSV files.
- Pivot Table: Summarise a spreadsheet by grouping rows and summing, counting or averaging values, like an Excel pivot table.