Improve the CSV export for easier EXCEL import - Solution: add sep=; on the first line.

I am exporting my gradebook as CSV and then read it in into excel. As the CSV is actually using ";" as a delimiter and not "," excel creates one column with the last name and then one column with all other data. This is very annoying as I have to then separate the second column into all other columns. More so, the header row does not have a comma, thus this row needs to be column divided separately. All in all, many manual steps that can be easily avoided.

The solution is very simple, if the CSV file has the following as first line:

sep=;

Excel will then interpret the ";" as delimiter and the import will be simple with no manual steps.

Can you please do this in the next update?

Thanks

Find more posts tagged with

Admin

Developers

Accepted answers

All comments

Chris_Hofer

Hi there, @guswib …

It sounds like you're suggesting enhancements and/or improvements to the way Canvas currently operates re: the Gradebook. At this time, the entire Ideas process is on hold and being re-designed. You may have also noticed in the past week or two that the entire Community website migrated to a new platform. Once the Community team reveals their new process for us to submit Ideas such as yours, then you could do so. Unfortunately, I'm not exactly sure when that will happen. The last paragraph under Your Voice, Your Community tells a bit more about this: Your Community, Refreshed - Instructure Community.

I have also heard that, for the time being, if you know who your school's assigned Customer Success Manager is, you could let that person know of your request for enhancements to the Canvas Gradebook. If you are not a Canvas admin for your school, please talk with that person or team, and then he/she/they can pass along the information to their CSM.

I hope this will be of some help to you. Good luck!

guswib

Hi @Chris_Hofer

Thank you for your reply. I am an instructor so I will reach out to our Customer Success Manager, if I can figure out who it is.

I am just surprised that that noone else has requested this small feature given the common use of Excel.

Best

Gustav

Unanswered Questions

Dropped Scores
I have Canvas set to drop the lowest quiz score, however, my students can only barely tell that the grade text is slightly grey when dropped. Can it have a tag like the "missing" and "exempt" ones in the student gradebook?
Batch edit assignment due dates by section
My Canvas shell has three different sections that all meet at different times throughout the week. I need to be able to batch edit assignment due dates by section, but right now Canvas can't filter by section for batch edit. My only option is now to manually (tediously) edit due dates for each assignment individually.
Change Group Assignments to NOT save if no groups are selected
Morning! One of the more frustrating aspects of Canvas are groups and the issues that show up when copying courses that have them. But now we have yet another issue. Most recently we have had instances where people mark an assignment/discussion as a group assignment but then do not link the discussion or assignment to any…
Has anyone experienced the "Empty Course" page for Speedgrader, when there actually are students assigned and active on the assignment?
So, we have encountered a few assignments where the Speedgrader presents the teacher with the "Empty Course" page, even though the course is not empty. I have discovered two New Quizzes in the same course where this has occurred, despite multiple students being assigned (at Module level, which passes the permission down to…
Problems with grading since update
A teacher has expressed concerns with the recent update. Exact concern is as follows: "My Canvas has been acting glitchy since the last "update." For instance, when I grade essays the highlight and cursor tools do not always work. I have to try highlighting several times,or come back later to finish. It's told me I "ran…