Export Gradebook Data

Relevant to: faculty and staff

This article contains information considered accurate at the time of publishing. Technology updates, changes in University security practices, policies and procedures may effect the information in this article - updates to articles are scheduled on a periodic basis and will address any required changes.

Introduction

The university recommends that you set up your grade book in Brightspace even if you want to enter grades in a CSV or Excel file. You can then use the Export Grades option to create an appropriately structured file.

How to Export Grades

  1. In the course navbar, select Course Menu and then select Grades.
  2. On the Enter Grades tab, select the Export button.
  3. In the Export Options area, do the following:
    • From the Export Grade Items For drop-down list, select who you want to export grade items for.
    • Select the Key Field you want to use to identify users.
    • From the Sort By drop-down list, select the sorting order of the fields that appear in the exported file.
    • Select the Grade Values and User Details you want to export.
  4. In the Choose Grades to Export area, select the grade items you want to export.
  5. Select the button Export to CSV or Export to Excel. A pop-up window appears. Select the file link to download it.

Note: If a student is enrolled in multiple groups within a Group Category, or multiple sections within a course, those enrollments are exported as a comma-separated list within a cell.

Print Article