Roster Exports

Each session’s roster can be downloaded as a CSV or published to a Google Sheet that updates itself whenever registrations change.

Downloading a CSV

1. Open the session
2. Click Download CSV in the page header (shown once the session has registrations)

The file is named Program_Session_start-date_roster.csv and has one row per active registration with: Registration ID, Registered At, Status, Family, Account ID, Member, Date of Birth, Member ID, Class, Level, Days, Start Time, End Time, Fee, Lottery Number, Waitlist Offer Expires and Family Emails. Cancelled registrations are left out. Family Emails lists every login-holder email on the participant’s family, comma-separated, so instructors can contact parents directly.

Google Sheets Sync

The Google Sheets panel sits between the session header and the tabs.

1. Click Create Sheet — the sheet is created in the club’s shared drive, named “Program — Session (date) — Roster”, with a Roster tab holding the same columns as the CSV
2. Click Open to view it, or Sync now to force a refresh
3. To share it, add people to the shared drive in Google Drive — access isn’t granted per sheet

Once connected, the sheet is rewritten from the database whenever anything changes: member registrations and cancellations, waitlist joins and offers, cart checkouts, admin bookings, moves, cancellations and promotions, and in-person lottery checkouts. The panel shows Last synced and, if a sync failed, Last sync error.

Click Disconnect to unlink the session. The sheet stays in the shared drive for you to delete by hand, and you can create a new one afterwards.

Caution

Sync is one-way — database to sheet. Edits made in the sheet are overwritten on the next sync, so treat it as a live view, not a place to make changes.

Tip

The CSV and the sheet carry the same columns, so a downloaded file is a snapshot of exactly what the sheet shows.