# How do I export grades in the Gradebook?

You can export scores from the Gradebook and download them to your computer as a CSV file. The Gradebook CSV assignment columns display in the same order as shown in the Gradebook for an individual user.

**Notes:**

<div id="bkmrk-some-columns-that-ap"><div>- Some columns that appear in the CSV file are read-only columns calculated by rules or percentages set in Canvas. Any changes made to these columns will be ignored when you re-upload the file to your course.
- When a grading period filter is applied in the Gradebook, the export displays the filtered grading period results. However, assignment group total columns will display across all grading periods.
- For assignment group columns, changes made to assignment scores will automatically be included in the assignment group calculation in the Gradebook.
- The Total column in the Gradebook displays a running total of all graded assignments in the course, including assignments with hidden grades. The CSV download includes read-only columns for current and final scores. Current score reflects the total while ignoring unsubmitted assignments, and the final score counts unsubmitted assignments as zero. Assignments with hidden scores are unposted grades and shown in separate columns for unposted current score and unposted final score, respectively.
- If a student has submitted an assignment multiple times, the CSV file only accounts for the most recent submission.
- Concluded and inactive enrollments are not included in the CSV file unless their respective option, [Show Concluded Enrollments or Show Inactive Enrollments](https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-view-grades-for-inactive-or-concluded-student/ta-p/753), is enabled in the Gradebook Settings menu.
- Complete/incomplete assignments are shown as full or no credit (e.g. for a 10-point assignment, 10 or 0).
- If you have the Final Grade Override option enabled in your course, the Gradebook export will include the override grade. Changes to the Final Grade Override display in the import confirmation page.
- Gradebook export files automatically save to your user files in an *Unfiled* folder.
- If you have set manual grade posting policies for specific assignments, those assignments will display the posting policy in the CSV file. However, the grade posting policy cannot be modified via the CSV file.

</div></div><div id="bkmrk-embed-this-video"><iframe allowfullscreen="allowfullscreen" data-mce-fragment="1" frameborder="0" height="400px" sandbox="allow-popups allow-popups-to-escape-sandbox allow-scripts allow-forms allow-same-origin allow-presentation" src="https://embed.app.guidde.com/playbooks/iJmRsCoB1tX7YZqGhMTQkk" title="How do I export grades in the Gradebook?" width="700px"></iframe>

<button class="embed-button">Embed this Video</button></div>## Open Grades

<div data-step-uuid="0E058050-AAE2-0135-1606-06467EE270FA" id="bkmrk-"><div data-step-uuid="0E058050-AAE2-0135-1606-06467EE270FA"><div>![Open Grades](https://media.screensteps.com/image_assets/assets/002/823/979/original/d9ce0627-5cfc-425c-bb50-6bdf539db5e1.png)</div><div><div></div></div></div></div>In Course Navigation, click the **Grades** link.

## Export Scores

<div data-step-uuid="0E05BA10-AAE2-0135-1609-06467EE270FA" id="bkmrk--0"><div data-step-uuid="0E05BA10-AAE2-0135-1609-06467EE270FA"><div>![Export Scores](https://media.screensteps.com/image_assets/assets/007/730/064/original/5cb10f07-22f5-40a4-a0a9-9b6c9a7f5157.png)</div><div><div></div></div></div></div>Click the **Export** button \[1\], then click the **Export Current Gradebook View** link \[2\].

If you are using grading periods and want all grading periods included in your CSV file, click the **Export Entire Gradebook** link \[3\].

When the export is completed, Canvas downloads the CSV file automatically to your computer.

## View Exported Scores

<div data-step-uuid="1de089d4-ebc5-4336-ac4c-6aa6b8e64792" id="bkmrk--1"><div data-step-uuid="1de089d4-ebc5-4336-ac4c-6aa6b8e64792"><div>![Export current scores](https://media.screensteps.com/image_assets/assets/007/730/066/original/3d98e6bd-8774-498a-9d64-a7855a101dfa.png)</div><div><div></div></div></div></div>If you navigate away from the page during the export, the CSV file will appear as a previous download in the Export menu so it can be downloaded again. The Gradebook allows you to view a previous export.

If you made changes to the Gradebook after exporting a file and want to export a new file, click the Export link again.

**Notes:**

<div data-step-uuid="1de089d4-ebc5-4336-ac4c-6aa6b8e64792" id="bkmrk-gradebook-export-fil"><div><div>- Gradebook export files include the date and time of the download to differentiate between multiple exports. The export filename format is YYYY-MM-DDTHHMM, followed by the course name.
- Gradebook export files automatically save to your user files in an *Unfiled* folder.

</div></div></div>## Edit Scores

<div data-step-uuid="0E063C90-AAE2-0135-160F-06467EE270FA" id="bkmrk--2"><div data-step-uuid="0E063C90-AAE2-0135-160F-06467EE270FA"><div>![Edit Scores](https://media.screensteps.com/image_assets/assets/000/581/246/original/9c3d4bf2-f23c-4402-a4de-ebfd1a9c4080.png)</div><div><div></div></div></div></div>Edit the scores in Microsoft Excel. Make sure to save the file as a CSV file type.

Once you have made changes, you can [upload it to your course](https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-import-grades-in-the-Gradebook/ta-p/807).

**Notes:**

<div data-step-uuid="0E063C90-AAE2-0135-160F-06467EE270FA" id="bkmrk-if-discussion-checkp"><div data-step-uuid="0E063C90-AAE2-0135-160F-06467EE270FA"><div><div>- 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 data-step-uuid="d8ef8884-ec33-4fa4-ace4-002e94eaefb6"></div></div></div>### View Read-Only Columns

<div data-step-uuid="0E063C90-AAE2-0135-160F-06467EE270FA" id="bkmrk--3"><div data-step-uuid="0E063C90-AAE2-0135-160F-06467EE270FA"><div data-step-uuid="d8ef8884-ec33-4fa4-ace4-002e94eaefb6"><div>[![View Read-Only Columns](https://media.screensteps.com/image_assets/assets/003/000/717/medium/122735d1-2b98-4033-b9ba-3df9dfa50e82.png)](https://media.screensteps.com/image_assets/assets/003/000/717/original/122735d1-2b98-4033-b9ba-3df9dfa50e82.png)</div><div><div></div></div></div></div></div>The CSV download includes read-only columns displaying current and final scores. These columns display for each assignment group in a course and for final course grades.

<div data-step-uuid="0E063C90-AAE2-0135-160F-06467EE270FA" id="bkmrk-current-points-%5B1%5D%3A%C2%A0"><div data-step-uuid="d8ef8884-ec33-4fa4-ace4-002e94eaefb6"><div><div>- **Current Points \[1\]:** Reflects points for graded assignments
- **Final Points \[2\]:** Reflects points for all assignments
- **Current Score \[3\]:** Reflects scores for graded, posted assignments
- **Unposted Current Score \[4\]:** Reflects scores for graded assignments and includes hidden assignments
- **Final Score \[5\]:** Reflects overall score including unsubmitted assignments as zero but excluding hidden assignments
- **Unposted Final Score \[6\]:** Reflects total score, including unsubmitted assignments as zero and hidden assignments
- **Current Grade \[7\]:** Reflects course grade based on graded, posted assignments
- **Unposted Current Grade \[8\]:** Reflectscoursegrade based on graded assignments, including hidden assignments but excluding unsubmitted assignments
- **Final Grade \[9\]:** Reflects overall course grade including unsubmitted assignments as zero but excluding hidden assignments
- **Unposted Final Grade \[10\]:** Reflects overall course grade, including unsubmitted assignments as zero and hidden assignments

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