Loading page
About this tool
Split an Excel workbook into separate files — one per worksheet, by rows per file, into equal parts, or one file per column value.
Split Excel turns one workbook into several standalone .xlsx files, either by exporting each worksheet on its own or by cutting a chosen sheet into row batches, equal parts, or one file per value in a column. Worksheet names in each output are sanitised to Excel's own rules — 31 characters maximum with : \ / ? * [ ] removed — so every file opens without a repair prompt. It suits anyone who has to hand out slices of a master spreadsheet without sharing the whole thing.
Open Split Excel on AltFTool — it loads instantly in your browser.
Paste or upload your source content.
Choose the target format or conversion mode.
Copy or download the converted result.
Column names are copied to the top of each output sheet, so all parts import with the same schema.
Names are trimmed to 31 characters and stripped of the characters Excel rejects, avoiding corrupt-file warnings.
The workbook is parsed and rewritten locally with SheetJS — no upload and no server-side copy of your data.
Upload the workbook, pick a split mode and download the parts. Choosing 'Max rows per file' with 5,000 on a 12,000-row sheet gives three files of 5,000, 5,000 and 2,000 rows, each with the header row repeated; 'One file per worksheet' instead writes every tab out as its own workbook.
Yes. Select 'One file per column value' and choose the column — each distinct value becomes its own workbook, named after that value, with blank cells collected into a '(blank)' file. The split stops at 300 output files so the browser stays responsive.
No — the output files contain cell values, not formulas, charts, conditional formatting or macros. If you need calculated results preserved, that is exactly what you get, because each formula is written out as the value it evaluated to in the source file.
31 characters, which is Excel's own limit for a worksheet name. Longer group names are truncated and the characters : \ / ? * [ ] are replaced with a hyphen, since Excel refuses to open a file whose sheet name contains them.
Add the Split Excelwidget to your blog or website — free, responsive, no signup. Just keep the “Widget by AltFTool” credit link visible.
<iframe src="https://www.altftool.com/embed/widget/split-excel"
title="Split Excel — free AltFTool widget"
width="100%" height="640" style="border:0;border-radius:12px;overflow:hidden"
loading="lazy" referrerpolicy="no-referrer-when-downgrade"></iframe>
<p style="font-size:12px;margin:4px 0 0">Widget by <a href="https://www.altftool.com/tools/all/split-excel?utm_source=embed&utm_medium=widget">AltFTool — free online tools</a></p>