PowerSchool Admin :: Quick Export Student Data from PowerSchool

Summary

Quick Export is used to export Student data for the current student selection. In addition to allowing administrators to export data from the Students table, data from related tables may also be exported via Quick Export using various Data Access Tags.

Details

1. Login to the PowerSchool /admin portal
2. From the Start Page, select the desired students
3. Select Quick Export from Functions, or Navigate to Start Page > Special Functions > Importing & Exporting > Quick Export
4. Enter the fields you'd like to export, and how you'd like the records to be delimited.  Copy from an example below. 
   
   

   student_number
   lastfirst
   grade_level
   schoolid
   enroll_status
   Street
   city
   zip
   Mother
   U_STUDENTSUSERFIELDS.mother_cell
   Father
   U_STUDENTSUSERFIELDS.father_cell
   U_StudentsUserFields.media_release
   Emerg_Contact_1
   Emerg_Phone_1
   StudentCoreFields.emerg_1_rel
   Emerg_Contact_2
   Emerg_Phone_2
   StudentCoreFields.emerg_1_rel
   StudentCoreFields.emerg_contact_3
   StudentCoreFields.emerg_3_phone
   StudentCoreFields.emerg_3_rel
   U_STUDENTSUSERFIELDS.emerg_4_name
   U_STUDENTSUSERFIELDS.emerg_4_phone
   U_STUDENTSUSERFIELDS.emerg_4_rel
   U_STUDENTSUSERFIELDS.emerg_5_name
   U_STUDENTSUSERFIELDS.emerg_5_phone
   U_STUDENTSUSERFIELDS.emerg_5_rel

5. Click Submit and open the file that is exported in Excel.  Use the steps below to learn how to automatically export and open in Excel

How to open export files in Excel

1. Always use Google Chrome
2. Export information from PowerSchool using Quick Export
3. Click Ctrl+J to access downloads in Google Chrome
4. Select Show in Folder
5. In the Downloads folder, right-click the file (student.export.text)
6. Choose Open With, and click Choose Program
7. Find and click Microsoft Excel
8. Select Always use the selected program to open this kind of file