Split Excel by Sheet
Break a workbook into one file per sheet. Choose the file format for each, and your data stays in your browser the whole time.
- Free, no sign-up
- Files stay on your device
- One file per sheet
- XLSX, XLS, ODS or CSV
- Runs on your device. Files are never uploaded.
- Free and unlimited. No sign-up, no watermark.
Split Excel workbook by sheet in three steps
No account, no email, no waiting for an upload.
- STEP 01
Add your workbook
Drop an XLSX, XLS, XLSM, XLSB or ODS file that has two or more sheets.
- STEP 02
Pick the file type
Keep the same format as the workbook, or save each sheet as XLSX, XLS, ODS or CSV.
- STEP 03
Download the pieces
Each sheet becomes a separate file, numbered in tab order and named after the sheet.
What Split Excel workbook by sheet does, and what it doesn't
We'd rather tell you up front than surprise you after the download.
What you get
- Every tab separatedNo need to copy and paste sheet by sheet or write a macro.
- Ordered, tidy namesFiles are named like report-01-Sales, so they sort in the same order as the tabs.
- Format choiceOutput matches the original or switches to XLSX, XLS, ODS or CSV.
- Private by designProcessing happens in your browser.
Good to know
- Cross-sheet formulas become valuesA formula that looks at another sheet would break in a stand-alone file, so its value is kept instead.
- Formatting is not keptColors, fonts, charts and pictures are not carried into the new files.
- Needs more than one sheetA single-sheet workbook has nothing to split. To split a long sheet by rows use Split CSV into smaller files.
Your spreadsheets never leave your device
The tool runs inside your browser instead of on our servers, so there is nothing to upload, store or delete afterwards.
Typical online tool upload
Your file travels over the internet, sits on someone else's computer for a while, and you wait for the upload and the download.
Mediaextractr no upload
The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.
When people use Split Excel workbook by sheet
Send each team its own tab
Share only the sheet that concerns each person.
Feed tools that read one sheet
Many importers only read the first tab.
Break up a big report
Turn a multi-tab workbook into separate documents.
Share less data
Avoid sending hidden sheets with sensitive numbers by splitting out only what is needed.
Mediaextractr vs typical upload tools
| MediaextractrPrivate | Typical upload tools | |
|---|---|---|
| Your file is uploaded | Never | Yes |
| Sign-up needed | No | Often, after a few files |
| Daily file limit | None | Often 1–2 free files |
| Watermark | Never | Sometimes |
| Wait for upload & download | No | Yes |
| Speed on very large files | Depends on your device | Depends on their servers |
How the files are named
The tool takes your workbook name, adds a two-digit position, then the sheet name with unsafe characters removed. Sheets called Q1 and Q2 in a file named budget would become budget-01-Q1 and budget-02-Q2.
Before you share the pieces
Splitting includes every sheet, hidden ones too. If you worry about what a workbook holds, run the Spreadsheet metadata viewer first to see all its sheets.
Want to bring pieces back together later? Merge Excel files joins them. Need only one tab as text? Extract worksheet to CSV does that directly.
Large workbooks
The whole workbook is loaded before it is split, so a file with many big sheets uses a lot of memory. If the page slows down, close other tabs, or try a desktop browser. Saving as CSV produces the smallest pieces.
Questions, answered
How do I split an Excel workbook into separate files?
Add the workbook, choose the output format and download one file per sheet.
Is the workbook uploaded when it is split?
No. Everything runs inside your browser.
Does it include hidden sheets?
Yes, all sheets in the workbook are saved, hidden ones included.
Can each sheet be saved as CSV?
Yes, choose CSV as the format for a text file per sheet.
Will formulas keep working?
Formulas inside a sheet stay. Those that refer to other sheets are replaced by their values.
Does this work on Mac, Windows and phones?
Yes, in any modern browser. Splitting a big workbook is steadier on a computer.