...
- Export your spreadsheet as a CSV file
- Go to the Moodle course gradebook → Import tab→ CSV File tab
- Select and upload your grade file.
You will then need to configure the "map" each column in the spreadsheet you are uploading.
- Use the student id number field to match up with the useridnumber field in Moodle. This will make sure that the grades in your spreadsheet are matched with the correct student in Moodle.
- Since we are using id number to match the student information, you can ignore student name and email information.
- For each grade column in the spreadsheet, you can select whether you want to create a new grade item, match to an existing Moodle grade item, or ignore.
For each new grade columns you want to import, select the option to create a new grade item. If you are importing grades but have already created a Moodle grade item for that activity, match the new grade item to the existing activity. If you have extra columns in your spreadsheet that you don't want to import, select the ignore option.
More information can be found on Moodle's Grade Import help page.