How do you merge LMS and quiz gradebooks without student uploads?
Drop your core LMS roster export alongside one or more quiz spreadsheets, keep Smart cascade: Student ID → Email → Normalized Name active, and export a unified .xlsx or .csv file. All matching runs inside a local browser Web Worker with 0 bytes sent over the network.
Course instructors routinely reconcile scores across Canvas, Google Classroom, Moodle, Gradescope, Kahoot, and Quizizz at the end of a grading period. Keeping SIS User IDs, login emails, and exam scores in local memory supports U.S. Department of Education FERPA student privacy overview expectations without third-party cloud accounts.
Before sharing combined assessment datasets with a department team or research co-teacher, you can strip student PII into anonymous roster codes in a follow-up local step. Every imported .csv, .tsv, and .xlsx file stays confined to your own device tab.
| Platform export | Typical name columns | Identifier columns | Non-student rows skipped | Recommended matching key |
|---|---|---|---|---|
Canvas LMS (.csv) |
Student ("Last, First M.") |
SIS User ID, SIS Login |
Points Possible, Test Student |
Smart cascade or SIS ID |
Google Classroom (.csv) |
Last Name, First Name |
Email Address |
Overall Average summary row |
Smart cascade or Email |
Moodle (.csv / .xlsx) |
First name, Surname |
ID number, Email |
Empty trailing export rows | Smart cascade |
Gradescope (.csv) |
Name or First Name/Last Name |
SID, Email |
Ungraded placeholder rows | Smart cascade or SIS ID |
Kahoot / Quizizz (.xlsx) |
Player or First Name |
Optional Email |
Summary header metadata | Smart cascade or Name |
Resolving Student ID, school email, and inverted name mismatches
Spreadsheet VLOOKUP and XLOOKUP formulas break whenever one platform exports "Thompson, Maya J." and another exports "Maya Thompson" without a shared ID column. This gradebook CSV merger inspects column headers per file and reconciles identity columns before aligning assignment scores.
Cascading from SIS User ID to school login email
Under Student matching key, the default Smart cascade: Student ID → Email → Normalized Name mode checks the strongest identifier first. When two files both carry an SIS User ID, ID number, or Matric column, records link deterministically even if a student changed display names mid-semester.
If a formative quiz export from Google Forms or Quizizz omits student ID numbers, the cascade falls back to case-insensitive school email or SIS Login ID matching. For district registrar audits that forbid fuzzy matching, switch Student matching key to Strict Student / SIS ID only or School Email / Login ID only.
Normalizing Last, First names, middle initials, and accents
When a roster lacks both IDs and emails, canonicalizeStudentName decomposes accented characters using NFD rules from the Unicode Standard Annex #15 normalization specification and removes combining marks from U+0300 through U+036F. Surnames such as García and Garcia resolve to the same canonical key automatically.
The normalizer also flips comma-inverted "Last, First" strings into "First Last" order, removes parenthetical notes and suffixes (Jr., Sr., II, III, IV), and drops single-letter middle initials on 3+ token names. Once scores align cleanly, you can turn the merged sheet into 4-up score cards ready for student distribution for classroom handback.
Filtering LMS pseudo-rows and duplicate assignment headers
Raw LMS exports rarely start with pure student records on row 2. Merging gradebook CSV files without pre-cleaning often injects maximum-point metadata rows straight into your class roster.
Skipping Canvas Points Possible and Test Student summary rows
Canvas gradebooks insert a Points Possible row directly beneath the header row and append a Test Student row at the bottom of every section. Google Classroom exports frequently include an Overall Average row alongside student grades.
During mergeGradebookSheets, the row filter strips Points Possible, Overall Average, and Test Student entries automatically so they never inflate your student count or skew column averages. If you grade essays or lab reports with analytic and single-point grading rubrics, criterion columns import cleanly beside exam totals.
Inspecting unmatched roster rows and homonym warnings
As soon as 2 or more spreadsheets load, the Unified roster preview table displays up to 40 merged student rows with - markers where an assignment cell was blank or absent. The summary header reports both total unique students and how many learners matched across multiple files.
Within each uploaded spreadsheet, the engine tracks canonical names and displays a yellow alert banner whenever two rows in the same file share an identical normalized name. Checking that homonym warning ensures two different classmates named Alex Kim are linked by Student ID or Email rather than merged into one row.
Exporting master Excel workbooks and RFC 4180 UTF-8 CSVs
After verifying the preview table, Spreadsheet format lets you download either a native Excel workbook (.xlsx) or a UTF-8 CSV (.csv) named with your custom Output filename stem. Every unified export begins with three standardized identity columns: Student Name, Student ID, and Email.
Choosing between typed XLSX numbers and UTF-8 CSV files
Selecting Excel workbook (.xlsx) writes a single Merged Gradebook worksheet where numeric entries from column 4 onward are stored as true IEEE numeric values rather than text strings. If two input files share an identical header like Lab 1, the duplicate header receives its source filename in parentheses, such as Lab 1 (kahoot-quizizz-scores).
Selecting UTF-8 CSV (.csv) serializes rows according to the IETF RFC 4180 comma-separated values specification, wrapping comma-inverted "Last, First" display names in double quotes so columns never shift right. UTF-8 encoding preserves accented characters across macOS Numbers, Excel, and Python pandas scripts.
Preparing unified scores for SIS or LMS gradebook re-import
Alphabetical sorting orders the merged output by canonical name so your master sheet mirrors standard classroom roll books. When combining offline paper exams from printable OMR multiple-choice answer sheets with online homework exports, upload your primary LMS roster first so official Student Name and SIS User ID values populate every row.
Tip: Drop your official Canvas or SIS roster file first before adding Kahoot, Quizizz, or Gradescope exports so the primary
Student Name,Student ID, and