Split Excel by rows

Divide the first XLSX worksheet into smaller files by data-row count.

Processing settings

How to use Split Excel by rows

  1. 01

    Select one XLSX workbook and enter the number of data rows per file.

  2. 02

    Split the first worksheet; each part includes its header row.

  3. 03

    Download the files and check the row counts in the first and last parts.

Frequently asked questions

Does each split file include the column headers?

Yes. The first row is copied as the header in every output file and is not counted as a data row.

What if splitting would create too many files?

The tool stops when it would create more than 200 output files. Increase the rows per file and try again.

You may also need

Excel to CSV

Convert the first worksheet of an XLSX file to a UTF-8 CSV for data import.

CSV to Excel

Turn a UTF-8 CSV into an XLSX worksheet while keeping entries as text.

Merge Excel files

Append rows from XLSX files with matching headers into one worksheet.

Split Excel by rows - Free online tool | fileoar