ScoreLM Guides
scorelm.com

Import players, teams or games from a spreadsheet

By the end you’ll have a batch of players imported from one CSV file, on their teams and on your website.

  • Who: League admin or Editor
  • Time: 3 min
  • Steps: 6
Video · 1:04 · Voiceover · every step is also written on screen Prefer to read? Steps below

Before you start

  • You need a CSV file with one player per row and the column names in the first row. In your spreadsheet app, download or save the sheet as CSV. Here: six new players for four teams.
  • Players link to teams by short code, like FND for Foundry, so the teams have to exist first. To import teams too, do them first.

Steps

  1. Step 1: In the left menu, click Players.

    Your players are listed, grouped by team.

    Fig. 1

    Scroll sideways to see the whole screen.

    The Players page with the Players link highlighted in the left menu.
    Fig. 1Start from Players.

  2. Step 2: Click Import at the top right.

    Import opens on Players, in four steps: Upload, Match columns, Review and Import. Columns lists every column it can read.

    Fig. 2

    Scroll sideways to see the whole screen.

    The Import button at the top right of the Players page.
    Fig. 2Import, at the top of Players.

  3. Step 3: Click Choose a file and pick your CSV, like new-players.csv.

    Up to 1,000 rows at a time. You can also drop the file on the box, or paste the CSV text below it.

    Fig. 3

    Scroll sideways to see the whole screen.

    The Upload a CSV box with Drop a CSV here and the Choose a file button.
    Fig. 3Upload a CSV.

  4. Step 4: Check the matches, then click Review 6 rows.

    Each field shows the CSV column it reads from, with sample values beside it. Here Team went to Team short code and Number to Jersey number. To skip a field, choose Leave blank.

    Fig. 4

    Scroll sideways to see the whole screen.

    The Match columns step: Team short code reads the CSV’s Team column and Jersey number its Number column, with sample values beside them.
    Fig. 4Each field matched to a CSV column.

  5. Step 5: Check the rows, then click Import 6 players.

    Each row is checked first: New, Exists or Fix. Here all six are New.

    Fig. 5

    Scroll sideways to see the whole screen.

    The Review step with six rows marked New and the Import 6 players button.
    Fig. 5Six new players, ready to import.

  6. Step 6: Click ↗ (View public site) at the bottom of the sidebar; your website opens in a new tab. Then click Teams and Foundry.

    Foundry’s roster now includes the two players from the file, Rowan Hale and Dmitri Vance.

    Fig. 6

    Scroll sideways to see the whole screen.

    The public Foundry team page with Rowan Hale and Dmitri Vance in its roster.
    Fig. 6Imported players on Foundry’s page.

What you’ll see

Six players are in your directory, each on their team. A player with a team also joins that team’s roster in each active season the team is in, so you can pick them in box scores.

Fig. 7

Scroll sideways to see the whole screen.

The Import step showing Import finished and 6 created, with Open Players.
Fig. 7Import finished: 6 created.

Common questions

How do I import teams or games?
In Import, switch to Teams or Games at the top. Teams need a Team name and a Short code. Games import into a round-robin competition you pick, and both teams of every game must be in it. Each tab’s Columns list shows what it reads, and Template gives you a CSV with those columns.
What if a player is already there?
A row matches an existing player with the same first and last name on the same team. Under Rows that already exist, choose Skip them (the default), Update them or Treat as an error.
A row says Fix. What now?
Its Problems column says why, like a team short code that doesn’t exist. Click the cell to correct it, then click Check again. Or tick Skip to leave that row out.
My columns have different names. Does that matter?
No. Import matches common names, like Team or Number, and you can change any match on Match columns. Columns it doesn’t use are listed as Not imported.