Heather Garcia

Add Assignments to a Course via CSV Upload

Blog Post created by Heather Garcia on Apr 12, 2016

I had an instructor ask me recently whether it was possible to create an assignment in the Grade Book via an Excel upload. I couldn't find an answer by searching the community, so I tested it out myself. I figured that I should share the results of my testing and the steps for anyone who might be interested.

 

Note:

This is probably best for an on-ground or hybrid course since the assignment is created in Canvas as a "no submission" assignment by default.

 

Steps:

  1. Export current gradebook
  2. Add a column to your file
  3. Add a title for the assignment and points possible in the appropriate fields
  4. Input student grades for assignment (if you don't have grades available yet, type a space into the field; you'll get an error message if you don't put anything in the field)
  5. Save your file as a .CSV
  6. Import file into grade book (note: you will be prompted to confirm that you are creating a new assignment)

 

Good luck!

Outcomes