Split Excel by column

Create a separate XLSX file for each value in a selected column.

Processing settings

How to use Split Excel by column

  1. 01

    Select one XLSX workbook and identify the column to group by.

  2. 02

    Enter its column number, starting with 1 for column A, then run the split.

  3. 03

    Download the output files and check a sample row from each group.

Frequently asked questions

How do I choose the grouping column?

Use its position in the worksheet: 1 for column A, 2 for B, and so on. The first worksheet is processed.

Are blank values discarded?

No. Rows with an empty value in the selected column are placed together in an output file.

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 column - Free online tool | fileoar