Add Assignments to a Course via CSV Upload

garciah
Community Champion
7 4 1,915

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!

4 Comments