How to export an Excel roster with One Line per Student from MyMadison

Overview

For instructors who need to export their rosters from MyMadison.

Environment

Applies to MyMadison and then Microsoft Excel.

Troubleshooting/Resolution

To export an Excel roster with one student per line, use Personalization to remove the two-line Program and Plan column from the grid:

  1. Open a web browser to mymadison.jmu.edu
  2. Click on the Faculty tab then under Faculty Center click Open Roster
  3. Click Personalize
  4. Click Program and Files, then click the Hidden check box
  5. Click OK
  6. The Program and Plan column is no longer visible and will not show up on the export.
Additional Information or Notes

For additional questions you can contact the JMU IT Help Desk at helpdesk@jmu.edu or 540-568-3555.

 

Print Article