Questions and Answers

If you have question(s) or resources that you are looking for regarding PowerSchool Admin, PowerGrade or PowerTeacher and it is not here, please contact Mrs. Alspach.

Questions & Answers
           
1)  Q: How do I export data from PowerSchool and import into Excel?
A:
  • Open PowerSchool; login in
  • Select System on the left hand navigation bar
  • Select Direct Data Base (DDE) (about half-way down the page)
  • Current Table select the table which contains the information you need. (If you are not sure contact the PowerSchool administrator)
  • Search Table
  • Select Export Records
  • Then enter the field names of the information you need
  • Select Submit; save to your computer.  We suggest on your desktop.  This will be saved as a text document.
  • Open Excel
  • Open your saved document.  Remember to change type of document to "all files" or "text documents" so you can see the document you just saved.
  • You will then get a screen to import text file.  This document comes in really clean, just select: Next, Next, then Finished.
  • Your Data will then be in Excel ready to be edited, sort, etc.
  • When ready to save, select File, Save As. Change the type of document to "Microsoft Office Excel Workbook".  Rename your file name. (Suggest you also change location from destop to your personal files, i.e., C:/document files or your P: drive).
  • Don't forget to delete the "text document" from your desktop.
  • If you need any other help please contact your PowerSchool Administrator.

      •                                            

           
Website by SchoolMessenger Presence. © 2024 SchoolMessenger Corporation. All rights reserved.