How to Split Student Data Class-Wise or Section-Wise

Example student master sheet

Choose the right grouping

Split by Class

Select the Class column to create groups such as 8-students.csv and 9-students.csv. Use this when each class receives one file and sections can remain together.

Split by Section

Select the Section column to create groups such as a-students.csv and b-students.csv. This combines the same section letter across classes, so it is suitable only when that is intentional.

Split by Class + Section

Excel Split groups by one selected column at a time. It cannot directly combine Class and Section during the split. Add a new column to the source copy first:

If Class is column B and Section is column C, a spreadsheet formula such as =B2&"-"&C2 can build the label. Fill it down, confirm every row displays the expected value, and paste as values if appropriate before uploading. Then split by the new Class-Section column.

Prepare the data before splitting

• Use one consistent format: do not mix 8, Class 8 and VIII unless they are meant to be separate.
• Remove leading/trailing spaces from Class, Section and Class-Section values.
• Fill or review blank grouping cells; blanks become a separate empty-…csv group.
• Store roll numbers such as 07 or 04 in a format that preserves leading zeros, then verify the exported CSV.
• Keep the first row as clear headers and use one student record per row.

Create the class or section files

1. Work from a reviewed copy

   Keep the original master sheet unchanged. Complete any Class-Section helper column in the copy.

2. Open Excel Split

   The tool accepts XLS, XLSX and CSV and creates grouped CSV files inside a ZIP.

   Split Student Data →

3. Select the file and grouping column

   Upload the reviewed file. Enter the letter or number for Class, Section or the prepared Class-Section column. If the workbook contains several sheets, enter the exact sheet name.

4. Choose which columns to keep

   Leave the field blank to retain every column, or enter ranges such as A:E when only Student Name through Parent Name are needed.

5. Split, download and inspect

   Select Split & Zip. Open the ZIP and compare several group files with the source. Check student counts, headers, roll-number formatting and the blank group.

What the grouped files can be used for

• Send class lists to the appropriate teachers.
• Check missing roll numbers or parent details in smaller groups.
• Prepare attendance, activity or examination lists.
• Organize data before creating class-wise certificates or admit cards.

For the generic department/branch/city workflow, see how to split Excel data by column.