Export Grades from Canvas for Calculation

(last updated on 6 January 2025)





Part 1: Export Grades from Canvas


  1. Click the Grades link from the course navigation;
  2. Click the Export button (select "Export Entire Gradebook" or "Export Current Gradebook View") to download the CSV file to your computer.

Note: Please download two copies of the CSV files, one for modification and the other as a backup.







Part 2: Modify exported Grades in Microsoft Excel


You can Edit Scores on the exported CSV file in Microsoft Excel, then Upload Scores to Gradebook of the Canvas course. Please read the below Canvas instructions.




If you are preparing to upload scores to i-Assessment, please follow the next steps.


  1. On the exported CSV file in Microsoft Excel, input the calculated CA (Continuous Assessment) and/or Exam scores if necessary;


  2. To change the CSV file to the acceptable format for i-Assessment,
    • remove unnecessary columns, keep "SIS User ID" and the score columns to be imported;
    • remove two rows which have no student record (between the header row and the first student record row);
    Note: If auditing students exist in the CSV file, please remove their records before importing the file to i-Assessment.


  3. Rename the header cell variables,
    • change [SIS User ID] → [Student ID];
    • confirm the scores to be imported as [CA] and/or [Exam];
    • add 3 more header cells: [Final Mark] [Final Grade] [Online Exam (Off-campus)];

    Below is the result example:
    Student IDCAExamFinal MarkFinal GradeOnline Exam (Off-campus)
    5XXXXXXX92.791.5
    5XXXXXXX8987.91
    5XXXXXXX75.2862.25
    (remark about scores: up to 2 decimal places are allowed when importing to i-Assessment)


  4. Save the CSV file [Save as type: CSV (Comma delimited) (*.csv)].






About i-Assessment


Our Digital Learning Support Team has no permission to access i-Assessment, so we cannot answer further questions about it. Please read the below information.

  • The user guide is provided within i-Assessment. Eligible users can access it by clicking the Help icon link from the top navigation menu in i-Assessment.
  • If you have questions about i-Assessment, please contact the following offices.
    • ARRO for undergraduate programmes/degrees/courses
    • SGS for postgraduate programmes/degrees/courses
  • More information about i-Assessment is located on the Information Technology Services website.