How to use Split Excel file
- 1
Drop the workbook
XLSX, XLSM, XLSB, XLS or ODS. If it has several sheets, pick the one to split in the input options.
- 2
Pick the split
Rows per file, a number of equal parts, or one part for each value of a column such as Region or Manager.
- 3
Choose files or sheets
Excel files in a ZIP give one workbook per part; “One Excel workbook” puts every part on its own sheet instead.
- 4
Download
Look through the list of parts and their first rows, then save the ZIP or the workbook.
Limits and Pro
Workbooks up to 500 MB; up to 10,000 files per split, or 500 sheets in one workbook; one sheet is split at a time.
Workbooks up to 4 GB. See Pro
About Split Excel file
This page splits one sheet of an Excel workbook into smaller pieces, each with the sheet's header row at the top. Typical jobs: sending every branch or sales manager only their own rows, cutting a price list into parts a marketplace or 1C import will accept, or breaking a long register into monthly sheets.
The rows are copied as cells, not as text, so numbers stay numbers and keep their number formats — currency, percentages, thousands separators — and dates stay real dates with the format they had. Column widths come along too. Formulas are replaced by the values Excel last calculated, which keeps a part correct even when the rows its formula referred to went to another file.
You choose the shape of the result: separate .xlsx files packed in a ZIP (handy for e-mailing each person their own file), or a single workbook with a sheet per part named Part 1, Part 2… or after the column value. The parts can also be written as CSV, with dates in ISO form (2024-05-01) and the encoding and delimiter you need.
Older .xls and OpenDocument .ods files are read as well, and the parts are always saved in the current .xlsx format. What does not carry over: cell styles such as fills, fonts and borders, merged cells, charts, pictures, comments, data validation and the other sheets of the workbook. Each part, the header included, must stay within Excel's 1,048,576 rows.
Privacy
The workbook is opened by SheetJS in a Web Worker inside this tab and the new files are assembled there too; the spreadsheet never leaves your computer and isn't stored after you close the page.