A good start with TrainTeam

Your squad. Without the retyping.

Import football players from Excel or CSV. Map columns, check the data and bring your squad over with parent contact details.

  • Excel and CSV
  • Preview before saving
  • You decide when to invite
TrainTeam
Import

Import

File preview

squad-u12.xlsx
In the file
24
Ready to save
22
Need correcting
2

Import people

PersonDate of birthSummary
1Person 112 May 2014Ready
2Person 212 May 2014Ready
3Person 312 May 2014Needs attention
Illustrative mockup · sample data

From spreadsheet to squad

Start with the data you already have.

Use your XLSX or CSV file, or the ready-made template. See what will go into TrainTeam before you save anyone.

Club workspace

You have the spreadsheet. Turn it into your squad.

Player lists, parent contacts and sporting details. Bring them into the workspace your team uses every day.

What you can do in the importer

01

Your file, your columns

Upload XLSX or CSV. We match recognised headings to fields; you can map the remaining columns in the preview.

02

A ready-made Excel template

Download a template with headings and instructions. Fill it with club details and upload it to the selected team.

03

Player sporting details

Bring over dates of birth, positions, shirt numbers and medical clearance dates when they are in your spreadsheet.

04

Contacts alongside the squad

Import players and parent details according to the team's contact mode. Send app invitations separately.

05

Check the data first

See missing information, warnings and possible duplicates. Review everything before saving people to the team.

06

Import report and result

See who was saved and which rows need attention. Download the report and a file of people to correct.

TrainTeam

Club workspace · Import

File loaded

Map your file columns

squad-u12.xlsx

Full name

Full name

Date of birth

Date of birth

Guardian email

Parent email

Details from your spreadsheet

Alex Smith

Player · U12

Date of birth
12 May 2014
Shirt number
10
Position
Midfielder
Nothing is saved without confirmation.
Illustrative mockup · sample data

01 · Less manual work

Your file, your columns

Upload XLSX or CSV. We match recognised headings to fields; you can map the remaining columns in the preview.

A ready-made Excel template

Download a template with headings and instructions. Fill it with club details and upload it to the selected team.

02 · Less manual work

Check the data first

See missing information, warnings and possible duplicates. Review everything before saving people to the team.

Import report and result

See who was saved and which rows need attention. Download the report and a file of people to correct.

TrainTeam

Club workspace · Import

Summary

Import

Check the data before saving

See errors, warnings and possible duplicates.

  1. 1File
  2. 2Mapping
  3. 3Summary
Nothing is saved without confirmation.

Import summary

Know what has been saved.

1

Alex Smith

Player and parent saved

Saved
2

Jamie Taylor

Add the parent's email to the file

Needs attention
Download the import report
Illustrative mockup · sample data

Who it is for

Everyone has a role when the team gets started

Administrators and coaches prepare the squad within their permissions. Families use the saved details after a separate invitation.

Club administrator

Selects the team and imports players, parents and staff. Reviews details and the contact mode before saving.

Coach

Prepares their own team's squad with players and parent details. Import requirements depend on the contact mode and their permissions.

Parent and player

Do not operate the importer. The club saves their details and sends app invitations separately when it is ready.

TrainTeam / After importing

Alex Smith

Player · U12

Date of birth
12 May 2014
Shirt number
10
Position
Midfielder
Medical clearance until
30 Jun 2027

Parent / guardian

Sam Smith

parent@example.com

Saved
Illustrative mockup · sample data

After importing

The details stay on the player card

Once saved, the player belongs to the team. Their details and linked parent are available in TrainTeam according to the viewer's permissions.

Importing data is the first step.

Import does not send invitations. Send them separately from a person's card when your club is ready. Read the import guide

Preparing your data

Two routes to a ready squad

Start with your own spreadsheet or the TrainTeam template. Both let you review mapping and data before saving.

XLSX and CSV

Your own file

Already have a player list in Excel or an exported CSV file? Upload it and choose which fields its columns belong to.

  1. 1Choose a file from your computer
  2. 2Map the columns in the preview
  3. 3Check the data and confirm saving
XLSX template

Ready-made template

Prefer a structured starting point? Download the template from the importer. Its headings and instructions help you prepare your data.

  1. 1Download the template in the importer
  2. 2Fill it with your team's details
  3. 3Upload the file and review the preview

Less manual work

From spreadsheet to a ready squad

Upload your file

Choose your XLSX or CSV file, or use the TrainTeam template.

Check the preview

Match columns and review the data before it reaches your team.

Start working with your team

Confirm the records. Send invitations to the app separately.

Read the import guide

FAQ

Before your first import

How do I import football players from Excel?

Open the importer in TrainTeam, upload an XLSX or CSV file, map the columns and review the preview. Then confirm saving people to the selected team.

Which files can I use to import a squad?

Use an Excel XLSX or CSV file. The importer reads the first worksheet in a workbook. You can also download a template with headings and instructions inside the importer.

Can I import parent contact details?

Yes. Map the columns containing parent details. Before saving, check the team's contact-mode requirements and warnings about any data that will not be saved.

Does importing automatically send invitations?

No. Import saves people's details and relationships. You send invitations to the app separately from each person's card.

What if some details need correcting?

Check the row messages and import report. Download the file of people who were not imported, correct their details and upload it again. People already saved remain in the team.

Will import transfer match and payment history?

No. This importer brings people's details into a team. It does not import match, attendance or payment history, or connect directly to other systems.

Bring over your squad. Focus on your team.

Start with the spreadsheet you already have. Try player import in TrainTeam.

  • No card required
  • One team free
  • Works on phone and desktop