How do I export grades in the New Gradebook?

Document created by Canvas Doc Team Employee on Nov 18, 2017Last modified by Canvas Doc Team Employee on Mar 10, 2018
Version 7Show Document
  • View in full screen mode

You can export scores from the Gradebook and download them to your computer as a CSV file.

Notes about CSV files:

  • Some columns that appear in the CSV file are read-only columns calculated by rules or percentages set in Canvas. Any changes made to these columns will be ignored when you re-upload the file to your course.
  • Currently the CSV file downloads all data regardless of filter(s) and settings shown in the Gradebook.
  • For assignment group columns, changes made to assignment scores will automatically be included in the assignment group calculation in the Gradebook.
  • The Total Score displayed in the Gradebook reflects each student's score at the time of viewing, taking into account whether the instructor has muted assignments, assignment due dates, etc. Therefore, the CSV download includes read-only columns for current and final score. Current score reflects the total while ignoring unsubmitted assignments, and the final score counts unsubmitted assignments as zero.
  • If a student has submitted an assignment multiple times, the CSV file only accounts for the most recent submission.
  • The notes column is not included in the Gradebook CSV export file.
  • Concluded and inactive enrollments are not included in the CSV file unless their respective option, Show Concluded Enrollments or Show Inactive Enrollments, is enabled in the Gradebook Settings menu.
  • Complete/incomplete assignments are shown as full or no credit (e.g. for a 10-point assignment, 10 or 0).

Open Grades

Open Grades

In Course Navigation, click the Grades link.

Export Scores

Export Scores

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

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

Export current scores

If you navigate away from the page during the export, the CSV file will appear as a previous download in the Actions menu so it can be downloaded again. The Gradebook will show the date and time you requested the export.

If you made changes to the Gradebook after exporting a file and want to export a new file, click the Export link again.

Note: Gradebook export files include the date and time of the download to differentiate between multiple exports. The export filename format is YYYY-MM-DDTHHMM, followed by the course name.

Edit Scores

Edit Scores

Edit the scores in Microsoft Excel. Make sure to save the file as a CSV file type.

Once you have made changes, you can upload it to your course.

You are here
Table of Contents > Instructor > How do I export grades in the New Gradebook?