Excel & Data

How to Split Excel Data into Separate Files by Column

Have one master spreadsheet but need a separate file for every department, branch, city, class, section or category? Use the grouping column once and download all results in one ZIP.

Before → action → after

Before

One XLS, XLSX or CSV containing every record.

After

One ZIP containing a CSV for each distinct value in the selected column.

Example: split a team list by department

Assume the source file is named team-directory.xlsx and its first row contains headers:

NameDepartmentCity
AaravSalesDelhi
MeeraHRMumbai
KabirSalesDelhi
RiyaFinanceChandigarh

Splitting by Department creates a ZIP with CSV files such as:

  • sales-team-directory.csv — Aarav and Kabir
  • hr-team-directory.csv — Meera
  • finance-team-directory.csv — Riya

The tool exports CSV files, even when the source is XLS or XLSX. Workbook formatting, formulas, multiple sheets and other Excel-only features are not carried into each output CSV.

Clean the grouping column first

Each distinct cell value becomes a group. Small differences can therefore create extra files:

  • Sales, sales and Sales can be treated as different values.
  • Class 8 and 8 are different groups.
  • A blank grouping cell is included in a separate file whose name begins with empty-.

Before splitting, choose one spelling and format, remove accidental spaces, and decide whether blank rows should be completed or excluded. Work on a copy of the spreadsheet so the original stays available.

Split the file

  1. Identify the grouping column

    In the example, Department is column B, so the tool accepts either B or 2. Only one grouping column is selected for each split.

  2. Open Excel Split

    The tool supports XLS, XLSX and CSV input and performs the split in your browser.

    Split Excel by Column →

  3. Select the source file

    Choose or drag in the spreadsheet. The first row is used as the output header. If an Excel workbook contains multiple sheets, enter the sheet name exactly; otherwise the first sheet is used.

  4. Enter the split column

    Enter the column letter or 1-based number. Optionally enter the columns to keep, such as A:C,E. Leave that field blank to keep every column present in the selected sheet.

  5. Create and download the ZIP

    Select Split & Zip. The download contains one CSV per distinct group. Similar filenames are given safe numeric suffixes instead of being silently combined.

  6. Inspect the output

    Open at least one CSV from every group. Check headers, row counts, blank groups, dates, identifiers with leading zeros, and any fields that previously depended on Excel formatting or formulas.

Things to check before sharing the files

  • No unexpected empty-…csv file was created.
  • Spelling and capitalization did not create duplicate-looking groups.
  • Every output contains the header and expected columns.
  • Dates, long numbers and leading-zero identifiers still display as intended.
  • The ZIP and several representative CSVs open correctly.

Continue this workflow

Splitting school records?

Use the same tool to separate students by class or section, including a practical method for class-and-section groups.

How to Split Student Data Class-Wise →

Need personalized PDFs instead of separate spreadsheets? Continue to generate certificates from Excel or create admit cards from Excel.