You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Home > Canvas User Experience > How can I easily get a list of my students' email addresses in Canvas?

Recent News View all

  • 11/22/2024: Canvas Outage 500 Page Error [RESOLVED] Resolved [Posted 11/22/2024 at 1:29 pm ET] At 12:43 pm on 11/22/2024 Instructure reports the incident has been resolved.  For the full timeline of the error, please see the Canvas System Status Page. Monitoring At 12:34 pm on 11/22/2024 A fix has been implemented and Instructure is monitoring the results.  For the full timeline of the error, please see the Canvas System Status Page. Investigating [Posted 11/22/2024 at 12:24 pm ET] At 12:15 pm on 11/22/2024 Canvas has experienced an outage of service.  Some users may be encountering  500 page errors in Canvas.  Instructure is currently investigating the issue.  For the full timeline of the error, please see the Canvas System Status Page.

  • 11/20/2024: Hypothes.is Scheduled Maintenance and Outage Saturday Pending [Posted 11/20/2024 at 2:04 pm ET] Saturday, November 30th from 3:00 to 5:00 am ET Hypothes.is  At 3:00 to 5:00 am ET on Saturday, 11/30/2024, Hypthes.is will be undergoing a scheduled maintenance.  During this time, the platform will be unavailable.

  • 11/19/2024: Some Canvas Users Experiencing a 500 Error [RESOLVED] Resolved [Posted 11/18/2024 at 9:55 pm ET] At 9:55 pm on 11/18/2024 Canvas reported the situation has been fully resolved. For the full timeline of the error, please see the Canvas System Status Page.   Monitoring [Posted 11/18/2024 at 9:36 pm ET] At 9:36 pm on 11/18/2024 Canvas implemented a fix to the 500 error some United States users were experiencing in Canvas.  To ensure the fix was successful they remained monitoring the situation.  For the full timeline of the error, please see the Canvas System Status Page.   Investigating [Posted 11/18/2024 at 9:06 pm ET] At 9:06 pm on 11/18/2024 Canvas was aware and started investigating a reported error of some United States users experiencing a 500 error while in Canvas.  This error seems to have impacted some students by kicking them out of their exams.  For the full timeline of the error, please see the Canvas System Status Page.

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

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.

 

  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.
  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.
    (Click image below to enlarge it)
  5. Next, select row 2 and right click to delete this row from the excel file. 
    (Click image below to enlarge it)
  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.
    (Click image below to enlarge it)
  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.
    (Click image below to enlarge it)
  8. 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)
  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!

Feedback
40 out of 80 found this helpful

scroll to top icon