1. Home
  2. Spreadsheets & Data
  3. Split Excel & CSV Files

Split Excel & CSV Files

Split a spreadsheet into multiple files by row count, column value or sheet.

For every format and option in one place, use Excel & CSV Workbench →

Runs in your browser · No upload
Open a file and choose how to split (N rows, column value or N equal parts) and how to save. Check file names and row counts in the result list, then download.

Operations

Split the table by row count, column value or file count into a ZIP or several sheets.
The header row repeats in every file. Up to 500 results.
Files are processed in your browser and never sent to a server.

How to use

  1. Drop an .xlsx, .csv or .tsv file, or paste cells copied from Excel. This page opens with a Split into files step already added.
  2. Choose Split by: N rows per file, column value, or N equal parts.
  3. Choose Save as: ZIP (several xlsx files), ZIP (several csv files) or one xlsx file (several sheets).
  4. Check each file’s (or sheet’s) name and row count in the split results list under the preview.
  5. Download to get original_split.zip. The sheet mode produces a single original_cleaned.xlsx.

Ways to split

Mode Setting Result
N rows Rows per file Cuts N rows at a time from the top and puts the leftover rows in the last file. Names are filename_01, filename_02… (sales.xlsx gives sales_01)
Column value Column to split by One file per value, in order of first appearance, named after the value (sanitized)
N equal parts Number of files Divides the rows by N and the first files take one extra row each. If there are fewer rows than files, you get one file per row

The header is repeated in every file. With a 10-row table (not counting the header):

  • 4 rows per file → three files of 4, 4 and 2 rows (Split into 3 files (2–4 rows each))
  • 3 equal parts → 4, 3 and 3 rows (the one leftover row goes to the first file)
  • 100 equal parts → only 10 rows exist, so you get 10 files of 1 row

File naming rules

When you split by column value, the value becomes the file name. Characters that cannot be used in file names | \ / : * ? " < > | and control characters | turn into _, surrounding spaces and trailing dots are removed, and only 80 characters are kept. So a/b becomes a_b, and an empty value (including a cell with only spaces) becomes a (blank) file. If sanitizing makes two names equal (a/b and a_b, or names differing only in case) they get (2), (3). Spaces around a value are ignored for grouping, but the cells themselves are not edited.

Choosing a format

  • ZIP (xlsx): one single-sheet xlsx per file, each with a bold header, fitted column widths and the text-column settings.
  • ZIP (csv): the delimiter, encoding (UTF-8 BOM by default, CP949 optional) and line ending from the export settings below apply to every file, and characters CP949 cannot represent become ? with the count reported.
  • One xlsx file (several sheets): the pieces become sheets. Sheet names follow the 31-character limit and the []:*?/\ rule.

Good to know

  • Results are capped at 500. If a column has 501 or more distinct values, or the rows-per-file setting would make more than 500 files, you get an error; raise the number and try again.
  • An Excel sheet holds at most 1,048,576 rows, so a larger CSV is easier to open in Excel once split by N rows.
  • With splitting as the last step, export becomes a ZIP; adding another step after it drops the split and continues with the original table. Put sort, filter and dedupe steps before the split.
  • The original table is not changed, and nothing is converted to numbers when reading, so leading zeros survive.

Your file is processed only in your browser and is never sent to a server.

Can't find the tool you need?

Tell us what you want to do. We build the most requested tools first.