Exporting data from Banner

Owned by Denise Kidd
Jun 12, 2023
1 min read

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.

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

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