# How do I import grades in the Gradebook?

You can use a CSV file to upload changes to the Gradebook. You can upload information for existing assignments, or you can also use a CSV file to create new assignments in the Gradebook. New assignments will automatically be published in your course. If you do not know how to save a file in a CSV format, please check the documentation for the program you are using to create your Gradebook changes (e.g., Excel).

If you create a column for a new assignment, Canvas will ask how you want to import the assignment. New assignments upload with the following settings:

<div id="bkmrk-assignment-group%3A-as"><div><div>- Assignment Group: Assignments
- Submission Type: No submission
- Due date for: Everyone

</div></div></div> **Notes:**

<div id="bkmrk-the-gradebook-csv-fi"><div>- The Gradebook CSV file downloads complete/incomplete assignments as full or no credit (e.g. for a 10-point assignment, 10 or 0). Scores with full or partial credit upload as a complete assignment; scores with zero upload as an incomplete assignment.
- CSV file uploads can create assignments and update grades; they cannot update any other area of the Gradebook, such as assignment status, comments, or grade posting policies.
- Letter Grade and GPA Scale assignments do not support any entries that are not part of the assignment's grading scheme.
- All changes made to non-read-only columns are included in the upload. However, read-only columns are automatically ignored in the upload.
- When multiple grading periods is enabled, CSV file uploads cannot create new assignments. Currently new assignments must be created in the Canvas interface. Additionally, CSV files are verified against grading period close dates; grades cannot be changed for any assignment in a closed grading period.
- An upload will not recognize assignments names containing the text Current Score, Current Points, Current Grade, Final Score, Final Points, Final Grade, Override Score, Override Grade, Override Status.
- To upload changes to the Gradebook with student or assignment names containing special characters, please ensure the file is saved as a UTF-8 CSV.
- CSV file uploads ignore reserved column names as well as hidden and deleted custom columns. Reserved column names include Student, ID, SIS User ID, SIS Login ID, Section, Integration ID, and Root Account.
- Grade changes to Classic Quiz submissions may display as fudge points in SpeedGrader.

</div></div>## Create CSV File

<div data-step-uuid="0E458FE0-AAE2-0135-1614-06467EE270FA" id="bkmrk-"><div data-step-uuid="0E458FE0-AAE2-0135-1614-06467EE270FA"><div>[![View Example CSV File](https://media.screensteps.com/image_assets/assets/000/585/144/medium/24784bb0-45ee-4e18-afba-e2cf90bb2db3.png)](https://media.screensteps.com/image_assets/assets/000/585/144/original/24784bb0-45ee-4e18-afba-e2cf90bb2db3.png)</div><div><div></div></div></div></div>For new files, save the file as Grades-Course\_Name.csv.

**Required columns and order**

<div data-step-uuid="0E458FE0-AAE2-0135-1614-06467EE270FA" id="bkmrk-student-name-student"><div data-step-uuid="0E458FE0-AAE2-0135-1614-06467EE270FA"><div><div>- Student Name
- Student ID
- SIS User ID (only required if you use SIS)
- SIS Login ID (only required if you use SIS)
- Section
- Assignment (this can be for an existing assignment or a new assignment; retain IDs for existing assignments)

</div></div></div></div>**Notes:**

<div data-step-uuid="0E458FE0-AAE2-0135-1614-06467EE270FA" id="bkmrk-if-you-don%27t-want-to"><div><div>- If you don't want to create a new CSV file, you can always [download the CSV](https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-export-grades-in-the-Gradebook/ta-p/809) from Canvas, change it, and re-upload the same file and the changes you made will appear in Canvas once you re-upload the CSV file.
- If Discussion Checkpoints are enabled in your course, the CSV will show additional columns. 
    - Graded Discussion with Checkpoints (if applicable)
    - Graded Discussion with Checkpoints Reply to Topic (if applicable)
    - Graded Discussion with Checkpoints Replies Required (if applicable)

</div></div></div>## Open Gradebook

<div data-step-uuid="0E45D8F0-AAE2-0135-1617-06467EE270FA" id="bkmrk--0"><div data-step-uuid="0E45D8F0-AAE2-0135-1617-06467EE270FA"><div>![Open Gradebook](https://media.screensteps.com/image_assets/assets/002/767/072/original/21747163-4e75-46e8-a0b1-de38255a8acc.png)</div><div><div></div></div></div></div>In Course Navigation, click the **Grades** link.

## Upload Scores

<div data-step-uuid="0E462350-AAE2-0135-161A-06467EE270FA" id="bkmrk--1"><div data-step-uuid="0E462350-AAE2-0135-161A-06467EE270FA"><div>[![Upload Scores](https://media.screensteps.com/image_assets/assets/009/048/949/medium/6d9a01a6-814a-469f-afbc-e48f4b9a7948.png)](https://media.screensteps.com/image_assets/assets/009/048/949/original/6d9a01a6-814a-469f-afbc-e48f4b9a7948.png)</div><div><div></div></div></div></div>Click the **Import** button.

## Choose File

<div data-step-uuid="0E466460-AAE2-0135-161D-06467EE270FA" id="bkmrk--2"><div data-step-uuid="0E466460-AAE2-0135-161D-06467EE270FA"><div>![Choose File](https://media.screensteps.com/image_assets/assets/009/048/951/original/399f4735-2b35-4b19-88df-eeaaa40dcc7d.png)</div><div><div></div></div></div></div>Click the **Choose File** or Browse button (depending on your browser).

## Open File

<div data-step-uuid="0E469B60-AAE2-0135-1620-06467EE270FA" id="bkmrk--3"><div data-step-uuid="0E469B60-AAE2-0135-1620-06467EE270FA"><div>![Open File](https://media.screensteps.com/image_assets/assets/009/048/953/original/f6f4687a-9090-402f-92f5-d8ce292b60eb.png)</div><div><div></div></div></div></div>Locate the CSV file \[1\] then click the **Open** button \[2\].

## Upload Data

<div data-step-uuid="0E46D6B0-AAE2-0135-1623-06467EE270FA" id="bkmrk--4"><div data-step-uuid="0E46D6B0-AAE2-0135-1623-06467EE270FA"><div>![Upload Data](https://media.screensteps.com/image_assets/assets/000/770/063/original/2736d64b-b2ca-44d3-9e3e-a81ec906ce51.png)</div><div><div></div></div></div></div>Click the **Upload Data** button.

### Upload New Data

<div data-step-uuid="0E46D6B0-AAE2-0135-1623-06467EE270FA" id="bkmrk--5"><div data-step-uuid="0E46D6B0-AAE2-0135-1623-06467EE270FA"><div data-step-uuid="0E471360-AAE2-0135-1626-06467EE270FA"><div>[![Upload New Data](https://media.screensteps.com/image_assets/assets/009/048/955/medium/9f1c978c-f57c-46d7-b97d-03733b57846c.png)](https://media.screensteps.com/image_assets/assets/009/048/955/original/9f1c978c-f57c-46d7-b97d-03733b57846c.png)</div><div><div></div></div></div></div></div>If you add a new column to the CSV file and then upload the file, Canvas will ask you what you want to do with the new column. In the drop-down menu, choose the **A new assignment** option \[1\]. Then assign the number of points possible \[2\]. Click the **Continue** button \[3\].

**Notes:**

<div data-step-uuid="0E46D6B0-AAE2-0135-1623-06467EE270FA" id="bkmrk-when-multiple-gradin"><div data-step-uuid="0E471360-AAE2-0135-1626-06467EE270FA"><div><div>- When multiple grading periods is enabled, CSV file uploads cannot create new assignments.
- New assignments created via a CSV file upload are automatically published and maintain the course posting policy.

</div></div></div></div>## Save Changes

<div data-step-uuid="0E474DF0-AAE2-0135-1629-06467EE270FA" id="bkmrk--6"><div data-step-uuid="0E474DF0-AAE2-0135-1629-06467EE270FA"><div>[![Save Changes](https://media.screensteps.com/image_assets/assets/004/254/525/medium/bf9cfd94-9552-4995-b13e-bde0a492ba1e.png)](https://media.screensteps.com/image_assets/assets/004/254/525/original/bf9cfd94-9552-4995-b13e-bde0a492ba1e.png)</div><div><div></div></div></div></div>Review the changes made to your Gradebook \[1\]. Any changes that will result in a lower grade than the previous version are highlighted in red \[2\].

If you upload assignments with no grade changes, they will be hidden from the upload \[3\].

Click the **Save Changes** button \[4\].

## View Updated Gradebook

<div data-step-uuid="0E478BC0-AAE2-0135-162C-06467EE270FA" id="bkmrk--7"><div data-step-uuid="0E478BC0-AAE2-0135-162C-06467EE270FA"><div>![View Updated Gradebook](https://media.screensteps.com/image_assets/assets/009/048/957/original/fce09767-e2cf-4dd8-9cbe-b9ca40877717.png)</div><div><div></div></div></div></div>View the updated data in the Gradebook.

\[Content retrieved from [https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-import-grades-in-the-Gradebook/ta-p/807](https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-import-grades-in-the-Gradebook/ta-p/807)\]