Split Excel
Turn one workbook into several files: one file per sheet, or a large sheet broken into parts by rows.
Your converted file will appear here.
What gets copied
Each new file keeps the cell values from the original sheet, with the header row repeated when splitting by rows. Formulas are saved as their calculated values, and formatting such as colours and merged cells isn’t carried over, so the result is a clean data file that imports reliably.
How to use the Split Excel: step by step
- Choose an Excel workbook.
- Choose to split into one file per sheet, or one sheet into parts by rows.
- Set the rows per file if splitting by rows.
- Split and download the files.
A real example
A CRM accepts imports of up to 5,000 rows, and your contacts sheet has 18,000. Split by 5,000 rows and you get four files, each with the header row, ready to import.
Tips for better results
- The header row is repeated in every part when splitting by rows.
- Formulas are saved as their calculated values.
- Formatting such as colours isn’t copied.
More questions
Can I split a CSV?
Use Split CSV for CSV files.
Frequently asked questions
Is my file uploaded anywhere?
No. The file is read and converted by your own browser, so it never leaves your device. That makes it safe for customer lists, finances and other private data.
Which Excel formats are supported?
Modern .xlsx and .xlsm files, older .xls files and OpenDocument .ods spreadsheets. The split files are saved as .xlsx.
Are formulas kept?
Formulas are converted to their current values. That keeps each part self-contained, because formulas often refer to rows that end up in a different file.