Copying Class Roster Sheets to Microsoft Excel

Want Your Roster Sheet in Excel?

There are two ways to get your roll sheet into Microsoft Excel. See the steps below for options.

From myGate:

  1. Log in to myGate and click on the Teaching/Advising tab.
  2. Click on the classlist icon next to the desired course.    The roster for the course should be visible.
  3. Using your mouse, click to the left of the first student name in front of the number 1. Drag your mouse while holding down the left mouse button all the way to the bottom-right of the last student name.
  4. Release the mouse button and you should see the selected student information. 
  5. Right-click on the select area and select Copy.
  6. Open Microsoft Excel.
  7. Click in the desired cell (most likely A1 in the top-left corner of the spreadsheet)
  8. From the Home tab, click on the Paste icon.  (Firefox users should choose the Paste drop-down and select Paste Special, then Unicode Text.)
  9. Click OK.
  10. To remove email icon images from your sheet later, click on the Page Layout tab and select Selection Pane.
  11. A new window will appear. Select Hide All at the bottom of the pane.

For a video version of these instructions, click here.

** The above instructions target Microsoft Excel 2007. If you have an older version or need additional help please contact the Service Desk at 270-809-2346.

From Canvas:

All courses are automatically created for all instructors.  Students are populated into the courses every hour.  To download a list of students from your course, follow these instructions.  Downloading the gradebook will give you an excel compatible listing of your students.  http://guides.instructure.com/s/2204/m/4152/l/55012-how-do-i-download-scores-from-the-gradebook