How to Use Quick Export

  1. On the start page, search for and select a group of students. A list of students appears in the Current Student Selection section.
  2. Click the [Select Function] arrow. The Group Functions pop-up menu appears.
  3. Under Export, choose Quick Export. In most cases, you will not need to change the default options on the Export Students page, in which case you can skip the next step. To change the selections, proceed to the next step.

    Note: Alternatively, if you have a current selection of students, you can choose Special Functions under Functions in the main menu and then click Groups Functions.

  4. Use the following table to enter information in the fields:

Field

Description

[Fields to be Exported]

Enter the fields to be included on the exported spreadsheet. Enter as many fields as needed. Enter only one field per line. Separate multiple fields with a hard return.

To insert a PowerSchool field into this field:

  1. Click Fields at the bottom of the page to view a list of PowerSchool fields. The Fields pop-up appears.
  2. To narrow the list of fields, enter one of more search terms in the Filter field. Otherwise, leave blank.
  3. Click the field you want to add. The Fields pop-up closes and the selected field appears.

Note: Database extension fields can be selected on the Fields pop-up. For more information, see Database Extensions in the System Administrator User Guide available on PowerSource.

Field Delimiter

A field delimiter separates fields (or "columns") in the exported data. Use the pop-up menu to choose how you want the system to separate each field in the export file:

  • Tab
  • Comma
  • None
  • Other: Enter the delimiter in the blank field.

Record Delimiter

A record delimiter separates records (or "rows") in the exported data. Use the pop-up menu to choose how you want the system to separate each record in the export file:

  • CR: Carriage return
  • CRLF: Carriage return and line feed
  • LF: Line feed
  • Other: Enter the delimiter in the blank field.

Surround Fields

Select the checkbox to surround the fields in the exported data with quotation marks.

Column titles on 1st row

Select the checkbox to include column titles on the first row of the exported data.

Export DCID

Select the checkbox to export the Student table's unique identifier.

  1. Click Submit. The exported data appears.
  2. Choose File > Save As... to save the file. Open the saved file using a spreadsheet application, such as Excel or Lotus 1-2-3. Format, print, and save it as any other spreadsheet document.