Export from Canvas

Canvas → Grades → Export → Export Entire Gradebook

This produces a CSV with all students and all assignment columns. Points Possible is included as row 2.

Three-step import

1

Pick the CSV file

Open via 📥 Canvas Import in the top bar → select class → browse to the CSV. All assignment columns are detected automatically.

2

Map columns to competencies & set thresholds

Each column gets a config row. The app auto-matches by name similarity (e.g. "Algorithms Quiz (12345)" → Algorithms). Set integer point thresholds: Proficient ≥ 28, Approaching ≥ 30, Mastery = 31. Check Prof. Only for assignments where Mastery is not achievable.

3

Preview and import

The preview tree shows every Canvas student matched to your roster. Students not in your system appear in red. Import is blocked until you acknowledge them. Highest-wins always applies.

New student warning

If Canvas has a student not in your roster, a blocking dialog lists their names. Add them via Roster, then re-run the import to capture their grades.

Threshold rules

Thresholds are raw integer point values — not percentages. For an assignment worth 31 points:

GradeExample thresholdMeaning
Mastery31score >= 31 → Mastery
Approaching30score >= 30 → Approaching
Proficient28score >= 28 → Proficient
(below 28)no grade written

With Prof. Only checked, only the Proficient threshold is used — scores at or above it earn Proficient, nothing higher regardless of score.

Withdrawn students

Students in your system but absent from the Canvas CSV are silently ignored — no grade is written, no error shown. This is intentional for withdrawn students.