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!