Import your SportsEngine registration export

Written By Squad Rotate Admin

Last updated About 2 months ago

During the beta, registration stays on SportsEngine. LeagueRun brings those players in from a CSV, so you never re-key an export into a master sheet. There is no live SportsEngine connection yet — the CSV is the bridge.

You do not need to rename, reorder, or delete columns. Export everything and match your columns on screen. For a screen-by-screen walkthrough, see How the import wizard works, step by step.

Step 1 — Export from SportsEngine

Run your registration report and export it to CSV, or to a spreadsheet you can save as CSV.

Two columns are worth going back for if they are not in your export:

  • Parent/guardian email. It is how LeagueRun recognizes a child it has seen before, so a later import updates families rather than duplicating them.
  • Date of birth. It is how children land in the right age group when your file has no program column.

Step 2 — Import

  1. Open Registrations.
  2. Click Import CSV.
  3. Choose your .csv file, or paste the text of it.
  4. On the mapping screen, check that the fields you care about are matched. Anything LeagueRun cannot match confidently is excluded, and nothing from an excluded column is written. There is a count under the table telling you how many that is.
  5. If your file has a program column, confirm which LeagueRun division each program belongs to.
  6. Read the report.

You do not pick a division first. The import runs across your whole season.

What the values should look like

Formatting matters less than it used to — most of these are read flexibly — but for reference:

  • Birth year is a 4-digit year. A full date of birth works too and is preferred.
  • Experience is 1 to 5. It also accepts the full answer text from a preseason survey. If your column holds something like Novice: knows basic skills and is learning intermediate skills, LeagueRun reads the label at the front and scores it on your scale in order — True Beginner is 1, Advanced is 5. You do not need to convert those answers to numbers by hand.
  • Gender is girl or boy.
  • Available nights uses mon, tue, wed, thu, fri, separated by a pipe — for example mon|wed.

Re-importing

Re-importing the same file is safe, and so is importing a later, larger export. LeagueRun matches on guardian email plus player name, and falls back to division plus player name when there is no email. You do not need to delete your registrations first.

The one case that needs your eye is the same name appearing twice in one division — LeagueRun will not guess which is which, so it adds the row and flags it.