How to Find Unenrolled Students in New Class Manager

While New Class Manager will have improved reporting in a future update, you can use this simple method with exported CSV files to view unenrolled students for now.

Step 1: Export Enrolled Students (for a Specific Season/Term)

1. Go to Class Planner → the relevant season/term from the left menu.

2. Click Actions → Export Enrollments 

3. Open the exported CSV file - this contains all students enrolled in that season/term.

    

Step 2: Export All Students

1. Go to Members → Students.

2. Click Export.

3. Open the exported CSV file - this contains all students in your system.

You should now have two files open:

• One for all students
• One for enrolled students in a specific season/term

Step 3: Prepare for Comparison

We'll now combine both files into one spreadsheet.

    1.  In your All Students CSV look at the bottom of the screen.

    2.  Click the + (plus icon) to add a new sheet/tab.

    3.  Rename this sheet: "Enrollments"

    4.  Now go to your exported Enrollments CSV file.

    5.  Select all the data then copy it:

Windows: Ctrl + A, then Ctrl + C
Mac: Command (⌘) + A, then Command (⌘) + C

    6.  Go back to the new "Enrollments" sheet you just created.

    7.  Click into cell A1 and paste:

Windows: Ctrl + V
Mac: Command (⌘) + V

You now have:

• Sheet 1 : All Students
• Sheet 2 : Enrollments (enrolled students for the selected season/term)

Step 4: Identify Unenrolled Students

Now we'll add a formula to check which students are not enrolled.

1. In the All Students main sheet (Sheet 1), scroll to the right of your existing columns.

2. Click into the first empty column in Row 1.

3. Type a column header that makes sense to you (e.g., "Enrollment Status")

4. Click into Row 2 under that header.

5. Paste the formula:
   
   =IF(COUNTIFS(Enrollments!M:M,B2,Enrollments!N:N,C2)=0,"Unenrolled","Enrolled")

6. Move your mouse to the bottom-right corner of that cell with the formula. You’ll see a small square (Excel) or circle (Google Sheets). Click and drag it down to apply the formula to all rows in your sheet.
7. Any student marked as Unenrolled is not enrolled in the selected season/term.

Final Result

Any student marked as Unenrolled is not enrolled in the selected Season/Term.

You can now:

• Use filters in Excel or Google Sheets to show only "Unenrolled"
• Or sort by Enrolment status