Skip to content

FERPA-safe LMS gradebook CSV & Excel merger

Combine two or more exported gradebooks across Student ID, email and Last, First vs First Last names without uploading student PII.

Gradebook spreadsheets (0 loaded, minimum 2)

Drop 2 or more LMS / quiz gradebook files (.csv, .tsv, .xlsx)

Matches Canvas, Google Classroom, Moodle, Kahoot & Gradescope rosters locally.

How to use Gradebook CSV merger

  1. Add two or more gradebook files. Drop .csv, .tsv, or .xlsx exports onto the upload zone, or click Load sample Canvas + Kahoot CSVs to inspect a working join.
  2. Select a student matching key. Keep Smart cascade selected to try Student ID, then Email, then Normalized Name, or lock matching to one strict identifier.
  3. Review the unified roster preview. Check the matched student count, verify any yellow homonym warnings, and inspect up to 40 aligned preview rows.
  4. Export your master spreadsheet. Enter an Output filename, choose Excel workbook (.xlsx) or UTF-8 CSV (.csv) under Spreadsheet format, and download locally.

Your exam questions, student work and manuscripts stay in this browser tab on your device. Nothing is uploaded or logged.

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 Email columns inherit your authoritative institutional formatting.

Questions

What happens when two students in the same class share an identical first and last name?

When the parser encounters two rows with the same canonical name inside a single file, it displays a yellow warning naming the file and learner. If both spreadsheets include Student ID or school email columns, Smart cascade keeps those two learners separate automatically, or you can switch Student matching key to Strict Student / SIS ID only.

How are duplicate assignment column names handled across multiple CSV files?

If two imported spreadsheets contain a score column with the exact same header, such as Quiz 1 or Participation, the second column is suffixed with its source filename in parentheses. That disambiguation preserves every score column without overwriting earlier assignment grades.

Why do exported Kahoot or Quizizz scores sometimes show blank cells in the merged table?

Classroom review games often let learners enter nicknames instead of real names or institutional emails. Any nickname row that cannot match an existing SIS ID, email, or canonical name appears as a separate row at the bottom of the unified preview so you can reconcile or remove it.

Can I merge tab-separated TSV files alongside Excel workbooks and CSVs?

Yes. You can drop a mix of .csv, .tsv, and .xlsx files into the same session without converting formats beforehand. Each spreadsheet is parsed into normalized rows inside a local Web Worker and aligned into one unified table.

Which spreadsheet worksheet is read when I drop a multi-tab Excel file?

When you import an .xlsx workbook, the parser reads the first worksheet tab and treats its top non-empty row as column headers. If a game platform places raw student scores on a second tab, save or reorder that score tab to the first position before importing.

Does the exported Excel workbook store student scores as numbers or text strings?

Numeric cells in assignment columns starting at column four are written as true spreadsheet numbers inside the Merged Gradebook worksheet. Formulas such as AVERAGE, MEDIAN, and SUM calculate immediately in Excel, LibreOffice Calc, or Google Sheets without manual text-to-number conversion.

Updated