How do I format my file for importing grades into Gradebook?
Instructors can manage grades offline in a spreadsheet and then import the file to update the course Gradebook. You can also import a file as a method for quickly creating several gradebook items at once.
The easiest way to obtain a file in the proper import format is to export your Gradebook and use that file as a template. This way it will contain all of the student information in your site, as well as any existing gradebook item information in your site. See How do I export grades from Gradebook? for information on exporting.
Note: You can only update graded items that have been created within the Gradebook. Graded items that come from other tools, such as Assignments or Tests & Quizzes, cannot be updated via file import.
Video Guide
Step-by-Step Instructions
Go to Gradebook.
Select the Gradebook tool from the Tool Menu of your site.
Click Import/Export.
Click Export Gradebook.
The export will download as a .csv file.
Open the file in your preferred spreadsheet application.
The spreadsheet will contain the student information (first two columns) and a column for each item already added to Gradebook.
Add columns, grades, and/or feedback to the file.
To add new items, and associated grades/feedback, follow the formatting conventions below:
- Student ID and Student Name are the first two columns and must be retained for any future imports.
- New gradebook items are added by inserting columns into your file. The total points for the item should be entered between square brackets [100], after the title. In Column G in the example pictured above, we are adding the item Week 2 Quiz, worth 100 points.
- Comments for an item can be included by adding a column whose title is prefixed with an asterisk (*). Column H, titled * Week 2 Quiz, would contain the comments.
Save any changes made to the spreadsheet, keeping the spreadsheet as a CSV file.
Return to Import/Export tab to import file.
For more information on importing your items into Gradebook, see How do I import grades into Gradebook?
![](https://media.screensteps.com/image_assets/assets/003/359/611/original/5620cc06-c14c-4cbf-b817-7bd3fb7ab313.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAVNY36S4EK3YMWFAE%2F20240727%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20240727T005426Z&X-Amz-Expires=300&X-Amz-SignedHeaders=host&X-Amz-Signature=030487784316ac74ebfa5a98d64c21f69228526325d2ab25c3a6d128ab018369)
![](https://media.screensteps.com/image_assets/assets/003/359/613/original/31434a7e-e44e-42ad-818b-3bef42208872.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAVNY36S4EK3YMWFAE%2F20240727%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20240727T005426Z&X-Amz-Expires=300&X-Amz-SignedHeaders=host&X-Amz-Signature=e45c16daf964a816e2d41a208d77c8b173c649a967d6eaa927a065055b538e06)
![](https://media.screensteps.com/image_assets/assets/003/359/615/original/02abad9b-c1dd-48bd-bf88-c28ec6e645a1.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAVNY36S4EK3YMWFAE%2F20240727%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20240727T005426Z&X-Amz-Expires=300&X-Amz-SignedHeaders=host&X-Amz-Signature=a595a7c8858df519ae2935d302d5a6db2005e2d72cde5be369e5d9b670db40ff)