Skip to site content
Skip to page footer

Exporting Gradebook Data to a .CSV File

Step-by-step instructions

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 is openable with Microsoft Excel, OpenOffice and many other spreadsheet applications.

  1. Go to your course. In your courses navigation bar, click the 'Grades' link. An example navigation bar is provided here.
  2. At the top of the 'User List' page, select the 'Export Grades' icon.
  3. The 'Export Grades' page will appear.
    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 green. 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.
  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.

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.