Grades may be pasted directly from an OpenDocument or Excel spreadsheet with format as follows:

* At least one column should contain user identity data - username, email address or ID number.
* Other columns should have headings as for existing activities or grade items.

A correctly formatted spreadsheet can be obtained by first exporting some grades. The spreadsheet can then be edited to add more grades and saved.

Select and copy the columns you want to import from the spreadsheet and then paste them into this field.