Canvas FAQ: How can I easily get a list of my students' email addresses in Canvas?
- Maria Shimel
- Maddie Heaton
Original Source: Florida State University
Instructions
Though Canvas's built-in messaging tool and announcements offer you ways to communicate with your students, it may be helpful to have a list of your students' emails handy. Below, we have outlined the quickest way to generate such a list from within your Canvas course.
Click in to your course site.
Select Grades on the Course Layout Menu.
Select Actions in the upper left of the Gradebook page, and then select Export from the drop-down menu that appears.
Locate and open the .csv file on your computer and open it.
Example: Downloads might be saved to the “Downloads” folder on your computer
Delete all columns except for Student, SIS User ID (student ID), SIS Login ID (username)
Add the header “Email Addresses” to Column D.
In row 2 of Column D, type in the formula: =C2&”@u.boisestate.edu”
Select the small square in the lower right corner of D2. Pull the formula down. The email addresses will autogenerate.
To save the email list you have just created, select File in the upper left of the excel document.
Select Save As > This PC and designate a location to store the file on your computer.
You now have a list of your students' email addresses!