There are many tables within Moodle that you would like to generate reports from but don’t have an export function attached. This tip allows you to import any web page data table into a spreadsheet to run reports. In Moodle this works with the gradebook, participant lists, assignment module, etc, allowing staff to generate their own reports. You can also apply this to other web sites.

Moodle Spreadsheets

How to do it:
To import any Moodle (or Web in general) tables into a spreadsheet:

• Open a new blank Spreadsheet
• Choose Import Data from External Website
• Copy and Paste the URL of the table in Moodle (make sure you login within import window)
• Import the data
• Format to suit your reporting needs

You can now use Moodle data in a spreadsheet to generate your own reports.  This should work for any table and/or page to which you have access.