How to import grades in Brightspace

In Brightspace you can import all the grades of your students at once via a .csv file. This functionality is specially useful whenever you have an Excel or .csv file containing the grades of your students, such as a file received from Digital Examination.

In this article you will learn:

How to prepare your .csv file

Downloading the .csv file template

Not every document is valid to upload the grades. Please follow the instructions below carefully. Extra or missing information can prevent you from being able to upload your grades.

Before importing a file into Brightspace, you need to have a template file with the right format to include your grades in. To do so, the best way is to export a template file directly from your course page, fill in the grades you want to upload, and then import that file back into Brightspace.

To do so,

1. Navigate to Grades in the navigation bar. This will take you to the grades homepage

navigate to Grades in the navbar

2. Click on the Enter Grades tab

3. Click Export. This will take you to the Export Grades page

in the tab Enter grades, click Swtih to Spreadsheet view

4. Under Export Options section, select what fields you would like to include in your file. We recommend the following:

Export options

Under Key Field you can select to use either the Org Defined ID (in Brightspace this is the WUR-email-address) or Username (the WUR-account-name) or Both.

Points grade will enable you to enter the points as-is; using decimals if needed (for example enter a 7.8).

Grade Scheme will enable you to enter the output of a grade 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. 

As you already have selected the Org Defined ID, Username or Both, you don't need to select any of the User Details. 

Group Membership can be useful when entering grades that are linked to section or group based assignments, however, delete the column from your file once you have entered all the grades.

5. Scroll down to the section Choose Grades to Export

6. Select the grade items you would like to import grades to by clicking the selectboxes at the left side

Only select the grade items. Do not select Categories, Subtotals, Final Calculated Grade or Final Adjusted Grade. These cannot be imported and will prevent you from uploading your file when importing. Grade items will have a type description on the right side of the table.

select grade items

7. Click Export to CSV. This will download an Excel .csv file in your computer

8. A pop-up window will appear. Click Download

export grades completion page, click download

Editing your .csv file

Once you have downloaded the template for your grades, you can edit it to add the grades.

9. Open the .csv file you just downloaded with Excel

Your document will look something similar to this.

excel downloaded

Do not modify any of the column names of the file you downloaded. If these names are modified, the import process will not be able to properly recognise the grade items to be imported.

10. Add the grades to the Excel file under the column with the corresponding assignment name 

11. 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

Your final document should look something like this.

final document

12. Click File and save the file in your computer as .csv format following the steps in this Microsoft page

You can change the settings of Excel to shift between comma (,) or dot (.) as decimal separator. Using a dot is recommended. Read this article to know how.

Now you have a .csv file with the right format and ready to be imported into your Brightspace course. Follow to the next section to complete the importing process.

How to import your .csv file with grades

After you have created a .csv file with all the grades you want to import, you can follow these steps to complete the importing process.

1. In the grades homepage, navigate to the tab Enter Grades

2. Click on Import

in the tab Enter grades, click Swtih to Spreadsheet view

3. In the Import Grades page, click on Choose File and select from your computer the .csv file you just created

4. Click on Continue

Import grades page. Choose the file to import, select the checkbox under item creation section, click continue

You will see in the next page a summary of errors and warnings found.

  • If any errors or warnings are found, they will be listed here
  • If a student is listed in the .csv but not in the course there will be an error 'Unrecognised user'
  • If everything is fine with the file to be imported, 'No errors or warnings found' will be shown

5. Click on Continue

errors and warnings found page, errors will be shown here. Click continue

In the next screen you will see a preview of the grades to be imported. You can check that everything is fine according to the original file. If the student was already graded, an arrow indicates that the grade will be changed from a previous value to the new one (e.g. 8/10 -> 7.3/10).

6. Once you have checked that the grades that will be imported are correct, click on Import. This will complete the import process of your grades

import grades preview, an arrow will show if the grades are being modified from previous values to new ones, click import to confirm the import process

After successfully importing your grades, the message 'Imported successfully' will be shown on screen and you will be returned to the Enter Grades page.

Congratulations, now you know how to import grades via a .csv file to your course!

How to import .csv files from Digital Examination

After the students have completed their digital examination in ANS, you can download a file that contains their grades. This file has a different format than the one Brightspace platform can import, therefore it cannot directly be uploaded.  Follow the steps above to edit the .csv file before starting.

Files imported from Digital Examination in ANS, typically contain the exam information under the field Points (for total points of the exam questions) or Mark (for calculated grade of the exam), if applicable.

Before copying and pasting the grades make sure that the sorting has been done by the same value in both files (e.g. 'First Name' or 'Last name' etc.) to avoid mistakes in transferring.

ANS file

From the file, copy the column of Points /or Marks and paste it into the corresponding column on the .csv file you have previously downloaded from Brightspace. Save the file.

to paste in BS

To import this file into your Brightspace page, follow the next steps:

1. Navigate to Grades in the navigation bar

navigate to Grades in the navbar

2. Click on the tab Enter Grades

3. Click on the button Import. This will take you to the Import Grades homepage

in the tab Enter grades, click Swtih to Spreadsheet view

4. Click on Choose File and the select the .csv file that you just saved, to import

5. Select the option Create new grade item when an unrecognised item is referenced if there is no grade item with the same name as the Points/ Mark column in the .csv file

6. Click on Continue

Import grades page. Choose the file to import, select the checkbox under item creation section, click continue

You will see in the next page a summary of errors and warnings found.

  • If any errors or warnings are found, they will be listed here
  • If a student is listed in the .csv but not in the course there will be an error 'Unrecognised user'
  • If everything is fine with the file to be imported, 'No errors or warnings found' will be shown

7. Click on Continue

errors and warnings found page, errors will be shown here. Click continue

In the next screen you will see a preview of the grades to be imported. You can check that everything is fine according to the original file. If the student was already graded, an arrow indicates that the grade will be changed from a previous value to the new one (e.g. 8/10 -> 9/10).

8. Once everything is set correctly with the grades, click on Import. This will complete the import process

import grades preview, an arrow will show if the grades are being modified from previous values to new ones, click import to confirm the import process

After successfully importing the grades, the message 'Imported successfully' will be shown on screen and you will be returned to the Enter Grades page.

Congratulations, now you know how to import grades via a .csv file from Digital Examination in ANS!

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 a commas (,) or semi-colons (;) as separator.

Brightspace needs the following three components to be able to import grades from a .csv file:

  • The WUR username (in Brightspace: OrgDefinedID) or email address (in Brightspace: Username)
  • The grades listed under '<name Grade Item> <see text in infobox below>'; for example 'Assignment 1 Points Grade' will import the grades listed to the Grade Item 'Assignment 1' in Brightspace
  • The end-of-line indicator (#)

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.

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.

Username Assignment 1 Points Grade End-of-line Indicator
user001@wur.nl 9.0 #
user002@wur.nl 7.9 #
user003@wur.nl 8.0 #

For easy use, templates for both the use with WUR-accounts and WUR-email addresses are available as examples. Change the text 'Assignment 1' to match the name of the grade item in Brightspace. Also make sure that after every entry there is the # for the End-of-line indicator.

You can download these templates here: