Split Excel File

About this tool

This free tool splits a spreadsheet into several smaller files. Upload one .xlsx, .xls, .ods or .csv, choose how to cut it, and download every piece in a single ZIP.

It all happens in your browser — the file is never uploaded, so a customer list or payroll export never leaves your computer.

Two ways to split

• Every N rows — cut a long sheet into equal chunks: 500 rows per file for an import that has a row limit, or 1,000 per file to hand out in manageable pieces.
• One file per value in a column — the useful one. Pick a column and get one file per distinct value in it: one file per region, per department, per salesperson, per date. The rows are grouped automatically and each file is named after the value.

The header row is repeated in every file, so each piece opens as a complete, usable spreadsheet rather than a headless block of data.

Choose the output format

Download the pieces as Excel (.xlsx) files if people will open them, or as CSV files if they are going into another system. Either way they arrive in one ZIP, named after the original file and the part or column value.

Features

• Split by row count or by the value in any column
• Reads XLSX, XLS, XLSM, XLSB, ODS and CSV, and writes XLSX or CSV
• Repeats the header row in every output file
• Multi-sheet workbooks — pick which sheet to split
• See the exact list of files and row counts before you download
• Everything zipped in your browser — nothing uploaded
• No sign-up, no row limit, completely free

Common uses

• Break a big export into chunks small enough for a system that limits rows per import
• Send each region, branch or manager only their own rows
• Split a contact list into batches for a mail merge or an email platform
• Cut a year of transactions into one file per month or per category

How to use it

• Upload the spreadsheet — click the upload area or drag your file in
• Choose the sheet — if the workbook has more than one tab
• Pick how to split — every N rows, or one file per value in a column
• Choose the format — Excel or CSV — and check the list of files
• Download all as ZIP