Canvas FAQ: How can I easily get a list of my students' email addresses in Canvas?

Original Source: Florida State University


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&””

  • 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!

Relevant Information