Import a USTA schedule, roster, or match result

Download the XLS file from TennisLink

Start at tennislink.usta.com and open USTA League, then Stats & Standings. Find your team and open its team page.

For a schedule, open Match Schedule and use Send to Excel to download the Match Schedule by Flight XLS file.
For a roster, open Roster and use Send to Excel to download the Player Roster by Team XLS file.
For a completed match result, open the match scorecard and use Send to Excel to download the Scorecard XLS file.
Keep the downloaded file in XLS format. Do not copy the rows into a new spreadsheet or rename it as CSV.

USTA TennisLink team page with Send to Excel in the upper-right corner — On the relevant TennisLink roster, schedule, or scorecard page, select Send to Excel.Captured from USTA TennisLink

Helpful tip

Download each type separately. CourtRoster expects the specific TennisLink export named in its upload dialog.

Import a match schedule

In CourtRoster, select your team and then Matches.
Select Import schedule and upload the Match Schedule by Flight XLS file.
Select Analyze schedule, choose your team from the export, and select an existing season or create a new one.
Confirm the match format and schedule time zone, then review the matches that will be added.
Select Import into season, or Create season & import when you chose a new season.

Helpful tip

Existing matches with the same USTA Match ID are skipped, which helps prevent duplicates.

Import a roster

In CourtRoster, select your team and then Roster.
Select Import from USTA and upload the Player Roster by Team XLS file.
Select Analyze roster, then review every player. Link an existing CourtRoster account, add a new player, or skip the row.
For a new player, confirm their name, email address, and city. Choose whether CourtRoster should send invitations after the import.
Review the changes and select Import roster.

Before you continue

Review suggested account matches carefully so a USTA player is not linked to the wrong CourtRoster user.

Import a completed match result

In CourtRoster, select your team, open Matches, and select the match whose result you want to import.
Select Import Result and upload the Scorecard XLS file from that completed TennisLink match.
Select Analyze scorecard, identify which side is your team, and match the scorecard players to your CourtRoster roster.
Review the courts, players, scores, and result, then select Import scorecard.

Before you continue

Importing a scorecard marks the match complete and updates its score, opponent, lineup slots, and player result history. Review the final step before importing.

Keep going

Related guides

Add matches

Schedule an opponent, venue, match format, and one or more start times.

Add players to a roster

Search for an existing player, link an account, or create a roster spot and send a claim invite.

Create and send a recap

Complete a match, record court results, publish the recap, and send it to the roster.

Download the XLS file from TennisLink

Start at tennislink.usta.com and open USTA League, then Stats & Standings. Find your team and open its team page.

For a schedule, open Match Schedule and use Send to Excel to download the Match Schedule by Flight XLS file.
For a roster, open Roster and use Send to Excel to download the Player Roster by Team XLS file.
For a completed match result, open the match scorecard and use Send to Excel to download the Scorecard XLS file.
Keep the downloaded file in XLS format. Do not copy the rows into a new spreadsheet or rename it as CSV.

Helpful tip

Download each type separately. CourtRoster expects the specific TennisLink export named in its upload dialog.

Import a match schedule

In CourtRoster, select your team and then Matches.
Select Import schedule and upload the Match Schedule by Flight XLS file.
Select Analyze schedule, choose your team from the export, and select an existing season or create a new one.
Confirm the match format and schedule time zone, then review the matches that will be added.
Select Import into season, or Create season & import when you chose a new season.

Helpful tip

Existing matches with the same USTA Match ID are skipped, which helps prevent duplicates.

Import a roster

In CourtRoster, select your team and then Roster.
Select Import from USTA and upload the Player Roster by Team XLS file.
Select Analyze roster, then review every player. Link an existing CourtRoster account, add a new player, or skip the row.
For a new player, confirm their name, email address, and city. Choose whether CourtRoster should send invitations after the import.
Review the changes and select Import roster.

Before you continue

Review suggested account matches carefully so a USTA player is not linked to the wrong CourtRoster user.

Import a completed match result

In CourtRoster, select your team, open Matches, and select the match whose result you want to import.
Select Import Result and upload the Scorecard XLS file from that completed TennisLink match.
Select Analyze scorecard, identify which side is your team, and match the scorecard players to your CourtRoster roster.
Review the courts, players, scores, and result, then select Import scorecard.

Before you continue

Importing a scorecard marks the match complete and updates its score, opponent, lineup slots, and player result history. Review the final step before importing.

Keep going

Related guides

Add matches

Schedule an opponent, venue, match format, and one or more start times.

Add players to a roster

Search for an existing player, link an account, or create a roster spot and send a claim invite.

Create and send a recap

Complete a match, record court results, publish the recap, and send it to the roster.