Working with PowerSchool data

On this page:

• Exporting a roster from PowerSchool

• Exporting scores from PowerSchool

• Importing PowerSchool rosters and scores 

To use PowerSchool data in GroupUp, you need to export the class roster and scores separately for each class and then import those files into GroupUp.

Exporting a roster from PowerSchool

1. Open the PowerTeacher Pro portal for the class you want to export.

2. Go to Reports.

3. Click Student roster.

4. In the Criteria tab, for the contact columns select Student number.

5. Check that Column name on the report is set to Name and Id.

6. In the Format tab, select CSV (or Excel) for output.

7. Click Run report.
   You should see a notification that it completed.

8. Click View report.
   You should see the newly created report at the top.

9. Download the report.

10. If the report is in Excel format, open it in a spreadsheet app (E.g., Excel, Numbers, or Google Sheets) and export or download it as a CSV.

The roster only needs to be exported once unless there are new students added or students leave. 

Exporting scores from PowerSchool

1. Open the PowerTeacher Pro portal for the class you want to export.

2. Go to Reports.

3. Click on Scoresheet report.

4. In the Criteria tab:

   • Select Student number as the student field.

   • Select the categories you want exported (or just select all of them).

   • Confirm that the date range is what you want.

5. In the Format tab, select CSV (or Excel) for output.

6. Click Run report.
   You should see a notification that it completed.

7. Click View report. You should see the newly created report at the top.

8. Download the report.

9. If the report is in Excel format, open it in a spreadsheet app (E.g., Excel, Numbers, or Google Sheets) and export or download it as a CSV.

Importing Powerschool rosters and data

Creating a class and importing the roster

1. Select My classes at the top of the screen.

2. Click Add classes > Create a class.

3. Name the class and click Add.

4. Click the ellipsis next to your class and choose Import class data.

5. Find and select your class roster CSV file. 

6. Click Next once you see it on the screen.
   You should see a preview of the data you’re importing. 

7. Click Import and save.

8. Repeat to import rosters for each class. 

Import class scores

9. Click the ellipsis next to your class and choose Import class data.

10. Find and select your class roster CSV file. 

11. Click Next once you see it on the screen.
    You should see a preview of the data you’re importing. 

12. Click Import and save.

13. Repeat to import scores for each class.