cancel
Showing results for 
Search instead for 
Did you mean: 
jriley
Community Participant

Problem importing grades

I'm trying to import grades from an Excel spreadsheet to Canvas via a CSV file, but it's not working out well.

I managed to do this successfully - once - by entering some scores manually into Canvas, downloading them as a CSV file, editing that file with a new set of scores, and uploading it. However, I had to copy the scores from my Excel spreadsheet to the CSV file in bits and pieces, rather than all at once, because the spreadsheet and the CSV that I downloaded from Canvas didn't have the exact same students in the exact same order. There were two reasons for the differences: (1) I've made some drops lately that aren't reflected in Canvas yet, and (2) Canvas and Excel don't alphabetize names quite the same way when there are people with two surnames

Copying the scores in bits and pieces to compensate for the names being in a different order - and checking to make sure I hadn't messed up - took quite a while. So for my second import attempt, I tried creating the CSV with the same students in the same order as in my Excel spreadsheet, so that I could copy and paste their scores in a single step. Naturally, that didn't work: Canvas says "Invalid CSV files. Grades could not be updated."

So before I invest more time experimenting with this, can anyone tell me if there's any leeway at all regarding the list of student names in the CSV file? (By the way, this wasn't an issue at all in Etudes, but maybe I just got spoiled.)

Thanks in advance for your help!

37 Replies
kona
Community Coach
Community Coach

 @jriley ‌, honestly in all my playing around with the import/export functionality for the Canvas gradebook I've found it way easier to to export the gradebook, add grades, and then import. It always seemed to take longer and be a bigger pain to try importing a file that didn't originate from the canvas export. 

As to your original issue... couldn't you add blank rows for the missing students in the spreadsheet you're attempting to copy from? That way when you copy you wouldn't have to do it in chunks because it would align with the Canvas export. 

Robbie_Grant
Community Coach
Community Coach

 @jriley ,

Were you able to find an answer to your question? I am going to go ahead and mark this question as answered because there hasn't been any more activity in a while so I assume that you have the information that you need. If you still have a question about this or if you have information that you would like to share with the community, by all means, please do come back and leave a comment.  Also, if this question has been answered by one of the previous replies, please feel free to mark that answer as correct.

 

Robbie

jriley
Community Participant

Thanks for asking, Robbie. No, it never got resolved. (I do appreciate

Kona's response, but I was hoping for more than a workaround.) I finally

came up with a manual method of creating a CSV file that Canvas would

accept from my Excel spreadsheet, but it was really tedious. Over the

summer I'll write a program that does the same thing and will just use that

in the future.

I never did figure out exactly what the Canvas grade import is sensitive

to, because it wasn't worth my time to do a long series of experiments, but

apparently it's critical for the CSV file to either have the students'

names in the same order as in Canvas, spell them exactly the same way as in

Canvas, or possibly both.

Etudes just keys off the student IDs, which stay the same even if Excel has

sorted the names differently from Canvas (which happens all the time when

students have multiple surnames), or if the instructor has edited names to

spell them the same way the students do, etc. Maybe I just haven't grokked

the profundity of Canvas yet, but I don't see why it can't also key off a

numeric field, such as SIS User ID, that isn't going to change during

normal editing.

Jim

On Tue, May 30, 2017 at 12:19 PM, Robbie Grant Admin <instructure@jiveon.com

emily
Community Champion

Your first five columns need to be Student (Last, First), ID (Canvas ID number), SIS User ID (University student ID), SIS Login ID (ours is their email address minus the "@university.edu"), and Section (Canvas SECTION number for that course), in that order.

https://community.canvaslms.com/docs/DOC-10103-415255013 

jsmee
Community Member

Actually, I am finding that hyphens are not treated the same in Canvas and Excel when it comes to alphabetization. I happen to have two students whose last names start the same, but one of them has a hyphenated second last name. So, for example, in Canvas Jones-Smith comes before Jones; however in Excel, Jones comes before Jones-Smith. So when I copy from a column in Excel into Canvas those two grades are switched because of the difference in alphabetizing. Anybody have any thoughts?

bahmanyaghoobi
Community Member

I am fairly new to Canvas, and I am having similar issue. I download the gradebook as a CSV file, open it, and add the grades under one of the assignments. Then I save and close the file (and I am sure that the file is still a CSV file). Then I upload the file back to Canvas. It shows the assignment names, but no student name and grade is shown bellow them. If I hit the "Save Changes" button. Nothing changes, and the grades are not updated. 

 @bahmanyaghoobi , welcome to the Canvas Community! My recommendation is to double-check that you are following the correct steps for uploading grades to the gradebook per this guide - How do I upload changes to the Gradebook?. If you are and still experiencing this problem then I would submit a Canvas Support help ticket. To do this go to your course in Canvas and click on the Help link (left side of the page) and "Report a Problem."

Hope this helps!

Thanks Kona. I was following the same instructions. So far, I've had no success. I will try a bit more, and if I couldn't get it to work, I will report as a problem. Thank you for the response.

jriley
Community Participant

Thanks for the email, Kona. I think you may have meant to send it to Bahman

instead of me, though. For what it's worth, to me the grade import seems

much more forgiving than before regarding how the names appear in the CSV

file.

Regards,

Jim

On Fri, Jan 5, 2018 at 11:05 AM, kona@richland.edu <instructure@jiveon.com>