A browser-based tool for generating field trip rosters with emergency contact information. Upload your master student list and an event roster to quickly create a complete spreadsheet.
- Privacy-first: All processing happens in your browser. No data is uploaded or stored anywhere.
- Multiple input formats: Accepts Excel (.xlsx, .xls) and CSV files
- Google Sheets support: Paste data directly from Google Sheets
- Smart matching: Matches students by ID and pulls in emergency contact and medical info
- Excel export: Download results as a formatted .xlsx file
- Open
index.htmlin your browser - Upload or paste your Master Student List containing all student information
- Upload or paste your Event Roster with just the student IDs for the trip
- Click Match Students
- Download the generated Excel file
Master Student List:
StudentIDFirstNameLastNameEmergencyContactEmergencyPhoneMedicalInfo
Event Roster:
StudentID
- Column matching is case-insensitive
- Students not found in the master list will be flagged as "Missing"
- Only matched students are included in the downloaded file