Opening PowerSchool Exports in Excel

Do you have questions about how to take a PowerSchool export file and open it in Excel? Then this is for you.

Mac OS X

Safari
Currently, Safari does not have the functionality to export information automatically from PowerSchool to Excel; however, use the following procedure to transfer information quickly from the browser to an Excel spreadsheet when you export information.

1. Export information from PowerSchool using Quick Export, Export Using a Template, Direct Database Export, Direct Database Access
2. When the information appears in a new browser window, choose File > Save As and save the file on your desktop
3. Control-click or right-click the exported file (student.export.text) on your desktop
4. Click Open With > Other
5. In the Choose Application window, click the Enable menu, click All Applications, and select Microsoft Excel
6. Click Open

Firefox

1. Use Quick Export to export data from PowerSchool
2. On your desktop, control-click or right-click the name of the exported file (student.export.text)
3. Click Open with > Other
4. In the Choose Application window, click the Enable menu, and choose All Applications
5. Click Microsoft Excel
6. Select the check box for Do this automatically for files like this from now on
7. Click Open

From now on, when Firefox asks if you want to open or save the file, you can choose Open, and the file will open in Excel.

Windows

Internet Explorer

1. Export information from PowerSchool using Quick Export, Export Using a Template, Direct Database Export, Direct Database Access
2. Save the export file to your desktop
3. On your desktop, right-click the file (student.export.text)
4. Click Open With, and click Choose Program
5. Find and click Microsoft Excel
6. Select Always use the selected program to open this kind of file
7. Click OK

From now on, when Internet Explorer asks if you want to open or save the file, you can choose Open, and the file will open in Excel

Firefox

1. Use Quick Export to export data from PowerSchool
2. On the Opening student.export.text window, click Open With and then EXCEL.EXE or Microsoft Excel (if Microsoft Excel is not in the menu, click Other)
3. From the Choose Helper Application window, click Browse
4. Find and click Microsoft Excel
5. In the Opening student.export.text window, select Always use the selected program to open this kind of file
6. Click OK

From now on, when Firefox asks if you want to open or save the file, you can choose Open, and the file will open in Excel.