Skip to main content
UNSW Sydney Logo
Teaching
Mobile search
mobile nav menu button
  • About
    • Towards 2025: Strategic goals and priorities
      • Scientia Education Experience
      • Scientia Education Academy
      • Inspired Learning Initiative
      • Education Focussed Careers
      • Students as Partners
      • Student Surveys
    • More...
  • Teaching
    • New to teaching
    • Educational design
    • Assessment and feedback
    • Evaluating education
    • More...
  • Educational Technology
    • Support
    • Training
    • The Team
    • TELT Administrator
    • Feedback
    • Known system issues
  • Events & News
    • Learning and teaching forums
    • Connections seminar series
    • eBulletin news
    • More...
  • Grants & Awards
    • Awards
    • Grants
    • Gathering evidence of your teaching practice
  • Professional Development
    • Beginning to Teach (BTT)
    • Foundations of L&T (FULT)
    • Self-paced learning
    • Academic Mentoring
    • More...
  • Contact & Support
  • About
      1. Towards 2025: Strategic goals and priorities
        1. Scientia Education Experience
        2. Scientia Education Academy
        3. Inspired Learning Initiative
        4. Education Focussed Careers
        5. Students as Partners
        6. Student Surveys
      2. More...
  • Teaching
      1. New to teaching
      2. Educational design
      3. Assessment and feedback
      4. Evaluating education
      5. More...
  • Educational Technology
      1. Support
      2. Training
      3. The Team
      4. TELT Administrator
      5. Feedback
      6. Known system issues
  • Events & News
      1. Learning and teaching forums
      2. Connections seminar series
      3. eBulletin news
      4. More...
  • Grants & Awards
      1. Awards
      2. Grants
      3. Gathering evidence of your teaching practice
  • Professional Development
      1. Beginning to Teach (BTT)
      2. Foundations of L&T (FULT)
      3. Self-paced learning
      4. Academic Mentoring
      5. More...
  • Contact & Support

Breadcrumb

  1. Teaching
  2. Technologies
  3. Educational Technology
  4. Moodle
  5. Build Courses in Moodle
  6. Build Your Moodle Course
  7. Assessment Tools
  8. Gradebook

Import Grades from Excel to Moodle

Overview

As well as grading within Moodle, you can prepare all your grades and comments in a separate Excel file, which you can then upload to the Grader report area.

This page tells you how to upload such a file.

It is best practice to import only spreadsheets that were derived from exports from the Moodle Gradebook.

 

When to use

Enter marks and comments in an Excel spreadsheet offline, when you have a large quantity of assignments to mark, or if your in-Moodle marking is likely to be disrupted by a poor Internet connection.

Benefits

Teachers report that uploading an Excel file is a much faster and easier way of managing student marks and comments than entering them within the Moodle Gradebook, especially with large class sizes.

Guide

Step by step instructions

  1. In the Moodle Gradebook for the course, create a grade item for the uploaded grades to sit in if one does not already exist.
  2. Export the Gradebook of the grade item you just created.
  3. Open the downloaded Excel file and add the grades in the appropriate column. You can also add some feedback into the Feedback column.
  4. Save the Excel file as type a CSV file.
  5. In Moodle, in the Gradebook setup page, in the Settings block select Grade administration > Import > CSV file.
  6. In the Import file page, either drag and drop a file into the File box or click Choose a file and upload a file using the File picker. Then:
    • At Encoding, select the first option in the drop-down list.
    • At Separator, select Comma, if necessary.
    • At Verbose scales, if you marked using text (Pass, Fail, Credit etc.) instead of numeric grades, select Yes.
    • At Force import, if you wish to force importing check the box. It is recommended that you do not check this box.
    • Click Upload grades.
  7. In the Import preview page, under Identify user by:
    • At Map from, select Username.
    • Map to, by default, is set to Username.
  8. Under Grade item mappings, from the drop-down menu for the grade item you are importing, select the matching item.
  9. Click Upload grades.
  10. A "Grade import success" message will display. Click Continue to view the grades in the Gradebook.

Additional information

External resources

For more detailed information about uploading grades to the Gradebook, see this resource:

  • California State University Northridge, "Moodle Gradebook"

The screens in this document may look a little different from UNSW Moodle 2 screens, but the information is essentially the same.

Further assistance

If you experience technical or other issues, consult the Where to get help page.

  • MOOCs - Massive Open Online Courses
  • Access TELT Systems during a myUNSW Outage
  • Turnitin
  • Accessibility Guidelines
  • Educational Technology
    • Moodle
      • Login
      • Dashboard
      • Build Courses in Moodle
        • Orientation to Moodle
        • Request Course through myUNSW
        • Build Your Moodle Course
          • Course Design
          • Course Home Page
          • Adding Course Content
          • Assessment Tools
            • Assignments
            • Quiz
            • Gradebook
              • View the Gradebook
              • Customise the Gradebook
              • Change Gradebook Viewing Preferences
              • Hide Grades from Students
              • Manage Assignments in the Gradebook
              • Upload Grades from Excel to Moodle
              • Export Gradebook Marks, Mark Offline and Re-import
              • Reports
              • Give Feedback with Quiz Grades
              • Change Marks in the Gradebook
              • Create and Manage an Offline Moodle Assignment
            • Create a UNSW Workshop Activity in Moodle
            • Team Evaluation plugin
          • Blackboard Collaborate Ultra
          • Personalized Learning Designer
          • Team Builder
        • Bring Content into your Teaching Instance
        • Facilitate and Deliver Course
        • Uploading grades to SIMS using Astra
      • Course Administration
      • Moodle Releases
      • Moodle Upgrade Project
      • Feature Requests
      • Contacts
      • Index of all support pages
    • Lecture Recording+
    • Turnitin
    • theBox
    • Other eLearning Tools
    • Feature Requests
    • Book a Consultation
    • Digital Media Support & Equipment
    • TELT Service Status
    • Known System Issues
    • System Maintenance Windows
  • Lecture Recordings+

Events & news

LET’S Meet T1 2021
1 February 2021
More
Back to top
  • PDF
  • Share
    • Facebook
    • Twitter
    • Google
    • Email

Footer Nav

  • Contacts
  • Towards 2025
  • Events & news
  • About

Authorised by Pro Vice-Chancellor Education
UNSW CRICOS Provider Code: 00098G, TEQSA Provider ID: PRV12055, ABN: 57 195 873 179
Teaching at UNSW, Sydney NSW 2052, Australia Telephone 9385 5989

Footer menu

  • Privacy Policy
  • Copyright & Disclaimer
  • Accessibility
  • Site Map
Page last updated: Friday 18 December 2020