How to upload a rubric from Google Sheets/Excel to Canvas

I have found that Canvas’ rubric creator is clunky and time-consuming. However, having your rubrics in Canvas makes grading much easier.

Thanks to other educators, there is a way to create a rubric in Google Sheets (or another spreadsheet program) and quickly import it into Canvas.

Old-school Canvas users might remember that importing rubrics was an option built into Canvas. I am unsure why it was removed, but thankfully there is a workaround.

I “pirated” my knowledge from this Instructure Community Page, but I found its instructions hard to follow. Below you will find a simple order of steps to follow to simplify your process.

One more note: I recommend checking out my other post on how to create a rubric in ChatGPT. I use AI to save time and amplify my rubrics. Using ChatGPT along with these steps should save you a lot of time.

Adding a Rubric from a Spreadsheet to Canvas - Step-by-Step Guide

Made by Daniel Fussell with Scribe

1. Using Google Chrome as your browser, navigate to http://bit.ly/rubric2canvas

2. Click on the link for "Install Tampermonkey"

3. Click "Get from Store"

4. Click "Add to Chrome"

5. Click the Add extension button

6. Click the Close button

7. Navigate back to http://bit.ly/rubric2canvas

8. Click the "Install the Rubric Importer" link

9. Click "Install"

10. Click the Chrome pop up button

11. Click the Settings ⌘, menu item

12. Click "Extensions"

13. Turn on "Developer mode"

14. Open a rubric you have created in Google Sheets or any other spreadsheet program. Notice the formatting of the rubric.

15. Copy all cells of the rubric *Make note of the formatting of this rubric OR use bit.ly/rubric2canvas to help you format your rubric correctly.

16. Open "Rubrics" in Canvas

17. Click "Import Rubric" *Note that this button will only exist if you did the previous steps correctly.

18. Add a title for your rubric

19. Paste your rubric into the "Rubric Contents" box and click "Create"

20. Find your newly created rubric

21. Edit the rubric to adjust your point values or make any changes that you need.

22.