Grades export or import into D2L Brightspace

Importing the Grade book

Instructors can enter grades in another application and import them into D2L Brightspace using a CSV or TXT file. You can also create new grade items through an import file by adding a column to the file. The import file must follow a standard format.

Create import CSV or text file

The import file must include three columns in order to import the file into the grade book:

1. OrgDefinedId or Username 
   You must provide a Username or Org Defined ID (or both).
2. <Grade item name> Points Grade 
   This is the name of the grade item (e.g. Quiz 5 or Midterm) followed by Points Grade, Grade Symbol, or Text Grade.
   Note: These grade item column(s) have numerical, symbols, or text in the cells. 
3. End-of-Line Indicator
   This column has a pound/hash # symbol that indicates each row contains data.
   

Import the file

1. On the Enter Grades page, select Import.
2. On the Import Grades page, select Browse.
3. Locate the file you want to import and select Open.
4. Select Continue.
5. On the Step 2 screen, view error and warning messages associated with the import, and select Continue.
   Note: If you get an error message, the file will need to be edited. You may get a message that the there is an "Unrecognized users" error.
6. On the Step 3 screen, preview your import. 
7. Even if a message displays "No items found", select Import.

Export grade items to a CSV or Excel file

1. On the Enter Grades page, select Export.
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. Select the Grade Items you want to export.
5. Select Export to CSV or Export to Excel.
6. A pop-up window will appear. 
7. Select Download after the export is complete.
8. Open the file on your device.

Export Classlist data to a CSV or Excel file

You can use these actions to export the student classlist along with their group and section enrollments in one list.

1. On the Enter Grades page, select Export.
2. Select the Key Field you want to use to identify users.
3. Select the User Details you want to export: Last Name, First Name, and Email. 
4. Select the Section Membership and Group Membership options. 
5. Clear the Grade Items to exclude them from the export.
6. Select Export to CSV or Export to Excel.
7. A pop-up window will appear. 
8. Select Download after the export is complete.
9. Open the file on your device.