Split Excel by Column Online

Turn one master Excel or CSV sheet into separate CSV files for each class, section, department, branch, city, category, or other value. Choose the columns to keep, then download everything in one ZIP. Runs locally in your browser—no uploads and no data stored.

Local processingYour selected file stays in this browser.
Flexible groupingSplit by a column letter or number.
ZIP resultDownload distinct groups as CSV files.
or drag & drop here

All processing is done in your browser — nothing is uploaded.

Use a letter (A, B, C...) or a number (1, 2, 3...).

Leave blank to keep all columns.

If your file has multiple sheets, enter the sheet name exactly.

No file loaded
Tip: Files will be named like india-Book1.csv.

How to Use the Excel Splitter

  1. Upload your Excel/CSV file (or drag & drop it into the drop area).
  2. Enter the column you want to split by (example: K or 11).
  3. (Optional) Enter the columns you want to keep (example: A:C,E,G).
  4. (Optional) Enter a sheet name if your Excel file has multiple sheets.
  5. Click Split & Zip to download a ZIP of CSV files.

Common ways to split a master sheet

School administration: create separate files by class, section, house, or exam centre.

Office operations: organise staff or customer records by department, branch, city, or category.

Distribution: prepare smaller files for different teams without copying rows manually.

Document preparation: separate record groups before creating bulk personalized documents.

Excel & Data Guides

Follow a practical workflow for splitting a general workbook, organising student records, or preparing those records for personalized documents.

Split Excel data by columnTurn one master sheet into grouped CSV files in a ZIP. Split student data class-wiseOrganise school records by class, section, or a helper column. Generate certificates from ExcelPrepare one clean row for each certificate recipient. Create admit cards from ExcelPrepare student fields for one personalized admit card per row.

Related data tools

Standardize text caseClean names and labels before splitting. Remove duplicate linesDeduplicate a pasted list. Excel & CSV toolsSee the complete workflow hub.

FAQs

Is this Excel splitter free?

Yes. This tool is completely free to use.

Is my Excel file uploaded to a server?

No. Everything runs locally in your browser, so your file stays on your device.

What if the split column has empty cells?

Empty values are grouped into a file named empty-YourFile.csv.