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.
Note: Grades must use the same grading system (Points / Percentages / Letter Grades) as you have chosen for your Gradebook.
Go to Gradebook.
This displays the Gradebook2 tool.
Click Tools / Import
This displays the Gradebook2 Import dialog box.
Select "No-structure gradebook (grades only)", then click Browse.
This displays your computer's file locator.
Locate the .csv file on our computer, then click Open (or Select).
This returns the display to the Import dialog box.
Click Next.
This displays the contents of what will be imported into the gradebook.
Click Next.
This uploads the data and adds a new item to the Gradebook.
Right-click the item and select "Edit this Grade Item".
This displays the Edit dialog box for this grade item.
Place the item in the proper Category (if you are using categories) and checkmark "Include in Grade", then click Save/Close.
The grade item and the grades are now properly listed in the Gradebook.
Example:
