Grades | How to export or import grades in Brightspace
In the Brightspace Gradebook, you can export or import all the grades of the students at once via a .csv file. This functionality is especially useful when working with other WUR systems like Osiris and ANS (Digital Examination).
This article shows how to:
1. How to Export Grades from the Gradebook
This article explains how to obtain a .csv file with the Grades from the Gradebook.
If your final goal is to add these Grades into Osiris, please follow this other article:
To export the grades from Brightspace follow the next steps:
- Click on Grades in the green navigation bar
- Click on the Enter Grades tab
- Click on Export
This will redirect you to the Export Grades page.
Under the Export Options section,
- Select the fields you would like to include in your file
We recommend the following:

Under Key Field select use the Org Defined ID, which is the student's number ID
Under Grade Values select:
- Points grade to get the points as-is; using decimals (i.e.: 7.8).
- (Optional) Grade Scheme will allow you to enter the output of a grading scheme that is used for the Grade Item directly (i.e.: Pass, Incomplete, etc.). Do not select this if you do not have text grades.
Under User Details select:
- (Optional) First Name and/or Last Name to include your students' name in the export file.
- (Optional) Email to include your students' e-mail addresses in the export file.
- (Optional) Group Membership can be useful when entering grades that are linked to a section or group-based assignments. Delete the column from your file once you have entered all the grades.
- Scroll down to the section Choose Grades to Export
- Select the grade items you would like to import grades to by clicking the select boxes on the left side
Grade items will have a type description on the right side of the table. - Click on Export to CSV
Select only the grade items.
Do not select Categories, Subtotals, Formula, Final Calculated Grade, or Final Adjusted Grade.
These items cannot be imported and will prevent you from uploading your file in case you want to import it back in Brightspace.
The pop-up window Export Grades will appear. When the loading bar shows as 'Complete':
- Click on Download

This action will download the .csv file to your computer.
2. How to Import Grades into the Gradebook
Not every document is valid for uploading the grades into Brightspace. Extra or missing information can prevent you from being able to upload the grades. Please follow the instructions below carefully.
Importing Grades into Brightspace can be a bit tricky, since the import .csv file needs to have very specific settings in order to work without errors. The best way is to Export a template file directly from the course's Gradebook, fill in the grades, and then Import that file back into Brightspace.
To do so:
- Export a .csv file following the steps on the previous section.
- Open the .csv file you just downloaded
The document will look something similar to this:

If your final document shows all information packed in the first column, select the first column entirely, and click on Data > Text to Columns. On the pop-up window, in Step 1 choose the option "Delimited". Then, in Step 2 select "Comma" and click on "Finish".
If the problem persists, check the Problem 1 in the Troubleshooting section at the end of this article.
- Add the grades to the Excel file under the column with the corresponding assignment name
- Important: Make sure your last column is named End-of-Line Indicator and includes the # symbol in all the cells of the column from the first to the last user

Do not modify any of the column names, student user codes or student emails.
Any modification will lead to errors during the import process, as the system of Brightspace will not be able to recognize the name and make the correlation.
- Save the file on your computer
For more information on how to save a workbook to a .csv format visit this Microsoft page.
Now you have a .csv file ready to be imported into your Brightspace Gradebook.
To do so:
- In the Grades page, navigate to the tab Enter Grades
- Click on Import

In the page Import Grades - Step1: Select File to Import:
- Click on Choose File and select the .csv file you just created
- Click on Continue

The next page, Import Grades - Step 2: Errors and Warnings Found, will show any errors that the import might have. If the box shows the text "No errors or warnings found":
- Click on Continue

Please note that, if you enter a Grade value that is greater than the Max Points of that Grade Item, the grade will be capped at the Max Points value.
(i.e.: The Max Points of the Grade Item is 10 but in the .csv a student has a grade of 11. It will be imported as 10).
If Brightspace finds any errors in the .csv file for the Import, it will list them on this page. You can try fixing them manually if the solution is clear.
If the solution is not clear, check the Troubleshooting section at the end of this article to know what they mean and how to fix them.
In the next page, Import Grades - Step 3: Preview Import, you will see a preview of the grades to be imported. You can occur a final check and then:
- Click on Import

If a student was already graded, an arrow will indicate the update of the grade. It will be changed from a previous value to the new one (e.g. 8/10 -> 7.3/10).
After the process completes, the message Imported successfully will be shown on the screen and you will be directed back to the Enter Grades page.
3. Troubleshooting
Problem 1: All the information packed on the first column of the Export file.
Some computers have the decimal separator shifted between comma (,) and dot (.).
To check this, on the .csv:
- Go to File
- Click on Options
- Click on Advanced
- Make sure the "Decimal Separator" is a comma (,) and the "Thousands separator" is a dot (.)
Then do the Data > Text to Columns steps again.
You can find more help about this in this article from Microsoft.
Problem 2: Possible Errors when trying to Import the .csv file into Brightspace
The most common errors you will encounter are the following:
Meaning: A student is listed in the .csv but not in the course Classlist
Solution:
- Make sure the list of students is the same in the .csv and in the Course Classlist. If any students are not in the Classlist remove them from the .csv
- If some of the grades are empty there will also be an error. Make sure all the students have a grade in the .csv
- Some rows may appear blank but still contain some data. Delete all the rows that are not part of your data set, even if they seem empty.
Meaning: Typically, this will occur due to a file formatting issue.
Solution:
- Verify that the columns are named appropriately. Make sure the name of the column includes the grade item type and max points inside the <> characters.
- Verify that the End-of-Line Indicator column is the last column in the file. There might be extra (invisible) columns after the End-of-Line Indicator. Select all the columns after this one and delete them.
- Verifying the data in the rows matches the column type. OrgDefinedId should be 'text' and the grade points should be 'number'.
More on .csv file format
CSV stands for comma-separated value, which is a type of file where data is organized in columns separated by a comma ( , ) or semi-colon ( ; ) characters.
A .csv file needs to have dots (.) as decimal separators and commas ( , ) or semi-colons ( ; ) as separators.
Files in .csv format can be created and modified with text editors or with Excel. Excel has the functionality to convert .csv files into .xlsx files.
Brightspace needs the following three components to be able to import grades from a .csv file:
- The Student Number (in Brightspace: OrgDefinedID) including a hashtag( # )
- The grades listed under the name Grade Item <Grade values info>; for example Exams Points Grade <Numeric MaxPoints: 10> will import the grades listed to the Grade Item Exams in Brightspace
- The End-of-Line Indicator (#)
OrgDefinedId | Exams Points Grade <Numeric MaxPoints:10> | End-of-line Indicator |
---|---|---|
#student.number001 | 9.0 | # |
#student.number002 | 7.9 | # |
#student.number003 | 8.0 | # |
If you have a file where the values are separated by another character different than a comma, use the function Replace all (default is Ctrl+H) to replace all list separators with commas.
Now you know how to export and import grades from and into Brightspace!
Related topics
Want to know more about Grades? Please visit:
0 Comments
Add your comment