Moodle Grade Importer
The teacher drops in a Moodle grade export and their own Excel gradebook. The tool matches students by ID and columns by name, shows its proposed matches for a quick review, then writes the scores straight into the gradebook without disturbing its formatting or formulas.
FEATURES
- Takes a Moodle export (CSV, Excel, or ODS) and an Excel gradebook, and lets the teacher pick which class sheet to fill
- Finds the header row and the student ID column in both files automatically, even with multi-row headers, and normalizes ID formats so they match
- Suggests a gradebook column for every Moodle column, color-coded by confidence, with a dropdown to correct or skip any match
- Matches students by ID regardless of order and reports anyone in Moodle who isn't in the gradebook
- Shows a summary of students, columns, and cells before anything is written
- Writes scores straight into the Excel file, preserving styles and formulas, never overwriting a formula cell, and skipping Moodle's "-" placeholders
- Imports several Moodle files into different sheets in one session, then downloads a single updated gradebook
- A single offline HTML file with its libraries built in, so it runs without internet access or installation
All names and data shown in the screenshots are fictional.