Getting the Canvas Gradebook as a spreadsheet

Many times it is useful to have your gradebook as a spreadsheet (for example, to realize complex grading schemes, to plot results of education activities, ...). One obvious way is to export the Canvas Gradebook as a CVS file. However, this does not give you the contents of custom columns (which you might have created in your gradebook - for information about how to do this and an example of how to import custom columns in from a CSV file see the pages starting at https://kth.instructure.com/courses/11/modules/items/9112 ).

An alternative is to export all of the information that lies behind the Canvas Gradebook using the Canvas API, then use this information to construct a .xlsx file (which you can load into Excel or other spreadsheet programs). Not only can you find the final grade for each assignment, but you can see each of the attempts and grade events along the way. For details see: https://kth.instructure.com/courses/11/pages/exporting-gradebook?module_item_id=17416 

Note that the program also includes the custom columns and makes an entry for a fake student aaaMAXIMUM to provide information about the maximum number of points for assignments that have different numbers of points.