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.
![Example of a .csv template file with the new grade information added.](https://media.screensteps.com/image_assets/assets/006/005/038/original/24c6ef20-750e-4b31-9492-291062da7bea.png)
Note: Grades must use the same grading system (Points/Percentages/Letter Grades) as you have chosen for your gradebook.
Go to Gradebook.
Select Gradebook2 from the Tool Menu in your site.
Click Tools > Import.
![Click Tools > Import.](https://media.screensteps.com/image_assets/assets/006/005/040/original/67d0798e-b37c-400f-968c-a5ecc631292d.png)
This displays the Gradebook2 Import dialog box.
Select No-structure gradebook (grades only), then click Browse.
![Select No-structure gradebook (grades only), then click Browse.](https://media.screensteps.com/image_assets/assets/006/005/042/original/1a186bd2-f2cc-4a39-99a7-d9522bc24397.png)
This displays your computer's file locator.
Locate the .csv file on our computer, then click Open (or Select).
![Locate the .csv file on our computer, then click Open (or Select).](https://media.screensteps.com/image_assets/assets/006/005/044/original/ca4a10c8-d9ae-40ee-bc25-35e4acca2d52.png)
This returns the display to the Import dialog box.
Click Next.
![Click Next.](https://media.screensteps.com/image_assets/assets/006/005/046/original/9c6c836d-f54b-41ba-b49c-4dac2ccef679.png)
This displays the contents of what will be imported into the gradebook.
Click Next.
![Click Next.](https://media.screensteps.com/image_assets/assets/006/005/048/original/6e3f6950-e3c8-4bd4-b7fa-a25afbccd468.png)
This uploads the data and adds a new item to the Gradebook.
Edit the item.
Right-click the item and select Edit this Grade Item.
This displays the Edit dialog box for this grade item.
Update the item category.
![Update the item category.](https://media.screensteps.com/image_assets/assets/006/005/052/original/05414da5-8988-4496-84db-6df898700949.png)
Place the item in the proper category (if you are using categories) and check the box next to Include in Grade, then click Save/Close.
The grade item and the grades are now properly listed in the Gradebook.
Example:
![Example:](https://media.screensteps.com/image_assets/assets/006/005/054/original/9b651304-a66c-4f7f-9ff0-b6fc9ec3d2cf.png)