1. Export Grades
  2. Prepare your file for import
  3. Import Grades

You can enter grades into a spreadsheet and import them into D2L Brightspace using a .csv, .tsv or .txt file. You can also create new grade items through an import file by adding a column to the file. Any grades you import for discussion grade items and assignment grade items are also synchronized back to Discussions and Assignments. To view an example of a .csv file that is ready for importing, see the Sample Import File.

NOTES:
  • Only Numeric, Pass/Fail, Selectbox, and Text grade items, and the Final Adjusted Grade can be imported.
  • The import file must follow a standard format. See D2L’s File Format for Importing Grades for more information.

Export Grades

You can export grades from your Brightspace gradebook to an Excel or CSV file.

  1. Log in to Brightspace using your MyCarletonOne credentials. 
  2. On the Brightspace homepage, locate your course in one of the following ways:
      • Click on the course tile under the My Courses widget.
      • Click the Course Selector Grid  and select the course from the drop-down menu. If you are enrolled in more than 20 courses, you can search for the course name using the search bar.
  3. In the navbar, click Progress.
  4. In the drop-down menu, select Grades.  
  5. Click the Enter grades tab. 
  6. Click Export.
  7. Configure the following export options:
    • Export Grade Items for: Select All Users or Groups from the drop-down menu.
    • Key Field: Org Defined ID is selected by default, meaning that the export will identify students by their ID. You can select username, or both to customize the export.
      NOTE: If you intend to import the file back into the same or another course page, select the Both option for the exported document. Brightspace requires both key fields to complete the import.
    • Grade Values: Points grade is selected by default.
    • User Details: Select any additional identification options you want to include in the export.
  8. Scroll down to Choose Grades to Export, then select or deselect the grade items you want to export.
  9. Click Export to CSV or Export to Excel.
  10. When the export is complete, click Download.                 

You will now be able to open the exported file on your computer. Where you access the downloaded file is dependent on your Operating System and browser. 

Prepare your file for import

WARNING: The import file must follow a standard format. See D2L’s File Format for Importing Grades for more information.

  1. Save your Excel workbook (e.g. your .xlsx file) as a .csv file by clicking File > Save As.
  2. Select the file format extension .csv, then click Save.

Import Grades

NOTE: If you are exporting and importing grades across course pages for a full-credit course, there are various settings that may need to be adjusted depending on how your gradebooks are set up. Please contact TLS to request a consultation.

  1. Log in to Brightspace using your MyCarletonOne credentials. 
  2. On the Brightspace homepage, locate your course in one of the following ways:
      • Click on the course tile under the My Courses widget.
      • Click the Course Selector Grid  and select the course from the drop-down menu. If you are enrolled in more than 20 courses, you can search for the course name using the search bar.
  3. In the navbar, click Progress.
  4. In the drop-down menu, select Grades.  
  5. Click the Enter grades tab. 
  6. Click Import.
  7. Click Choose file.
  8. Select the .csv file you want to import, then click Open.
    TIP: You can opt to select the Item Creation checkbox if you would like to create a new grade item when an unrecognized item is found in your file.
  9. Click Continue.You will see a Processing… message while your file is loading.
  10. You will see a page displaying any errors and warnings that were found. Click Continue.
  11. You will see a preview of the new grades for each student. Click Import.

You will see an “Imported Successfully” message and your imported grades will appear under the Enter Grades tab of your gradebook.

Was this page helpful?

5 people found this useful

Still need help? Contact us