Import a roster or a schedule from a spreadsheet
Paste rows from Excel, Numbers, Google Sheets or a CSV to add players or events in one go, after a preview.
Team staff and club admins can set up a team's roster or schedule from a spreadsheet instead of adding each player or event by hand. You paste the rows, check a preview, and then import. Nothing is saved until you choose Import.
Open the importer
- Open the team's page.
- Under Add a player, choose Import from a spreadsheet.
You'll see the button only on a team that isn't archived, in a club that can take changes. If you don't see it, ask a club admin.
Paste your rows
- Under What to import, choose Players or Events.
- In your spreadsheet, select the rows together with the row of column names above them, and copy. This works the same in Excel, Numbers and Google Sheets.
- Paste into Rows to import. You can also paste the text of a CSV file, with commas or semicolons between the cells. In CSV text, a cell with a comma or semicolon in it needs quotation marks around it. If a line has more cells than there are column names, the app names the line and imports nothing, so no cell lands in the wrong column.
- Choose Next: match the columns.
The row of column names is required. You can paste up to 200 rows at a time. If you paste more, the app asks you to paste them in parts.
- Players need a name: a first and last name, or a full name. Jersey numbers and positions are optional. A full name can be written first name then last name, or last name, a comma, then first name. Several positions in one cell are fine, and the first is the main one.
- Events need a date and a start time. The type, end time, opponent or title, place, address and notes are optional. Times are read on the team's clock, which the screen shows.
Match the columns
On Match the columns, the app guesses what each column holds from its heading, in English or Spanish, and shows the first row's value under it. Change any wrong guess, or choose Skip for a column you don't need. The fields are First name, Last name, Full name, Jersey number and Position for players (choosing Full name clears First name and Last name, and the other way round), and Type, Date, Start time, End time, Opponent or title, Place, Address and Notes for events.
For events there are three more settings:
- Dates are written: Month first or Day first. See the section on dates below.
- Type for rows with none: the type used for any row whose type is blank. It starts as Game.
- Events with no end time last: 60, 90 or 120 minutes. It starts at 90.
Columns the app never keeps
On a players' sheet, birth, contact, address, guardian, school and health columns are never kept. This covers columns such as birth date and age, email, phone, a family's address, parents and guardians, school and grade, and medical, allergy, height, weight, gender, race, photo and similar headings. (The Address column on an events' sheet is different: it's where the event is held, and it's saved.) The player columns show Not kept and have no choice to make. Their contents aren't read into a row, shown on screen or saved, so you don't need to remove them from your sheet first.
Check the preview
Choose Preview. Check before you import lists every row with what will be saved, and one of these:
- Ready to import
- Already on the roster. Skipped. or Already on the schedule. Skipped.
- Same as row and a number, Skipped. The same row appears earlier in what you pasted.
- The problem with the row, for example an unknown position or a date that can't be read. Fix it in your spreadsheet, then paste again, or choose Back to the columns if the fix is a different column choice.
The summary on top says how many rows are ready and how many will be skipped. Rows with a problem are not imported.
Import
Choose the button that names how many are going in, such as Import 12 players or Import 8 events. Only the rows the preview showed as ready go in. If the roster or schedule changed since the preview so that a skipped row is now ready, nothing goes in yet: the preview comes back as it now stands, so you can check it and import again. Keep the screen open while it says Importing and counts up.
If another screen opens over it, for example a notification you tap, the import stops after the row it's on. Come back to it and choose Import the rest. If you leave the importer, the rows not yet added aren't added: paste the same rows again, and the ones already in are skipped.
When it finishes, Import finished shows each row as one of:
- Added
- Skipped, with the reason
- Not added, with the reason
Choose Done to leave.
If you run it again
Running the same paste again won't add anything twice. A player whose name matches one already on the roster is skipped, ignoring capital letters, accents and spacing. An event that starts at the same time as one already on the schedule is skipped, whatever its type.
When there are more than one batch allows
The app adds up to 30 players or 20 events at a time. When a batch ends before all rows are done, the result says still to import and asks you to wait a minute. Then choose Import the rest. It checks the roster or schedule again first, so nothing goes in twice. Rows that were Not added stay marked, with their reasons, and aren't sent again.
If the import stops for another reason, such as losing your connection, the result says why and Import the rest sends the rows that haven't gone in.
How dates are read
The importer reads numeric dates such as 9/12/2026, 2026-09-12 and 12.09.2026. It reads them month first (9/12/2026 is September 12), unless a date in the column can only be day first, like 25/9/2026. Then it reads the whole column day first.
The preview shows each date in words, so you can see if the guess is wrong. To change it, go Back to the columns and set Dates are written to Month first or Day first. A date written with a month name, such as "Sept 12", isn't read: change it to numbers.