Export grades for your gradebook
Download a CSV or open assignment grades in Google Sheets.
Quick answer
Open the assignment's Responses tab and select Export grades. Choose Download CSV for a file or Open in Google Sheets for a new sheet. Review names and scores before copying them into your gradebook.
What to do
Open Responses
Open an assignment with at least one submission and select Responses.
Open Responses, then find Export grades above the table. Select Export grades
The menu is available above the response table.
Use Export grades after the response table has the rows and final scores you expect. Choose the format
Select Download CSV for a local file. Select Open in Google Sheets to create a sheet; sign in to Google if Fiveable asks for authorization.
Review the export
Check student names, completion, and final scores. Resolve duplicates or account-name differences before importing the data into another gradebook.
If something is not working
Export grades is disabled.
The assignment needs at least one grade row. Refresh Responses and complete any required reviews first.
Google Sheets asks me to sign in.
Choose the Google account where you want the sheet saved and approve the requested connection. You can use Download CSV instead.
Did this guide answer your question?