Team Roster & Results
Upload meet result CSVs, add swimmers, and review what families will see.
Importing from Swimtopia
Two CSVs flow into this site: a roster (who's on the team, with parent emails) and meet results (the times). The importer auto-detects Swimtopia's column names — including "Athlete Last Name / Athlete First Name" and the "Last, First" name format used in result reports.
Roster export (do this first)
-
1
Sign in to Swimtopia
Go to swimtopia.com (or your team's .swimtopia.com subdomain) and sign in with your coach / admin account.
-
2
Open Athletes → Export
From the team dashboard, go to People → Athletes (or Roster). Click the Export / Download button and pick CSV.
-
3
Include parent contact columns
Make sure the export includes
Athlete First Name,Athlete Last Name,Group,Date of Birth,Account Name(parent), and at least one email column (Parent 1 Email/Account Email). These power the family lookup. -
4
Drop it in the Roster zone below
Use the Upload Roster card. Every swimmer, parent, group, and email is saved to Firebase. No times are added by this step.
Meet results export (after each meet)
-
1
Open the meet → Results → Reports
On the meet page, click Results, then Reports. Choose Individual Results or Athlete Results (one row per swimmer per event).
-
2
Export as CSV
Click Export → CSV (.csv). Swimtopia results usually use the
Athletecolumn in "Last, First" format — that's fine, the importer flips it for you. -
3
Drop it in the Meet Results zone below
Times merge into the roster you already uploaded. Matching swimmers gain new races; nothing is overwritten.
Tips for the cleanest import
- Upload the roster first, then meet results. That way the email/parent info is on file before times start landing.
- The importer understands Swimtopia's column names —
Athlete First Name,Athlete Last Name,Account Name,Parent 1 Email,Group Name,Date of Birth, etc. No renaming needed. - Names in "Last, First" format are auto-flipped. "Carter, Riley" becomes "Riley Carter" automatically — Swimtopia's results reports use that format.
- Multiple email columns are all kept (e.g.
Parent 1 Email+Parent 2 Email) — families can look up the swimmer using any of them. - Keep swimmer names consistent across meets so results stack on one swimmer card.
- Times can be
SS.HH(28.42) orM:SS.HH(1:02.18). Both formats work. - Re-uploading the same file is safe — matching rows merge, new ones append.
Upload Roster
Drop your Swimtopia roster export here. Recognized columns include
Athlete First Name, Athlete Last Name,
Parent 1 Email / Account Email,
Account Name (parent), Group Name, and Date of Birth (used to compute age).
No times are required.
Roster CSV columns the importer recognizes
Athlete First Name,Athlete Last Name,Date of Birth,Group Name,Account Name,Parent 1 Email,Parent 2 Email,Address Riley,Carter,2014-08-12,Bronze,Jordan Carter,jordan@example.com,morgan@example.com,415 Coastline Drive Mateo,Rivera,2015-02-04,Silver,Sofia Rivera,sofia@example.com,,82 Pine Ridge Lane Ava,Thompson,2013-11-30,Gold,Marcus Thompson,marcus@example.com,,127 Lakeshore Court
Upload Meet Results
Drop the Swimtopia meet results CSV here. Required: Athlete (or Athlete First Name + Athlete Last Name), Event, Time, Meet. Optional: Date, Place, Age, Group. Names in "Last, First" format are flipped automatically.
Results CSV format example
Athlete,Event,Time,Meet,Date,Age,Group,Place "Carter, Riley",50 Free,28.42,Spring Invitational,2026-03-14,11,Bronze,3 "Carter, Riley",100 Free,1:02.18,Spring Invitational,2026-03-14,11,Bronze,5 "Rivera, Mateo",50 Free,30.10,Spring Invitational,2026-03-14,10,Silver,7 "Thompson, Ava",50 Fly,35.20,Spring Invitational,2026-03-14,12,Gold,2
Add or Update Swimmer Manually
Use this when you need to register a swimmer before their first meet, or fix a parent name / email. "Last, First" names are auto-flipped.
Roster
Click Edit next to any swimmer to manage their emails, parents, age, or group. Families look up their swimmer using the swimmer's name + an email on this list.