Sign up free

Split an Excel Workbook into Separate Files

Turn one big workbook into separate files by sheet, by a column's values or by row count, or give each value a sheet of its own.

More tools
WordMerge WordSplit WordCompress WordCompare WordFind and Replace in WordDelete Blank Pages in WordWatermark WordProtect WordUnlock Word
Excel security & sizeCompress ExcelWatermark ExcelProtect ExcelUnlock Excel
PowerPointMerge PowerPointSplit PowerPointCompress PowerPointWatermark PowerPointProtect PowerPointUnlock PowerPoint
All Office filesOffice ViewerExtract Images from OfficeRemove Document Metadata

or drop files here

Accepts XLSX

Encrypted upload. Files are deleted automatically after 1 hour.

About Split Excel

Split Excel workbooks when each sheet needs to go to a different person, when a national list has to be cut into one file per region, or when an import tool accepts only a limited number of rows. Pick Sheets, Values in a column or Number of rows, and you get a ZIP with one XLSX per part. To combine the parts again later, use Merge Excel.

Splitting by sheet keeps everything: formulas, formatting, column widths, merged cells, charts and pictures. A formula that pointed at a sheet no longer in the file keeps its last value instead of breaking. Splitting by a column adds two choices. Under Put each part, pick In its own file or On its own sheet in one workbook, where every value gets a sheet with the header row and the cell formatting copied and the header frozen. For separate files, File type can be Excel (.xlsx) or CSV, saved as UTF-8 so Excel opens it correctly. The column and row modes work on the first sheet and write its values, with the header row at the top of every part.

How to use Split Excel

  1. 1
    Upload the workbook

    Click Choose file or drop an XLSX on the page. Save XLS files as XLSX first.

  2. 2
    Choose how to split

    Select Sheets, Values in a column or Number of rows.

  3. 3
    Set the column or size

    For a column, enter its letter, its number or its header as it appears in row 1, like C, 3 or Region, then choose where to Put each part and the File type. For rows, enter Rows per file; the default is 1,000.

  4. 4
    Click Split Excel

    Download all parts as one ZIP, pick single files from the list, or take the one workbook with a sheet per value.

Why use Cubfile for this

  • One file per sheet

    Each sheet becomes its own workbook with formulas, styles, charts and pictures intact.

  • A file or a sheet per value

    Every distinct entry in the chosen column gets its own file, or its own sheet in one workbook, up to 500, and empty cells are grouped as (blank).

  • Even chunks of rows

    Cut a long list into files of the size you set, each named with its row range, like orders_1001-2000.xlsx.

  • Excel or CSV parts

    Parts by value can be UTF-8 CSV files that Excel opens without garbled text, and in Excel parts the header row stays frozen at the top.

FAQ

Split Excel: questions and answers

Does Split Excel keep formulas and charts?
When you split by sheet, yes. Each file is the original workbook with only that sheet left, so formulas, charts and formatting stay. Splitting by column or rows writes the values, and with On its own sheet in one workbook the cells keep their formatting as well.
How do I split Excel data by a column like Region?
Choose Values in a column and enter the column's letter, its number or its header as it appears in the first row, for example C, 3 or Region, whichever way the parts are saved. Each region then ends up in its own file named after the value, or with On its own sheet in one workbook, on its own sheet of a single workbook. If some entries in that column carry stray spaces, trim them first with Excel & CSV Cleaner.
Why can't I split by sheets?
Your workbook has only one sheet. Use Values in a column or Number of rows instead.
Can I split an Excel file for free?
Yes. Visitors get 2 tasks in total and free accounts 2 a day for workbooks up to 50 MB, while VIP takes files up to 1 GB with no daily cap.
Is my spreadsheet data safe while it's being split?
Your workbook is uploaded over HTTPS, split in an isolated process and deleted, along with every part, one hour later. Nobody here opens it.
Share Split Excel with a friendIt runs in any browser, and they can try it without signing up.

Related tools

DOC Office ViewerOpen Word, Excel and PowerPoint files in the browser, no Office needed.
XLS Compare ExcelFind every changed cell between two spreadsheets.
DOC Compare WordHighlight every insertion, deletion and change between two documents.
XLS Compress ExcelMake workbooks smaller by shrinking images and dropping cached data.
PPT Compress PowerPointShrink presentations full of big photos.
XLS Excel & CSV CleanerTrim spaces, drop empty rows, fix number and date text in one go.
XLS Remove Duplicates in ExcelFind and remove duplicate rows by all columns or the ones you pick.
XLS Merge ExcelCombine workbooks into one file: as sheets, or rows appended.