Split Excel Files Online
Split Excel files into multiple smaller files by row count, directly in your browser.
How to split Excel files
- Drop your file onto the upload area. The tool loads it and shows the total row and column count.
- Enter the number of rows each part should hold in Rows per chunk. The default is 1000.
- Click Calculate chunks. A button appears for each part, labelled with its row range, for example Part 2 with rows 1,001–2,000.
- Click each part to download it. Every part is a separate file in the same format as the original, named with a _part1, _part2 suffix.
Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.
Worked example
An outdoor gear shop is uploading its catalogue to a marketplace that rejects files over a set row limit. Scaled down, the limit here is two products per file.
Input (Excel)
Excel workbook, first sheet (Sheet1)
| sku | title | price | in_stock |
|---|---|---|---|
| TR-100 | Trail runner shoe | 119 | true |
| TR-101 | Merino running sock | 18.5 | true |
| TR-102 | Rain shell jacket | 164 | false |
| TR-103 | Headlamp 400 lm | 42.99 | true |
| TR-104 | Hydration vest | 89 | true |
Settings
- Rows per chunk: 2
- Downloaded: Part 1 (rows 1–2)
Result
| sku | title | price | in_stock |
|---|---|---|---|
| TR-100 | Trail runner shoe | 119 | true |
| TR-101 | Merino running sock | 18.5 | true |
Five rows at two per chunk gives three parts: rows 1–2, rows 3–4, and row 5 on its own. Part 1 is shown. Each part has the full header and the rows in their original file order. The last part is smaller because the row count does not divide evenly. Nothing is dropped or repeated between parts.
Working with Excel files
Only the first sheet of the workbook is split. Each part is saved as its own .xlsx file with one sheet named Sheet1, and the header row is repeated at the top. That makes the parts suitable for systems that cap uploads per spreadsheet, or for handing different row ranges to different people. Each part is named after the source with a _part1, _part2 suffix, so the order stays clear when you share them.
Cells are read by their displayed value, so a formula contributes its last calculated result, not the formula itself. Formatting, column widths, frozen panes and other sheets are not copied into the parts. Dates keep the text they were read as, or become YYYY-MM-DD text if they loaded as real dates. Either way they are text cells, so apply a date format in Excel if you need to calculate with them. True/false cells stay as Excel booleans, and plain numbers stay numeric. Currency-formatted cells arrive as text, because cells are read as displayed, and they stay text in each part.
Frequently Asked Questions
Do the split Excel files keep my formatting?
No. Each part contains values only in a single Sheet1. Formulas become their calculated results, and fonts, colours and widths are not copied.
Can I split each worksheet into its own file instead?
This tool splits rows from the first sheet. To separate worksheets, use the Excel Sheet Extractor, which exports one sheet at a time.
Can I split by a column value, such as one file per region?
Not with this tool, which splits by row count only. Filter the file once per value instead, or use the SQL Query tool.
Do I have to download each part separately?
Yes. Each part has its own download button and saves as a separate file. There is no single zip download.
Can I split a very large file?
Files up to 50 MB can be loaded on the free tier. The whole file is read into browser memory before splitting, so the practical limit also depends on your device.
Related Tools
Validate Excel Files Online
Validate Excel file structure in your browser. Check null counts, distinct values, and data types for every column — no upload required.
Merge Excel Files Online
Merge and concatenate multiple Excel files into one, directly in your browser.
Sample Excel Files Online
Sample rows from Excel files — first N, last N, or random — directly in your browser.
Split CSV Files Online
Split CSV files into multiple smaller files by row count, directly in your browser.
Split Parquet Files Online
Split Parquet files into multiple smaller files by row count, directly in your browser.
Split JSON Files Online
Split JSON files into multiple smaller files by row count, directly in your browser.
Excel Viewer Online
View and inspect Excel files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.
Convert Excel to Parquet Online
Convert Excel files to Parquet format directly in your browser. No upload required — your data never leaves your device.