Copying Grades from myGate to Microsoft Excel

This is a tricky process and can be affected by various browser settings.  If you have problems, contact the Service Desk at 270-809-2346.  Make sure you indicate you are trying to copy grades from myGate to Excel.

Instructions to Copy to Excel:

*If you haven't submitted grades yet, see this article, Submitting Grades in myGate.

  1. Log in myGate
  2. Select the Teaching/Advising tab
  3. Click on the classlist icon next to the desired course.    The roster for the course should be visible with midterm and/or final grades.
  4. Click to the left of the 1 in front of the first student name and highlight each row by holding down the left mouse button and dragging toward the bottom-right of the screen.
  5. Release the mouse button and you should see the selected student information. 
  6. Right-click on the select area and select Copy.
  7. Open Microsoft Excel.  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.

*To remove email icon images from your sheet later, click on the Page Layout tab and select Selection Pane.A new window will appear. Select Hide All at the bottom of the pane.

**Some browsers format the grade sheet differently.  Best results were found using Internet Explorer and Chrome.

Print Article