Split Excel Sheets - Free Online Tool

Split Excel workbook into separate files, one for each sheet

Upload Excel File

Drop Excel file here or click to browse

Support for .xlsx, .xls files (Max 10MB)

Related Tools

Compare Excel Files Excel Formula Generator Merge Excel Workbooks Trim, Clean & Convert Case Remove Duplicates Compare Two Excel Columns Excel ↔ JSON Converter Excel ↔ XML Converter EMI Calculator Age Calculator Excel ↔ CSV Converter Remove Blank Rows/Columns Format Data Income & Expense Tracker Find Duplicates Split Text (Text to Columns) Extract Email Addresses Extract Numbers from Text Word & Character Counter Change Text Case Find & Replace Text Combine Columns Remove Special Characters Add Prefix / Suffix Reverse Text Convert Text to Numbers Split Full Names Remove Extra Spaces Extract URLs Extract Text Between Characters Add Serial Numbers Transpose Data Sort Data Delete / Keep Columns CSV Viewer CSV to JSON JSON to CSV CSV to SQL CSV to Markdown Table Markdown Table to CSV Excel / CSV to HTML Table Count Unique Values Data Profiler & Health Check Percentage Calculator Percentage Change Calculator Profit Margin Calculator CAGR Calculator Discount Calculator GST Calculator

Sample Files for Testing

Download sample files to test sheet splitting:

Multi-Sheet Sample
Convert to Excel first, add multiple sheets, then test splitting

Need Help?

Having trouble with this tool? Our support team is here to help.

Contact Support

How to Use Split Excel Sheets - Free Online Tool

I'll show you how to split a multi-sheet Excel workbook into individual files, perfect for distributing data or organizing large workbooks.

Step 1: Upload Your Excel Workbook

Upload the Excel file containing multiple sheets that you want to split. The tool supports .xlsx and .xls files up to 10MB.

Step 2: Review Available Sheets

The tool will display all sheets found in your workbook with their names and row counts, helping you decide which sheets to extract.

Step 3: Select Sheets to Extract

Choose which sheets you want to convert to separate files:

  • Select All: Extract every sheet as individual files
  • Custom Selection: Pick specific sheets using checkboxes
  • Range Selection: Choose a range of consecutive sheets

Step 4: Configure Output Settings

  • File Naming: Choose how to name the output files (original name + sheet name, or custom pattern)
  • File Format: Keep as Excel (.xlsx) or convert to CSV
  • Include Headers: Preserve column headers in each file

Step 5: Process and Download

Click "Split Sheets" to process your workbook. The tool will create individual files and package them in a ZIP archive for easy download.

Step 6: Extract Your Files

Download the ZIP file and extract it to access your individual sheet files. Each file will be named clearly to identify its source sheet.

Use Cases:

  • Distribute different sheets to different team members
  • Convert multi-sheet reports into separate files for different departments
  • Extract specific data sheets for analysis
  • Organize large workbooks by breaking them into manageable pieces

Frequently Asked Questions

No, the tool cannot process password-protected Excel files. You'll need to remove the password protection first, then upload the file for splitting. This is a security limitation to protect your data.

Formulas that reference cells within the same sheet will work normally. However, formulas that reference other sheets will show #REF! errors since those sheets won't exist in the individual files. The tool preserves formulas but can't maintain cross-sheet references.

By default, files are named using the pattern "OriginalFileName_SheetName.xlsx". For example, if your file is "Sales2024.xlsx" and contains a sheet "January", the output will be "Sales2024_January.xlsx".

The tool handles files up to 10MB, which covers most business use cases. For larger files, consider splitting them manually into smaller chunks first, or contact support for assistance with enterprise-level processing.

Empty sheets (containing no data) are still processed and will create empty files. You can see the row count for each sheet before processing, so you can deselect empty sheets if you don't want empty files.

ZIP packaging makes it much easier to download multiple files at once, especially when splitting workbooks with many sheets. It also preserves file names and prevents browser download limitations.

What does this tool do?

This tool takes one Excel workbook that contains several sheets and splits it into separate files, one per sheet. It runs in your browser, so your workbook is never uploaded anywhere.

How to use Split Excel Sheets - Free Online Tool

  1. Upload the Excel workbook you want to split.
  2. The tool detects each sheet inside the workbook.
  3. Choose to download each sheet as its own file, or as a bundled set.
  4. Click Split and download your separated files.

Example

Splitting a workbook with three departmental sheets:

Before

Workbook
company.xlsx
(Sales, HR, Finance sheets)

After

Files
Sales.xlsx
HR.xlsx
Finance.xlsx

One multi-sheet workbook becomes three single-sheet files.

Excel formula alternative

Prefer a formula? You can achieve a similar result with VBA macro:

For Each ws In ThisWorkbook.Worksheets: ws.Copy: ActiveWorkbook.SaveAs ws.Name: Next

A VBA macro can export each sheet to its own file. This tool does it instantly with no macros or security prompts.

When should I use this tool?

Sending each department only its own sheet
Breaking a large workbook into shareable pieces
Separating monthly tabs into individual files
Preparing per-client files from one master workbook
Archiving individual sheets separately
Reducing file size for email attachments

Frequently Asked Questions

No. The split happens entirely in your browser, so your data stays on your device.

Yes. Each resulting file is named after the sheet it came from, so they are easy to identify.

Yes, within your device's memory. Typical business workbooks split instantly.

No. It copies each sheet's contents into its own file without altering values.

Related tools

Merge Excel Workbooks
Remove Duplicates
Remove Blank Rows/Columns
Excel ↔ CSV Converter
Compare Excel Files