Need a spreadsheet of student emails? Have Google Classroom do it!









I was recently playing around with the new Gradebook Feature on Google Classroom and I quickly realized a cool little trick to collect emails in one Google Sheet.  Having everyone’s email in one sheet is a nice feature if you do anything with VLOOKUP or Autocrat

If you have not seen that Google Classroom now has a simple Gradebook program check this quick video to show you how to get there.

So what, why not just use the “email my students” feature that Google Classroom has?  Well you can use this for other sites that do not have the easy single sign on that we all love, perhaps it has “upload with a CSV” file. Like this:


Well now you have a quick and easy way to collect emails – just download the CSV file and upload it to that site.