Transfer Google Sheets grades to PowerSchool
PowerSchool won't take a column pasted from a spreadsheet, so grades you keep in Google Sheets usually get typed in one at a time. Here's how to move a whole column at once, with Missing and Late flags. Using Excel instead? See Excel to PowerSchool.
🔒 10 free pastes · Grades never leave your browser
| Student | Status | Score |
|---|---|---|
| Rivera, Ana | Matched | 18 / 20 |
| Lee, Sam | Late | 15 / 20 |
| Novak, Iris | Matched | 19 / 20 |
| Bello, Tunde | Missing | — |
Can you transfer Google Sheets grades to PowerSchool?
Yes. GradeBridge is a Chrome extension that copies Google Sheets grades from the page you have open and enters them into your PowerSchool gradebook (PowerTeacher Pro), matching each student by name. You check a preview before anything is entered.
Why this takes so long by hand
Lots of teachers keep scores in a spreadsheet first: lab and rubric totals, curved quiz results, participation, or grades exported from another tool. Getting them into PowerSchool still means reading down the sheet and typing each score into the right row.
GradeBridge is a Chrome extension that reads the cells you select, matches each name to your PowerSchool roster, and enters the scores for you. Your spreadsheet isn't changed.
Step by step: Google Sheets to PowerSchool
The first time takes about two minutes. After that, each assignment takes seconds.
Install GradeBridge
Add GradeBridge from the Chrome Web Store, pin it to your toolbar, and sign in with your Google account.
Lay out your sheet
Put one student per row, with the name in one column (or first and last name in two columns side by side) and the score to its right. A header row is fine. To flag a student, type a status like Missing, Late, Exempt, Absent or Incomplete in the score cell or the cell just after it. Keep several assignments side by side? Give each column a title and GradeBridge copies them all at once: see Several assignments from a spreadsheet.
Select the names and scores
Highlight from the first name down to the last score, with the header row if you have one. For a single assignment, select only the names and that score column, so GradeBridge doesn't pick up a different column by mistake.
Copy the grades
Right-click the selection and choose Copy Grades with GradeBridge. Or click the GradeBridge icon or press Ctrl+Shift+G (⌘+Shift+G on Mac); GradeBridge detects Google Sheets automatically. Click Copy grades. If you selected several titled score columns, a list of the assignments appears: untick any you don't want and confirm.
Open the same assignment in PowerSchool
In your PowerSchool gradebook, open the class and go to the matching assignment's score page, or open the scoresheet with all your assignments. Then open GradeBridge and click Paste grades.
Choose a scale and paste
Open GradeBridge again and check the preview. Scores paste exactly as you typed them. If your sheet uses a different total than the PowerSchool assignment, choose Custom points and set Raw score is out of to your sheet's total. For letter grades, choose Letter grades and set the percentage for each letter. Then click Paste. With Simple mode on, GradeBridge pastes straight away and shows a summary with Undo.
Spot-check and save
Look over the scores in PowerSchool and enter any flagged students by hand. With the Instant paste speed (the default) the grades are already saved: click Reload page to see them. With Quick or Careful, click PowerSchool's Save to keep them.
Pasting on the PowerSchool scoresheet
You can paste on a single assignment's score page or on the scoresheet with many assignments. On the scoresheet, GradeBridge picks the column itself: the one it used last time for this assignment in this class, else the column you clicked, else a column with the same name. If it only finds a similar name, it asks you to check. You can change the column in the preview, or choose + Create in PowerSchool if the assignment isn't there yet. Columns on another page of the scoresheet work too; with the Quick or Careful paste speed, GradeBridge turns the pages itself.
After pasting, GradeBridge checks every cell and offers Undo this paste. Read the scoresheet guide.
What carries over
Scores
Numbers paste exactly as typed, or converted to the assignment's point value if you choose.
Status flags
Missing, Late, Exempt (or Excused), Absent, Incomplete and Collected become PowerSchool flags.
Letter grades
A through F, with pluses and minuses, mapped to the percentages you choose before pasting.
Requirements and limits
- Google Chrome on a computer (Chromebook, Windows or Mac). Phones and tablets aren't supported.
- A PowerSchool teacher account with PowerTeacher Pro, the gradebook where you type scores.
- A Google account to sign in to GradeBridge. It doesn't need access to your school's PowerSchool or platform accounts beyond the pages you already have open.
- No district integration or IT setup, unless your school blocks Chrome extensions.
Troubleshooting
“Select the names and scores in Sheets”: select more than one cell, from the first name to the last score, and click Copy again. Still stuck? Press Ctrl+C (⌘+C on Mac) first, then click Copy. Chrome may ask once for permission to read your clipboard.
The wrong numbers were copied: the copy preview says which column GradeBridge used. Select only the name and score columns, or give your columns titles in a header row so each one is copied as its own assignment. ID, email and date columns are ignored.
“Could not find the PowerSchool score keypad”: open the assignment's score page or the scoresheet in PowerSchool, click a score cell in the column you want, then click Paste grades again.
“Click a score cell in the column…”: GradeBridge couldn't tell which scoresheet column to use. Click any score cell in the right column, then click Paste grades again.
Scores are higher than the PowerSchool assignment allows: the Paste button is greyed out and says Scores above N: convert first. Click Convert scores to N points in the paste preview (N is the PowerSchool assignment's points). If GradeBridge read PowerSchool's points wrong, click Paste anyway; PowerSchool still refuses scores it won't accept. More on score scales.
A student wasn't matched: pick their name from Match by hand… in the preview. GradeBridge remembers it for that class next time.
Still stuck? See troubleshooting, or use Report a problem in GradeBridge's Settings (or the contact form) with your extension version. Please don't include student names.
Frequently asked questions
How do I import grades from Google Sheets into PowerSchool?
Select the name and score columns in your sheet, copy them with GradeBridge, then open the assignment's score page or the scoresheet in PowerSchool and paste. GradeBridge matches each name to your roster and enters the scores for you.
Can I paste grades from Excel into PowerSchool?
Yes. Copy the name and score cells in Excel (or Numbers), open the assignment in PowerSchool, switch GradeBridge's paste section to Clipboard and paste. Chrome asks once for permission to read your clipboard. The Excel to PowerSchool guide has the details.
Can I copy several assignments from one sheet?
Yes. Give each assignment column its own title in a header row, select the whole table and copy it. Each titled column becomes its own assignment, and you paste them all on the PowerSchool scoresheet in one go.
Is there a right-click option in Google Sheets?
Yes. Select the names and scores, right-click, and choose Copy Grades with GradeBridge. It copies the selection without opening the popup.
How do I mark students as Missing or Late?
Type Missing, Late, Exempt, Absent or Incomplete in the score cell or the cell right after it. GradeBridge sets the matching flag in PowerSchool.
Does it work with letter grades?
Yes. Choose Letter grades in the preview and set the percentage for each letter, and GradeBridge pastes those percentages.
Is student data safe?
Yes. GradeBridge only reads the cells you select, never changes your spreadsheet, and processes names and grades in your browser without sending them to our servers.
How much does it cost?
Your first 10 pastes are free. Unlimited pastes are $5/month or $39/year.
Related guides
Paste your next Google Sheets assignment in seconds
Free for your first 10 pastes. Works with Excel, Google Classroom and Schoology too.