Results can be exported from gradebook in various formats, including as a spreadsheet, XML, or plain text file.

These reports can include all or a selection of grade items for all or a specified group of users.

How to download the results as a spreadsheet

  1. Navigate to your unit in LEO, then click the Grades link in the left navigation menu.
  2. Click the View tab at the top of the screen:
     The View tab in gradebook
  3. Click the Export tab:
     The export tab
  4. Click the Excel spreadsheet option. Note: if you get an error at this step, please see alternative option explained below.
  5. To export just the results of a specific group, first select the required group from the Separate groups or Visible groups dropdown box, or choose All participants.
  6. Under the Grade items to be included section, check the boxes to choose which gradebook items will be included in the report. For example, you may wish to uncheck the category totals if you wish:
     Select items to include
  7. Under the Export format options section, check the Grade export display types that you wish to be included in the report:
     Select grade display types
  8. Click the Download button, then save the file to your computer.

This downloaded file should be an Excel format file and automatically open in Excel.

How to download a spreadsheet if your unit has more than 500 users

If your unit has more than 500 users, attempting to export an Excel spreadsheet may give the following error:

Gradebook error message

You can still export a spreadsheet by following these steps:

  1. Navigate to your unit in LEO, then click the Grades link in the left navigation menu.
  2. Click the View tab at the top of the screen:
     The View tab in gradebook
  3. Click the Export tab:
     The export tab
  4. From the tabs available, choose the Plain text file option.
  5. To export just the results of a specific group, first select the required group from the Separate groups or Visible groups dropdown box, or choose All participants.
  6. Under the Grade items to be included section, check the boxes to choose which gradebook items will be included in the report. For example, you may wish to uncheck the category totals if you wish:
     Select items to include
  7. Under the Export format options section, check the Grade export display types that you wish to be included in the report:
     Select grade display types
  8. In the Export format options section, ensure the Separator setting is set to "Comma":
     Choose the comma separated type
  9. Click the Download button, then save the file to your computer.

The downloaded file will be in a CSV format, which can be opened in Excel. You may then use the Save As function in Excel to save it as an Excel format document in order to customise the formatting.

Page last updated on 20/10/2021

Service Central

Visit Service Central to access Corporate Services.


Other service contacts


Learning and Teaching
Library
Request Something

Make a request for services provided by Corporate Services.


Request something
Knowledge base

Find answers to frequently asked questions 24/7.


See Knowledge Base