[ARCHIVED] Can I export list of assignments?

[Tod]

As a parent, I'd like to get an export of all assignments in CSV or Excel format. Is there an easy to do this today?

[KristinL]

Hi @Tod -

Like your other question, there's not a "one-button" solution.

While I can't provide a super-fast solution, I think the alternative should work quickly. With a new spreadsheet open, view each Grades page and highlight the content. Then, copy/paste it into your new spreadsheet. Each item goes into a cell! The columns will have to be adjusted and some things need to be modified, but ultimately, you can make it happen. 🙂

Remember that the export is one-directional, so any changes in Canvas would have to be added to your new master spreadsheet.

[LMScomparison]

Hi @KristinL I'm guessing that you work for Canvas. I don't see why you would otherwise try to seem excited that tabular data can get pasted into a spreadsheet without having to specifying how the the values are separated. However, this step is actually the least of the problems here.

The problem is Canvas' continued refusal to provide essential functions such as sorting and filtering options. After much feedback from your observer class users (the N number of parents who have to teach their kids and work from home at the same time) STILL can't filter classes or assignments by child - and yes, in the desktop version so we can actually download CSVs, and in a way that recognizes completed  assignments. Nor have you fixed the inability for parents to get all assignments as a downloadable file and sort this data by status in real time, according to whether it's complete, late or missing.

Can you please post the code snippet that your developers are struggling with because if your programmers can't fix it, I'm sure there's a few parents here who would like to give it a try. 

The fact that our school districts have contracted with a company who couldn't give a hoot about the extra stresses their product puts on families during an unusually stressful pandemic is not going to age well.  You might not feel the effects yet, but the experiences millions of your users are complaining about right now are certain to damage your long term reputation as a brand. I know the school districts are slow to make decisions, but complacency and programming incompetence is starting to look very risky for your business.

[KristinL]

Hi -

I'm just a teacher who has enjoyed using Canvas for over 7 years and spends a lot of time in the Community, trying to connect Canvas users with resources to help them get the most out of their experiences! I'll share your post with someone who can better respond to your comments. These filtering options may be in development, but they are not listed on the official Road Map at this time.

I have some things you could do now too --

You could submit a support ticket. Your local Canvas Administrator could escalate it directly to Canvas Support. How do I get help with Canvas as an observer? How do I get help with Canvas as a student? 

You could also look for an Idea conversation that is open for discussion and rating! The more in the dialogue, the better the engineers know how to move forward.

Lastly, you could also collaborate with your local Canvas Administrator and talk with the CSM (Customer Success Manager) assigned to your account at Instructure. They'll be able to advocate for your needs, too!

[LMScomparison]

Thanks for clarifying @klundstrom, but please believe me when I say that this software is a nightmare and your students are paying dearly for it. I can understand that this might not be as apparent if you're not well immersed in what good software should accomplish in 2021. A lot of teachers are not very technical, and therein lies the biggest problem. Our school districts are being sold snake oil and as parents we can do nothing! We're not even considered end users. Neither are our children. I too have used Canvas as an instructor, and it's not nearly as bad (although still bad). Of course I've tried the links you point to, but the point is that Canvas couldn't care less. Just read all the comments in those links! We rely on you teachers to speak to Canvas as well as the school districts for us because, again, we're not considered "end users". 

[MusTeacher]

I tried it this way:
Click the syllabus tab > highlight the Course Summary that has dates, events/assignments, and duedates and copy it. Paste into your spreadsheet.

[imjustanender]

The way I did it was I downloaded my canvas calendar as an ics file, then used a ics to csv file converter, opened a new spreadsheet and used the 'data' tab within excel to import the csv file to my spreadsheet. This is probably the most complicated way of doing it, but it worked!