How do I Import grades from an Excel (.csv) file into 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.
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.
Go to Gradebook.
Select Gradebook2 from the Tool Menu in your site.
Select No-structure gradebook (grades only), then click Browse.
Locate the .csv file on our computer, then click Open (or Select).
Edit the item.
Right-click the item and select Edit this Grade Item.
This displays the Edit dialog box for this grade item.