Split Excel File Members

Split an Excel workbook into separate files: one per sheet, every N rows, or by the values of a column.

This tool is available to registered members

Create a free account or sign in to use this tool. Registration is free and takes less than a minute.

Your data is processed in your browser and is not uploaded to our servers.

About the Split Excel File

Split Excel File turns a large workbook into smaller files. Create one file per sheet, split a sheet every N rows with the header row repeated in each file, or create one file for each distinct value of a column (such as city or department). The resulting files are bundled in a single ZIP, as XLSX or CSV.

How to use the Split Excel File

  1. Drop an Excel file into the box.
  2. Choose how to split, plus the sheet and the column or number of rows.
  3. Click "Split and download" to get a ZIP file.

Frequently asked questions

Is the header row repeated in every file?

Yes, when "First row is a header" is on, both when splitting by rows and by column values.

What format are the resulting files?

XLSX or CSV, as you choose, bundled in one ZIP file.

Is the file uploaded?

No. The split runs in your browser.