Import CSV Document into the Gradebook - Canvas

( Canvas's directions on importing grades )

CSV Required Format

On Feb 15 Canvas is updating its grade book CSV importing procedures. So these directions should be used only after the 15th of Feb.

There are two formatting options that work. The one that has consistently worked for me is Option 1.The CSV document you need to upload into Canvas must have one of the formats below. 

Option 1 (Use Student Names)

  • The following listed column headers are required.

    • Student (Required: Use First then Last Name with no separators)

    • ID (Values can be blank)

    • SIS User ID (Values can be blank)

    • SIS Login ID (Values can be blank)

    • Root Account (Values can be blank)

    • Section (Values can be blank)

    • Assignment Name (Values are Required)

  • Required Row - Points Possible

Example Below ( Download this CSV by Name Example )

 

Student

 ID

 SIS User ID

SIS Login ID

 Root Account

 Section

 YOUR ASSIGNMENT TITLE HERE

 Points Possible

 

 

 

 

 

 10

 Joe Smith

 

 

 

 

 

 2

 Sam Jones

 

 

 

 

 

 3

Note on student names. If you get a CSV file from the testing center the students first and last name must be in the same cell. First name must appear first.

Option 2 (Use SIS Login ID)

  • The following listed column headers are required.

    • Student (Values can be blank)

    • ID (Values can be blank)

    • SIS User ID (Values can be blank)

    • SIS Login ID (Required must have OSH in front of the ID)

    • Root Account (Values can be blank)

    • Section (Values can be blank)

    • Assignment Name (Values are Required)

  • Required Row - Points Possible

Example Below ( Download this CSV file by SIS Login ID Example )

 

Student

 ID

 SIS User ID

SIS Login ID

 Root Account

 Section

 YOUR ASSIGNMENT TITLE HERE

 Points Possible

 

 

 

 

 

 10

 

 

 

 OSH0XXXX01

 

 

 2

 

 

 

 OSH0XXXX02

 

 

 3

(ALTERNATIVE to the template links above) 

You could download the grade book from your course first. This will give you the student names and Ids in one file;

  • Open your class in Canvas

  • Choose "Grades"

  • Select "Actions > Export"

  • Save to your desktop

Edit the CSV from the blank template

  • Add the name of your assignment in the header of the last column (should be unique to all your other assignments in Canvas )

  • If you have an existing spreadsheet (perhaps from the testing center) copy the required fields into the into the required columns (being careful to leave the "points possible" row blank)

  • Add in the total possible points for the assignment in the points row under the assignment header

  • Copy and paste the points the student received into rows below the possible points cell

  • Being careful to make sure your student IDs or Names line up with their scores copy and paste the SIS User ID column. 

  • PLEASE double check to make sure the correct IDs line up with the correct scores

  • If necessary you may need to prepend " OSH0 " in front of each student ID if it's not already there (10 digits in total). 

Upload the CSV

  • Go to "Grades"

  • Choose "Actions > Import"

  • Find the CSV on your computer

  • Choose the "Upload Data" button

  • You will be asked to choose the assignment. If its a new assignment that does not already appear in your grade book choose "New Assignment" if its an existing assignment in Canvas choose that assignment from the dropdown.

  • Choose "Continue"

Canvas will give you a preview including student names and the grade it will be assigning to them (please double check). If everything looks correct select the "Save Changes button. Please double check that the point and names all line up correctly!

You may need to give Canvas a few minutes to ingest the upload into the gradebook . After waiting click the refresh or reload button on your browser.