How to Use the Import Student Excel
Bulk import students and room assignments using the StayPut Excel template.
For trips with a lot of students, or when you already keep a roster in a spreadsheet, use the Excel template to set up all your rooms and students at once instead of adding them one by one.
Uploading a file overwrites all rooms and students currently on the trip with what’s in the spreadsheet. Review the import preview carefully before confirming — it can’t be undone.
Open the Excel Import Panel
Go to Trips, open the trip, and select the Students tab. Select Import Students (or Import), then switch to the Excel Import/Export tab.
Download the Template
Select Download Excel Template. It comes pre-filled with the trip’s current rooms and students, so editing an existing roster is just a matter of updating the downloaded file. Requires Office 365 or Excel 2021+ (it uses live formulas to check room capacity); StayPut recommends a maximum of 300 students per trip.
Edit the Spreadsheet
The template has two sheets:
- Room Configuration — one row per room, with Room Name and Occupancy columns.
- Students — one row per student, with Student Name, Notes, and a Room Assignment dropdown that lists the rooms from the Room Configuration sheet. Leave Room Assignment blank for an unassigned student. A live Room Overview on the right side of the Students sheet shows each room’s current headcount and flags rooms that are over capacity.
Add, remove, or edit rows in either sheet, then save the file.
Upload the File
Back in the Excel Import/Export panel, drag the edited file into Upload Excel File (or select it manually). Files must be .xlsx and under 10 MB.
Review and Confirm
StayPut shows a preview of what will change — rooms and students to add, update, or delete — plus any warnings, such as students who’ll be auto-unassigned because their room was removed from the spreadsheet. Select Confirm Import to apply it, or Cancel to back out without changing anything.