Split a spreadsheet into multiple files — by row count or by a column’s value.

Everything runs in your browser — your file never leaves your device.

Drop a spreadsheet here
XLSX, XLS, CSV, TSV or ODS
Split by
Every N data rows become a new file.
Rows per file
Column
Output format
Nothing to split yet Upload a spreadsheet and choose how to split it.
Parts

Tip: splitting by a column value is great for breaking a big list into per-category files.


About Split Spreadsheet

Split Spreadsheet breaks one file into many, right in your browser. Upload an XLSX, XLS, CSV or ODS file and split it either by row count — every N data rows become a new file — or by column value, which groups rows into one file per distinct value in a column you choose.

Each resulting part is listed with its own preview, and you can download a single part or grab everything at once as a ZIP. An option repeats the header row in every part, so each split file remains usable on its own.

Splitting by column value is the standout: turn one big list into per-country, per-category or per-owner files in seconds. A sanity cap warns you before a split would create an unreasonable number of files, and since the work happens client-side, your data never leaves your device.

How to use Split Spreadsheet

  1. Upload the spreadsheet you want to split (XLSX, XLS, CSV or ODS).
  2. Choose the mode: by row count, or by the values of a column.
  3. Set the rows per file, or pick the column to group by.
  4. Enable “Repeat the header in every file” so each part stands alone.
  5. Preview the parts, then download one file or all of them as a ZIP.

Frequently asked questions

No. The split is computed entirely in your browser — the parts and the ZIP are built locally, so the data never touches a server.

Yes, splitting spreadsheets is completely free with no limits on file count downloads.

Row count slices the sheet mechanically — every N data rows start a new file. Column value groups rows logically — one file per distinct value in the chosen column, ideal for per-category or per-region exports.

Yes, if you enable the repeat-header option: the original header is copied to the top of every part, so each file opens as a complete, self-describing table.

The tool caps the number of parts and warns you before proceeding. Increase the rows per file, or split by a column with fewer distinct values, and run it again.

Use “Download all (ZIP)” — every part is packaged into a single ZIP archive built in your browser. Individual parts can also be downloaded one by one.


Popular searches
split spreadsheet split csv file split excel by column split sheet by rows divide csv online break up spreadsheet
Need help?
Found an issue with this tool? Let our team know.
Report an issue

Add this free tool to your own website — copy and paste the code below.