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.

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.

Related content

Viewing and exporting a course roster (SFASLST)
Viewing and exporting a course roster (SFASLST)
More like this
Banner forms quick reference
Banner forms quick reference
More like this
Saving Banner favorites
Saving Banner favorites
More like this
Adding documents to BDM
Adding documents to BDM
More like this
Accessing Banner (interns)
Accessing Banner (interns)
More like this
Request and Configure Table Dumps - SFRRSTS, SFRRFCR, SFRCTRL
Request and Configure Table Dumps - SFRRSTS, SFRRFCR, SFRCTRL
More like this