Upload your existing Excel roster (.xlsx or .xls). The importer reads your column headers automatically and maps them to the right fields.
2
Review the preview table. Green rows are ready to import. Orange rows are missing a name and will be skipped.
3
Click Import All Valid Rows to add them to the roster. Existing cadets are not affected — this only adds new records.
Recognised column names (exact spelling not required):
Last Name · Father/Guardian First Name · Cadet First Name ·
Cadet's Birthday (MM/DD/YYYY) · Join Date in TSG (MM/YYYY) · Grade as of...
Patrol columns (St. Matthew Angels, St. Mark Lions, etc.) are also read to infer grade if no grade column is present.
Upload File
📄
Click to choose a file, or drag and drop here
.xlsx or .xls files only
Export National Roster
Downloads the current active roster in the official National TSG format — last name, guardian, cadet name, birthday, join date, grade as of 09/01/, and patrol lists sorted by patrol. Ready to submit to National.