How to open the export from the Gradebook into Excel

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.

UM DLE FGB
|
9 steps
|
36 seconds

Maastrichtuniversity

Canvaslms

Open Excel on your computer or [in your browser](https://m365.cloud.microsoft/launch/Excel/).

Open a 'Blank workbook'.

Go to the 'Data' tab.

Choose to get data 'From Test/CSV'.

Select the export you made from the Canvas Gradebook.

Check if the data is correctly separated into columns.

Click 'Load'.

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

If you have trouble with how the data in Excel is separated into columns, check your **Regional Settings** (Dutch: 'Landinstellingen'). The region should both be on **Dutch**.

The CSV download includes [read-only columns](https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-export-grades-in-the-Gradebook/ta-p/809#view-read-only-columns) displaying current and final scores. Any changes made to these columns will be ignored when you re-upload the file to your course.

Find more detailed information about [importing grades the Gradebook](https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-import-grades-in-the-Gradebook/ta-p/807) in the Canvas community guide. For example, how to handle complete/incomplete assignments, Letter Grade, and GPA Scale assignments.

Learn how to import the CSV file back into the Gradebook in the following guide: [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)