You are here

Exporting grades

We recommend that you set up your grade book in Learning Environment even if you want to enter grades in a CSV or TXT file. You can then use the Export Grades option to create an appropriately structured file.

Export grade items to a CSV or Excel file

  1. On the Enter Grades page, click Export.
  2. Select All users from the Export Grade Items For drop-down list.
  3. Select the Key Field you want to use to identify users.
  4. Select the Grade Values and User Details you want to export.
  5. Select the Grade Items you want to export.
  6. Click Export to CSV or Export to Excel.
  7. A pop-up window will appear. Click on your file's link to download it.

Export grades by group or section to a CSV or Excel file

  1. On the Enter Grades page, click Export.
  2. Select the group or section you want to export from the Export Grade Items For drop-down list and click Apply.
  3. Select the Key Field you want to use to identify users.
  4. Select the Grade Values and User Details you want to export.
  5. Select the Grade Items you want to export.
  6. Click Export to CSV or Export to Excel.
  7. A pop-up window will appear. Click on your file's link to download it.

NoteGrade items that contain French characters do not display correctly in Microsoft Excel. Do not correct the characters in the CSV file if you want to import the file back into Learning Environment. Use Notepad if you want characters to display correctly.

Audience: 

  • Instructor