How to Save Banner Reports as a CSV

ITS-ONLY, INTERNAL ARTICLE.

Overview

Many people run reports in Banner and print them to a physical Banner printer for paper output. This article describes how to save those outputs to .csv file instead of physically printing directly from Banner

Before you begin...

1. Go to Faculty & Staff
2. Click on Internet Native Banner (Banner Admin Pages)
3. Sign into Banner using your Net ID and Password.

Instructions

1. Open Form/Report you want to run. (SWRCGSR is the example in this document)
2. Change the Printer to DATABASE
   
3. Choose the report options as you normally would, click into the Submission block, and press Save
   Note: the green update in the upper-right hand corner of the screen that a .lis file was created.
   
   Note – at this point you should wait a minute for a Job Submission Log email to reach you. Once that has arrived, you know your .lis file output is ready in Banner
4. Review .lis file output
5. Go to Related>Review Output (GJIREVO)
   
6. Search for the .lis file output (you can search by date/time) and press OK
   
   The report output will show on the Banner window
7. Once report is showing (step 6) go to Tools>Export
   
   A .csv download will start in your browser that you can then open and work with.

Result

The user is able to run reports and save the output to a .csv file.