D2L - Import Grades | Office of Information Technology

D2L - Import Grades

Last Updated: 08/19/2015
Back to: D2L - Grades
One Column
Two Column


The following documentation demonstrates how to import a grade book into Desire2Learn. The imported file must be in .CSV format and adhere to specific column label and other requirements. For guidance on how to create a file that will successfully import grades, please visit the Importing/Exporting a CSV Best Practices page.

This tutorial is operating system independent.

Step 1

Log into your course and in the Assessments drop-down menu click on Grades.

Step 2

Click Enter Grades.

Step 3

Click Import.

Step 4

Click on the Choose File or Browse button depending on your operating system.

Step 5

Locate the file you wish to upload and click Open.

Step 6

The Import File field should now contain your CSV file. Click Continue.

*Note: If your file fails to import, refer to the Importing/Exporting a CSV Best Practices page in order to ensure that your CSV file is formatted correctly.

Step 7

Review the list of new grade items to be imported and check that they have the Create New Grade Item box checked. Once reviewed click Continue.

Step 8

At the Step 3: New Grade Item Properties screen, make sure to select the following:

  • Category: None
  • Max. Points: Match the maximum number of points in your gradebook.
  • Can Exceed: You can choose not to set the Max. Points and then select the Can Exceed checkbox.
  • Bonus: Select if you are treating i>clicker scores as a "bonus" item in the gradebook.

Click Continue.

Step 9

At the Step 4: Errors and Warning Found screen, confirm that there are no error or warnings and click Continue.

Step 10

At the Step 5: Preview Import screen, review your imported data and select Import.

Step 11

You will be returned to the Enter Grades User List, where you can see your new import data.

Back to top