How do I Import grades from an Excel (.csv) file into the Gradebook2?
Instructors can import grades into the Gradebook2 tool using a formatted .csv file. A properly formatted .csv file containing all of the student information can be downloaded first from the Gradebook2 tool under Tools / Download New item Template (See: How do I download a Gradebook2 Template?).
Use this template to add/calculate your grades in Excel (or some other spreadsheet application) then import the file back into the Gradebook2.
Example of a .csv template file with the new grade information added.
Select "No-structure gradebook (grades only)", then click Browse.
Locate the .csv file on our computer, then click Open (or Select).
Right-click the item and select "Edit this Grade Item".
This displays the Edit dialog box for this grade item.