Does anyone know how to download a class roster with e-mail addresses from CANVAS to an Excel file?
Gregory Pierce, if the email addresses are showing up in people (not all colleges are set up this way), then the easiest way I've found is to copy and paste from People to Excel. If email addresses don't show up for you in People then there is no way to get them to show up there.
Side note, but depending on the SIS (student information system) you use you should be able to get this information from there.
Hope this helps!
You can copy and paste just names and e-mails from Canvas, but photos and
hyperlinks come with it. And no majors.
You have to remove all the photos and hyperlinks, and re-center the names to
the middle of the cells.
Can't I just have a simple downloadable Excel file of the students' names,
e-mail addresses, and majors.
Our new student info system LionPath is a mild disaster.
Can only download the students' e-mail addresses from it, separated by commas,
in a long line, with no names or majors attached.
Would have to parse this in Excel, then type in each one of my students' 160
names and majors.
Our old SIS called eLion used to provide this automatically.
Still not satisfied.
On Wed, Aug 17, 2016 07:22 AM,
One way to get student emails is to use the Grade Book. As noted, if the emails appear as Login IDs then you can get the emails using theses steps.
1. Go to Grade Book and click on <Export>
2. Select Current and open with MS Excel.
3. Delete all the columns except "Student" and SIS Login ID
4. Rename SIS Login ID to "Email"
5. Delete row 2 "Points Possible"
6. Save the file
I did happen upon this by accident yesterday....when I exported it into Excel,
it brought all thestudents, not just the enrolled ones. It exported 27
students, when I only have 15 still registered.
Will have to delete the non-enrollees by hand. Did you experience the same
On Thu, Aug 18, 2016 03:09 PM,
I haven't had to delete non-enrollees. Unless you are referring to folks that never accept the invitation to the class.
Retrieving data ...