How to split an Excel file into several files
- Add your Excel or CSV file.
- Choose how to split: by sheet, by the values of a column or every N rows.
- Click Split and download the resulting files.
You have one big table and need to send a part of it to each person: each sales rep’s customers, each school’s results, each city’s invoices. This tool does the splitting for you, with no filtering or copy and paste.
“One file per sheet” separates a workbook into as many files as it has tabs, delivered in a ZIP. “One part per value of a column” creates a group for each distinct value, such as each city: type the header name or the column letter, then choose separate files (ZIP) or sheets in one workbook. This mode uses the first sheet.
“Every N rows” cuts a very long list into chunks, useful when a platform limits how many rows you can import at once; the header row is repeated in every file.
One XLSX, XLSM or CSV file up to 300 MB, deleted automatically after 30 minutes.
Frequently asked questions
How do I pick the column to split by?
Type the header name (for example City) or the column letter (for example C).
Is the header row kept?
Yes, every part starts with the header row of the original table.
Can I get the parts in one workbook?
Yes, in column mode choose “Sheets in one workbook” instead of separate files.
How many rows can each file have?
You choose freely, from 1 to 1,000,000 rows per file.
Is it free?
Yes, free with no sign-up; your file is deleted after 30 minutes.