Aug 28, 2023
40063
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 Navigation 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 (the best place to find this file is in your computer's Downloads folder). Excluding the Student and SIS User Login columns, hold Ctrl on your keyboard and select the column letter for every remaining column in the excel file. Right click to delete these columns from the excel file.
(Click image below to enlarge it)
- Next, select row 2 and right click to delete this row from the excel file.
(Click image below to enlarge it)
- To increase readability, we recommend expanding columns A, B, and C, in addition to labeling column C as "Email Addresses". In cell C2, type =B2&"@fsu.edu" and press Enter. This should automatically update the cell with the student's email address.
(Click image below to enlarge it)
- Once you have done this for one student, place your cursor in the bottom right of the cell. Click and drag down to generate emails for the remaining students.
(Click image below to enlarge it)
- To save the email list you have just created, select File in the upper left of the excel document.
(Click image below to enlarge it)
- 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!