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
    A screenshot of a cell phone Description automatically generated
  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.
    A screenshot of a cell phone Description automatically generated
    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)
    A screenshot of a cell phone Description automatically generated
  6. Search for the .lis file output (you can search by date/time) and press OK
    A screenshot of a cell phoneDescription automatically generated
    The report output will show on the Banner window
  7. Once report is showing (step 6) go to Tools>Export
    A screenshot of a cell phoneDescription automatically generated
    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.

Print Article