D2L - Export Grade Book for Web Grading | Office of Information Technology

D2L - Export Grade Book for Web Grading

Last Updated: 04/03/2017
Back to: D2L - Grades
One Column
Two Column


The following documentation demonstrates how to export your final grade book and format the .CSV file for upload into the Registrar's web grading system at the end of the semester. The Registrar's web grading system only accepts letter grades for students, so a change to the Letter Grades grading scheme may be necessary. To learn more about Grade Schemes please visit the Understanding Grade Schemes page.

This tutorial is operating system independent.

To change your courses grade scheme to Letter Grades:

  1. Click on Scheme from the Grades area.
  2. Click on the faded check mark in the Set as Default column of the Letter Grades row.

*NOTE: Be sure to double check that values for Letter Grades are consistent with the values you decide for your course (e.g. A = 94%-100%). To learn how to create your own custom grading scheme visit the Understanding Grades Schemes page.

Step 1

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

Step 2

Click on Enter Grades

Step 3

Click on Export.

Step 4

For the Export Options only select:

  • Org Defined ID
  • Grade Scheme

Step 5

Choose either Final Calculated Grade or Final Adjusted Grade (if you have manually entered adjusted grades).

Step 6

Click on the Export to CSV button.

Step 7

A new window will appear and display a link. Click on the link to download the file and save in a location on your computer.

Step 8

Open the .CSV in Excel.

Step 9

Select all of the End-of-Line Indicator column, right click and select Delete.

Step 10

Select all of the first row, right click and select Delete. The file cannot contain a header row, only Student Ids in column A and a Roster Grade in column B.

Step 11

Next the # sign must be deleted from the Student ID column. To do this for all IDs click on the Edit drop-down menu and select Replace.

*Note: For Windows users, with Office 2010, click on the Find & Select (binocular icon in Home tab) drop-down menu and select Replace.

Step 12

In the Find what: text box type #

Step 13

Do not put anything in the Replace with: column and click the Replace All button.

Step 14

Save the file in the CSV (Windows Comma Separated) format. Give your file a short name (e.g. JOUR1001-100.csv), as Web Grading can occasionally produce an error message if a file name is too long. Once you have named your file you can upload it to Web Grading


  1. Most courses have a test student named "!Student !Impersonate" in them with a student ID of 999999999. If present, the row with this ID should be deleted as well. This will eliminate an error message that appears when attempting to upload course grades. Learn more by visiting OIT's End of Semester Best Practices page.
  2. Make sure that the file format of your saved file is in the Windows CSV format and not in the CSV Macintosh or CSV MS-DOS. Only a Windows CSV will be accepted by the Web Grading system.
Back to top