uploading information from an excel sheet to PowerSchool

ctiburcio
Padawan

uploading information from an excel sheet to PowerSchool

Good morning, 

I would like to know if there is a way to mass input student information into Power School from an excel sheet? 

Thank you. 

10 Replies
HeatherWeist
PowerSchool Mentor
PowerSchool Mentor

Absolutely... @ctiburcio 

 

What information our you wanting to upload? The file must be saved as a txt before you can import. The column headers must be the SIS field names you are importing to. You also need to have the student_number, studentid or studentdcid in order to link the data to the student. 

 

 

 


Heather Weist, MEd
PowerSchool - SIS Administrator, Commonwealth Charter Academy

PowerSchool Mentor/Champion

PowerSchool Mentor of the Year 2021 Winner

PowerSchool Beta Tester of the Year 2022 Winner


Did your issue get solved? Please remember to give Kudos and/or select Accept As Solution on the helpful posts to thank the author and to help others find the solution. Thanks!

Mentors_badgeChampions_badge
jimmycastillo23

Hi @HeatherWeist 

 

Would you please help me with uploading an Excel file? How do upload excel file " Fixed assets" from Excel to Business plus? Thank you!   

HeatherWeist
PowerSchool Mentor
PowerSchool Mentor

@jimmycastillo23   Unfortunately...I don't use Business plus, so I'm not sure of the field names and tables. 


Heather Weist, MEd
PowerSchool - SIS Administrator, Commonwealth Charter Academy

PowerSchool Mentor/Champion

PowerSchool Mentor of the Year 2021 Winner

PowerSchool Beta Tester of the Year 2022 Winner


Did your issue get solved? Please remember to give Kudos and/or select Accept As Solution on the helpful posts to thank the author and to help others find the solution. Thanks!

Mentors_badgeChampions_badge
jimmycastillo23

Thanks @HeatherWeist Do you know anyone who uses Business Plus? 

Reshma
Community Support Expert
Community Support Expert

Hi @jimmycastillo23!

 

Thank you for reaching out to PowerSchool Community!

 

To upload Fixed Assets into BusinessPlus, you can use FAUTZZ which is very user-friendly and allows the user to select what table they want to upload to.  We recommend reaching out to the Designated Support Contact within your district who should be able to assist you further with providing the documentation for more information. 



Reshma
PowerSchool Community Support Expert

Remember to give Kudos to suggestions that help you!
If another user helps solve your issue, please select Accept As Solution on their post so others can see the solution, too!
nataliestlaurent

Hi All! Can you help with how to add attendance data from excel to powerschool please?

JyotishkaB
Community Support Expert
Community Support Expert

Hi @nataliestlaurent

 

To assist you further, would you please confirm which PowerSchool product you are referring to?

 

 

Jyotishka B.
Community Moderator



Remember to give Kudos to suggestions that help you!
If another user helps solve your issue, please select Accept As Solution on their post so others can see the solution, too!

nataliestlaurent

PowerSchool SIS

JyotishkaB
Community Support Expert
Community Support Expert

Hi @nataliestlaurent

 

You can import the attendance using Quick Import.  Please refer to this article: Import Template to import Meeting and Daily attendance into PowerSchool.

 

 

Jyotishka B.
Community Moderator



Remember to give Kudos to suggestions that help you!
If another user helps solve your issue, please select Accept As Solution on their post so others can see the solution, too!

nataliestlaurent

Thank you so kindly for this prompt response. Will update you upon success! 🙂