Downloading your students' email addresses from Canvas

Canvas includes several ways to communicate with your students without needing to open a separate email application. If you need to send a message to your whole class, using the Announcements tool in your Canvas course will notify students according to their notification preferences.

For scheduling class meetings in Microsoft Teams or sharing resources with your students outside of Canvas, you may find it helpful to download your students' email addresses instead.

In Canvas, navigate to your Course and click "Grades" in the course navigation.
In the upper-right, click "Export", then "Export Entire Gradebook".
When the export has finished, you should be prompted to download the csv file.
Open the downloaded file and expand the size of the columns as needed. In the first column under the "Student" heading, select the list of your student names. Typically there will be a row containing "Points Possible" between the "Student" heading and your list of students, so you will need to select from Row 3 down to the last row containing a name. The demo course pictured below only has two students, so only Rows 3 and 4 contain student names.
- If you've ever used Student View in your course, you may see a Test Student listed as the last name in your course. This isn't a real student, so you don't need to copy that information.
- The ID and SIS User ID columns contain numbers used by Canvas internally and do not represent the NELB Student ID numbers used for blind grading. Those columns do not need to be copied.
Copy the list you've selected.
While keeping the original spreadsheet open, create a new, blank spreadsheet. Paste the list you copied into the first column of the blank spreadsheet.
- Tip: If you want to add a row of column headings, paste the list into Row 2 of the first column. After pasting, you can add a header (such as Name) into Row 1. If you add the header first, you will have to copy the list from the original spreadsheet again.
In the original spreadsheet, select the list of your students' email addresses under the column header "SIS Login ID". This should be the same numbered rows that you copied in step 4. In the demo course example below, this is Rows 3 and 4 in Column D.
Copy the email addresses you've selected and paste the list into the second column of the spreadsheet where you pasted the list of student names.
Save the new file to your OneDrive with a filename that will help you find it again when you need it.
- If you're not on a NELB machine, you may need to save the file to the computer first, then upload it to OneDrive. See Microsoft's Upload photos and files to OneDrive guide for more information on different ways to save your file.
In the newly saved spreadsheet, highlight the list of email addresses in the second column.
Copy the email addresses and paste them into a meeting invite, sharing settings of a file or other resource your students need.