From the St. John's University
Web site click on "Login SJU SIS" on the grey footer
bar at the bottom of the Web site.
- Enter your SJUSIS user ID and six digit PIN.
- Click the "Login" button.
- Click "Faculty Services".
- Click "Export Roster".
- Select the term of the class you want to export and click the
"Submit Term" button.
- Select the course you want to export and click "Submit
CRN".
- From the menu bar, choose "File" then click "Save As".
You may get a alert pop up saying "This web page may not save
correctly". Just click "Yes".
- Choose where you want to save the roster. Give it a name and
select "Text File (*.txt) as the 'Save as Type" then click
"Save".
- Open up Microsoft Excel and then choose "File" form the menu
bar and click on "Open".
- Select the location of the roster you just saved. Set "File
Type" to "Text File". Then click "Open".
- Choose the "Delimited" option. Set the "Start import at" option
to "20". Then click "Next".
- Choose only "Comma" as the delimiter. Then click "Next".
- Select the "General" option. Then click "Finish".
- Select "File" from the main menu. Then click "Save As".
- Select the folder you want to save the roster in. Set the 'Save
as type' to "Microsoft Excel Notebook". Then click the "Save"
button.