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.

Exporting the Canvas Gradebook

1. Click in to your course site.
2. Select Grades on the Course Navigation Menu.
   
3. Select Actions in the upper left of the Gradebook page, and then select Export from the drop-down menu that appears.
   

Cleaning Up the Excel Data

4. Locate and open the .csv file on your computer (the best place to find this file is in your computer's Downloads folder). Without using 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.
   
5. Next, select row 2 and right click to delete this row from the excel file. 
   

Generating Student Email Addresses

6. 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.
   
7. 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.
   

Saving Your Email List

8. To save the email list you have just created, select File in the upper left of the excel document.
   
9. 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!