Did You Know? Canvas Gradebook CSV Export (with some exciting updates)!

Filed in Canvas, gradebook by on January 19, 2022

Are you a Microsoft Excel pro? Do you live and breathe spreadsheets with complicated functions and formulas?  Then this pro tip is for you!

Canvas has the ability to export your course Gradebook to Excel and then allows you to import the CSV back into Canvas for students.

Some of the benefits of this are:

1) Perform more complicated spreadsheet functions
2) Be able to work offline and out of the web browser
3) Keep an archive of student grades at a specific point in time

How to do it?

Click the Actions menu [1], then click the Export link [2].

click actions then export to download gradebook csv file

When the export is completed, Canvas will download the CSV file automatically to your computer.

To import a CSV back into Canvas, click the Actions menu, then click the Import link.

Recent Updates to Gradebook Exports

Split Student Names

The Gradebook View menu in individual courses now displays the Split Student Names option, which displays student names as last name first.

When student names are split, the Last Name column can still be sorted by type and order and supports secondary info.

Split names are respected and displayed in the Gradebook CSV export.

If a user has a preferred name that is different from their legal name, the legal name will be displayed.

canvas gradebook showing split first name and last name

Import Final Grade Override

The instructor can now use the CSV export file to enter and upload final grade override scores.

As with other CSV changes, changes to the final grade overrides column display in the import confirmation page, which allows instructors to verify the final grade override scores before they are uploaded to the Gradebook.

Changes to final grade override scores also reflect in the Gradebook history.

Note about Total Score and Current Score columns in Gradebook CSV Export

The Total Score displayed in the Gradebook reflects each student’s score at the time of viewing, taking into account whether the instructor has hidden assignment scores, assignment due dates, etc.

The CSV download includes read-only columns for current and final scores.

Current score reflects the total while ignoring unsubmitted assignments, and the final score counts unsubmitted assignments as zero.

Assignments with hidden scores are unposted grades and shown in separate columns for unposted current score and unposted final score, respectively.

If you have any questions about using Canvas Gradebook, please email us at canvashelp@wpi.edu.

Additional Resources

Using Gradebook Exports

Tags: , , ,

Comments (2)

Trackback URL | Comments RSS Feed

  1. Dana says:

    Thanks so much! Sorry, but would you be able to import just a column of grades, perhaps just say the ‘final lab grades’ or something like that?