Exporting data from Banner

Data can be exported from some Banner screens to a spreadsheet. Some of these screens include:

• SFASLST - Class Roster

• SHACRSE - Course Summary

• SHATERM - Term Sequence Course History > Term GPA tab

• SZAREGQ - Registration Query

• SCAPREQ - Catalog Prerequisite and Test Score Restrictions

When on a screen which can be exported, in the purple bar at the top, click the Tools menu and select Export.

Open

You will be asked to choose a location and name for the downloaded file. The file will download to a .txt file.

Open

Open the .txt file. Select all and copy. Open Excel and paste into a new workbook.