Navigate Enrollment Roll-Up

Turn a Navigate Enrollments Report, which lists a student once per course and once per meeting time, into one row per student: a column block for each active course, one combined column for dropped courses, and optional columns for Assigned Staff relationships and categories.

Version:1.5 Released:October 14, 2026 Developed by:Josh Goldblatt using Claude
v1.5 · October 14, 2026
  • Guided Process dialog: Process now asks whether you want relationship columns before showing the relationship list, then whether you want category columns before showing the category list. Answer No to skip a list; Back returns to the previous step.
  • Categories and Tags off by default: the long original Categories and Tags text columns are left out of the export unless you tick the option. All other student columns are still included.
v1.0 · October 14, 2026
  • Initial release. Upload a Navigate Enrollments Report and get one row per student. Meeting rows for the same course combine into one "Meeting Days/Times" string; active courses become numbered column blocks (Number, Section, Instructor, Meeting Days/Times); dropped courses collapse into a single "Dropped Courses" column with a count and Last Drop Date.
  • Relationship picker and Category Manager carried over from the Navigate File Generator for CUNY: split any Assigned Staff relationship into its own column and flag any category as Yes/No. Academic Standing, Graduation Status, and Major are derived from Categories.
  • Large files: the report is read in streaming chunks and aggregated per student as it loads, so a 165 MB report works in the browser. Nothing leaves your computer.
1 · Upload

Navigate Enrollments Report

Must contain Student ID, Enrollment Course Number, and Enrollment Section Name. Optional columns that switch on extra features: Enrollment Instructor, Dropped?, Dropped Date, Class Days, Start Time, End Time, Assigned Staff, Categories. Matching is case-insensitive; the report-header lines Navigate puts above the real header are skipped automatically.
2 · Process
Upload a file first.