How to Export Gradebook Data to a CSV File

All information from a gradebook, including the original point values, grade scheme symbols and ‘out of’ grades can be exported to a .CSV file which can be opened with Microsoft Excel, OpenOffice and many other spreadsheet applications.

  1. Go to your course. In your courses navigation bar, click the ‘Grades‘ link.
  2. At the top of the ‘Enter Grades‘ page, select the ‘Export Grades‘ icon.
    Enter Grades - Export
  3. The ‘Export Grades’ page will appear.
    Grades Export options

    1. By default, the ‘Export Grade Items For’ field is set to ‘All users’. Leave it as set.
    2. To export all available information, for the ‘Key Field’ heading, select the ‘Both’ radio button.
    3. Select the Grade Values you wish to export. Suggested are ‘Points Grade’ and ‘Grade Scheme’.
    4. Select the ‘User Details’ you wish to retain.
  4. Select the Grade Items you wish to export. To select individual items, select the checkboxes to the left of each grade item. The background of the item will turn light blue. To select all items, select the checkbox to the left, above the ‘Grade Item’ heading. Make sure to choose the Final Grade you wish to export.Choose Grades to Export
  5. Select the ‘Export to CSV’ button at the bottom of the page to export.
  6. A window will open, with a link to save the .CSV file to your computer. Select the link to download the file.
    Export_Grades_Link

Notes on the export process:

  • Text items can not be exported.
  • Selectbox grade items will not export the label. Instead the lowest percentage in the scheme range is exported.

Also, remember that the exported file may contain sensitive information such as private student information. Always store the file on a university maintained, secure, password protected location.