Export and Import Grades

In this article, you will find a step-by-step plan on how to export grades from Brightspace and how to import the grades. 

See here a video on Import Grades

The Export Grades function does not only allow you to transfer grades from Brightspace into other systems, e.g. uSis, but it also provides a way to export a classlist of your course. 

Import Grades can be used to transfer Grades from other systems into Brightspace, or you can use the export and import function to update student grades on your local computer and get them back into Brightspace!

Export Grades
  1. Click on Grades in the navbar of your course.
  2. Click on Enter Grades.
  3. Click on Export
  1. Select whether you want to export all student data or just from 1 group or section.
  2. Select your preferred sorting
  3. Select the Grade Values you want to export:
    • points grade = the number of points the student received
    • Optional: weighted grade = the weight of that grade item
    • Optional: grade scheme = is the symbol (actual grade) the student received for that grade item according to the used grade scheme
  4. Select the user details you want to export
  5. Select the grade items you want to export by checking the corresponding boxes
  6. Finally export to either CSV or Excel to your own preference
Import Grades

The most easy way to import Grades, is by exporting the Gradebook first. Please follow the steps below in order to import Grades correctly.

Step 1: Export grades

  1. Click on Grades in the navbar of your course.
  2. Click on Enter Grades.
  3. Click on Export

Step 2: The settings of the export-file

  1. Select whether you want to export all student data or just from 1 group or section.
  2. Choose how to sort your data
  3. Only tick the bog Points Grade under Grade Value
  4. DO NOT CHECK any other User Details
  5. Select under Choose Grades to Export which grade items you would like to export.
  6. Finally click on Export to CSV

We discourage everyone to use the option Export to Excel. Preparing the file for import is a lot more complicated when you have to work with an Excel-file compared to a CSV-file. 

Step 3: Open and edit with Excel

  • Open the downloaded csv-file in Excel.
  • Select the first column and navigate to the header Data in Excel. Click on the option Text to Columns.
  • In step 1 of this Wizard, choose for the file-type Delimited
  • Check under Delimiters only Comma, make sure that Tab is unchecked.
  • When the settings are correct, click Finish. 

Now that you have made a clear table of your students and the Grade Items, you can start to fill in the grades. 

Step 4: Preparing the file for import

Correctly saving the file:

  • Save the file as Text (Tab Delimited).txt
  • Excel then gives a warning relating to the extension. Indicate that you want to retain the format.
  • Close the file.
    • When you try to close the file, Excel gives a warning stating that the file needs to be saved again. Click on Don't Save.

Step 5: Importing to Brightspace

  1. Click on Grades in the navbar of your course.
  2. Click on Enter Grades.
  3. Click on Import.

Importing Step 1: uploading the txt file

  1. Click on Choose File to upload the Text (Tab Delimited).txt
  2. Click on Continue.

Importing Step 2: possible errors

  • If everything went well, you should see the above-displayed screen.
  • Click on Continue

Importing Step 3: Preview

  • In the last screen you can see a preview of the import.
  • Adjusted grades will always be displayed the following way: old grade -> new grade
  • Click on Import to complete the Import. 

You are done!

Video on Import Grades