Creating a Custom Student List in PowerSchool SIS

This guide walks you through creating a Custom Student List in PowerSchool SIS that allows you to select specific student fields and export the data for use in Google Sheets or Microsoft Excel.

Step 1: Select Your Group of Students

Log in to PowerSchool SIS.
Use the Student Search field to find the group of students you want to include.
- Example: grade=10 or click on a grade and use any other fields to create a list.
  Ways to search PowerSchool SIS
Click Submit to view the list of matching students.

Step 2: Create a Custom Student List

From the student list page, click the Group Functions button at the bottom.
Select List Students.
In the Fields to Display box, enter the field names you want to include.
- Example:
  Adding fields to a custom list
- You can find field names using the Data Dictionary or by referencing the PA State Fields documentation:
  - PowerSchool Data Dictionary PDF
  - PA State Fields List
Optional: Add a title or header for your list in the Custom Title field.
1. Tip: this would be the header title for speadsheat

Step 3: Generate and Export the List

If you wish to just create list, then copy and paste it into Google Sheets follow the directions below
Click Submit to generate the list.
Once the list appears:
- To copy into Google Sheets:
  - Highlight the entire table.
  - Right-click and choose Copy.
  - Open Google Sheets and paste the data.

To export to a .txt file for Excel:

Scroll to the bottom of the list and check the Export option

Export to Excel Option
- Save the file locally.
- The file will download, then right-click the file and click Open with Excel
  
  Open with Microsoft Excel via the Open With Menu

🆘 Need Help Beyond the KB?

If you can’t find what you’re looking for or need hands-on support, reach out to the SCASD IT Services team:

📞 Phone: 814-231-7743
🕒 Hours: Monday–Friday, 8:00 AM–4:00 PM
💬 Submit a ticket: IT Services Portal