Select the export you made from the Canvas Gradebook.

Check if the data is correctly separated into columns.

Your CVS export from the Canvas Gradebook is now opened in Excel and can be edited here.

Notes:

- When you use the Complete/incomplete presentation or a grading scheme **only the underlying grades** will be exported.

- A number of **read-only columns** is included in the download:

  - Current Points: Reflects points for graded assignments
  - Final Points: Reflects points for all assignments
  - Current Score: Reflects scores for graded, posted assignments
  - Unposted Current Score: Reflects scores for graded assignments and includes hidden assignments
  - Final Score: Reflects overall score including unsubmitted assignments as zero but excluding hidden assignments
  - Unposted Final Score: Reflects total score, including unsubmitted assignments as zero and hidden assignments
  - Current Grade: Reflects course grade based on graded, posted assignments
  - Unposted Current Grade: Reflects course grade based on graded assignments, including hidden assignments but excluding unsubmitted assignments
  - Final Grade: Reflects overall course grade including unsubmitted assignments as zero but excluding hidden assignments
  - Unposted Final Grade: Reflects overall course grade, including unsubmitted assignments as zero and hidden assignments

- Even when you downloaded a filtered view of the Gradebook, all read-only columns will be included in the download

When you experience problems with opening the csv-file in Excel and the way the data is separated in columns, you might want to check the Region Settings. Country and region should both be on Dutch.

Learn how to import your csv gradebook back into the Canvas Gradebook

[Manual 3: How to import your csv gradebook back into the Canvas Gradebook](https://scribehow.com/shared/How_to_import_data_to_the_Canvas_Gradebook__f3bKsONcRJiVDSXib7KG-A)

Maastrichtuniversity

Canvaslms

You can export scores from the Gradebook in Canvas and download them to your computer as a CSV file. Here we show how to open the export from the Gradebook into Excel. In this example Windows 10 and Microsoft 365 were being used.

How to open the export from the Gradebook into Excel