Map Extract
Free tool

Split an Excel file by sheet, by rows or by a column

Open a workbook and break it into separate files. Give each sheet its own file, cut a long sheet into chunks of a set size, or make one file per value in a column, such as a file for each town or each sales rep. Everything downloads together as a ZIP.

Runs in your browser. Nothing you enter is uploaded.

One lead list, a file per town and per rep

A sheet of five leads with town and rep columns. Splitting By a column's values on town gives four files, sorted by name. The slash in Bath/Bristol is not allowed in a file name, so it becomes an underscore.

Splitting the same sheet on the rep column gives three files, and the lead with no rep goes into a file called (blank), so nothing is dropped. Every file keeps the header row.

Input
business,town,rep
Kiln & Co Pottery,Frome,Asha
Marlow Print Works,Bath,Ben
Oak Lane Joinery,Frome,Asha
Pip & Parsnip Deli,Wells,
Tanner's Yard Cafe,Bath/Bristol,Ben
Result
By town:
leads-Bath.xlsx           1 row
leads-Bath_Bristol.xlsx   1 row
leads-Frome.xlsx          2 rows
leads-Wells.xlsx          1 row

By rep (CSV):
leads-(blank).csv  1 row
leads-Asha.csv     2 rows
leads-Ben.csv      2 rows

Splitting a workbook

  1. Choose how to split

    One file per sheet, Every N rows or By a column's values. A single-sheet file switches to every N rows automatically.

  2. Open the file

    XLSX, XLSM, XLS, XLSB, ODS and CSV are accepted.

  3. Set the details

    Pick the sheet to split, then the Rows per file (1,000 by default) or the Column whose values decide the files.

  4. Choose the format

    Save as Excel or CSV. CSV files include a byte order mark so Excel reads accented characters correctly.

  5. Check and download

    The figures show the number of files, sheets in the book, rows in the sheet and the largest part. A list shows each file name and its row count. Press Download as ZIP.

Handing out territories and batches

Splitting by column is the quick way to share a prospect list fairly: one file per rep or per area means nobody sees, or calls, another person's leads. Check the column first for spelling variations, because Frome and frome become two files and a trailing space makes another. A column with hundreds of different values triggers a warning so you do not download hundreds of tiny files by mistake.

Splitting by rows suits import limits and campaign waves. Splitting by sheet is handy when a client sends one workbook with a tab per region and you need them as separate attachments.

  • Values are exported as they display; formulas become their results.
  • Formatting, charts and pictures are not carried into the new files.
  • File names come from the workbook name plus the sheet, chunk or value, up to 60 characters.

Questions people ask

How do I split an Excel sheet into multiple files by a column?

Open the workbook, choose By a column's values, pick the sheet and the column, such as town or account manager, and download the ZIP. Each different value in that column gets its own file with the header row and every matching row. Blank cells are grouped into a file called (blank).

Can I split each worksheet into its own file?

Yes. Choose One file per sheet and every sheet in the workbook becomes a separate Excel or CSV file, named after the workbook and the sheet. That is useful when a workbook has a tab per region, client or month and each needs sending separately.

How do I split a large spreadsheet into smaller ones?

Choose Every N rows, set Rows per file to the size you need, and download. Each part has the header row plus up to that many data rows. Use this to fit a CRM or email platform import limit, or to plan outreach in equal batches.

Are formulas kept when splitting?

No. The split files contain each cell's displayed value, so a formula's result is kept but the formula itself is not. That keeps each part self-contained, because a formula that referred to another sheet would break once the sheets are in different files.

Where your data goes

The workbook is read with an open-source spreadsheet library inside your browser, and each part is written on your device. No sheet or row is uploaded.

Checked against the tool on

Top