You are now in the main content area

Export and enter grades in a CSV file

Export grade items

  1. On the Enter Grades page, click Export.
  1. Select All users from the Export Grade Items For drop-down list to export grades for all students. Select a specific section to export grades for select students.
  2. Select the Key Field you want to use to identify users.
  3. Select the Grade Values and User Details you want to export.
  4. Check off Last Name and First Name.
  5. Select the Grade Items you want to export.
  6. You have two export options:

    If you are exporting a file to enter grades and re-import, choose “Export to CSV”. You can still open this file type in Excel to enter grades. The file type must remain a .csv file in order to successfully import back into D2L.

    If you choose “Export to Excel”, please note you cannot use this Excel spreadsheet to re-import back into the D2L Grades tool. We do not recommend using this method if your goal is to work on your grades in a spreadsheet and re-import them. This option is good for saving an archive of your grades to Excel.


  1. A pop-up window will appear. Click on your file's link to download it.

Enter grade items in spreadsheet

Enter grade items in spreadsheet
  1. Once you open the exported CSV file in Excel or another spreadsheet program, you can begin entering grades for each student. For grade data to be imported correctly later, you must enter the points value under the grade item column. For example, if the max points for an assignment is 10, you will enter the number of points the student achieved out of 10.
  2. You can view the number of max points in the title of each column (e.g. <MaxPoints:10>)
  3. If you need to create a grade column for a new grade item, ensure the name of the column follows the necessary naming convention:

    Grade Item Name Points Grade <Numeric MaxPoints:10 Weight:10>

    You can change "GradeItemName" to the name of your grade item, but you MUST include "Points Grade" after the name or you'll receive an error notification upon importing the file. The MaxPoints and Weight can be adjusted appropriately.



    Note: Creating a column for a new grade item will be visible to students once imported into the Grades Tool. You can then change the visibility of the grade item to hidden, but students will receive a notification (which includes the grade value). We recommend creating and hiding the grade items in the Grades Tool first before exporting the CSV file if you want to avoid these notifications.


Overview

You can enter and calculate your grades in a third-party application, like Excel, and then import them into the D2L Brightspace Grades tool.

Below, we have outlined the process that seems to work best for our instructors.

Importing Scantron data?

You can follow the instructions below to import the data, using your preferred file (D2l-upload.csv or D2L-upload.raw.csv). The one thing you will need to do is name the new column 'GRADE1'. This can be changed after you have imported the grades.

Even before you start grading in Excel (or whichever application you prefer), it is best to create the columns in your course shell in D2L Brightspace.

We also recommend hiding the grade item (column) from all students at this stage, so you can later control when students are able to see their grades (and, subsequently, receive email Notifications).

SCANTRON: If you are importing Scantron data, you must name the column 'GRADE1'.

Even before you start grading in Excel (or whichever application you prefer), it is best to create the columns in your course shell in D2L Brightspace.

We also recommend hiding the grade item (column) from all students at this stage, so you can later control when students are able to see their grades (and, subsequently, receive email Notifications).

SCANTRON: If you are importing Scantron data, you must name the column 'GRADE1'.

Once you've entered grades and saved your CSV file, you can begin the importing process.

Enter grade items in spreadsheet
  1. In your D2L shell, go to the Grades Tool, click the Enter Grades tab, and click Import.
Enter grade items in spreadsheet
  1. Click Browse.
  2. Locate the file you want to import and click Open.
  3. Select Create new grade item when an unrecognized item is referenced if you created new grade items in the CSV file.
  4. Click Continue.
Enter grade items in spreadsheet
  1. If you created new grade items:
    • Select the Create New Grade Item check box beside each of the items you want to create.
    • Select a grade item Type.
    • Click Continue.
    • Fill in the grade items’ properties.
    • Click Continue.

    Note: Creating a new grade item in the CSV file will be active by default in D2L. You will not have the chance to hide them from students before they get a notification about a new grade posted. If you do not want grades going live right away, making them visible to students, it’s recommended that you create the Grade Item first in the Grades tool before importing so you can control the settings (see links above).

Enter grade items in spreadsheet
  1. View error and warning messages associated with the import, and click Continue.

    Note: Fields with errors are not imported.

Enter grade items in spreadsheet
  1. Preview your import and click Import.