Troubleshooting Schedule Imports

Fix It

Use the Right Template

There are two schedule import templates available for the Club & League TeamSnap app. If you are importing games and events for more than one team, you will want to import under the organization Schedule tab and use the Import Schedule for Sports Organizations guide and template. If you are importing schedules to a single team at the team level, you will want to import under the team Schedule tab and use the Import a Team Schedule Guide and Template. These templates are not interchangeable, and must be in a CSV format to import.

Warning: It is very difficult to maintain a Full Organization Schedule View with a team-level schedule import. Team schedule imports can generate opponents and team-controlled locations, and also can not be reversed.

Check Your Headings

Your headings should be exactly the same as in the CSV template. Your import tool can not read approximate headings, so any change in the order or phrasing of your column headings can result in an import error. For best results, start with a clean template and plug in your information. Schedule imports can not be customized with added columns. Only the columns in the templates are supported.

Separate Games and Events

Your Games and your Events should be imported as separate files. When importing Events, delete the 'Away Team' column, and only include the 'Home Team' column for that file.

Before You Import Your Organization Schedule

Your organization schedule import can generate games and events for all teams across your organization! It can not generate teams, divisions, opponents, or locations. Before you import, make sure to check that you have done the following:

All divisions/teams have been set up
Any outside (non-league) opponents have been entered - To do this go to each team’s schedule tab and click on the Edit Opponents button. If no games have been entered on the team’s schedule yet, click on the Schedule Your First Game button, then on Edit Opponents. When importing events that do not have an opponent (e.g. practices), just leave the Away Team column blank.
All locations have been entered in the league level schedule tab

Review for Typos and Formatting Requirements

The most common cause for an import error is the dreaded typo. Be exact! Imports are sensitive, even to spaces and punctuation.

Team names, outside (non-league) opponent names, and location names in the import file match exactly to how they are spelled in TeamSnap and they are case sensitive. If your team name is listed as PANTHERS in TeamSnap if you enter the team name as Panthers on the import, it won't find a match.
Any blank rows or columns have been deleted
There are no spaces before/after and of the data in each cell
Formatting requirements: Date: MM/DD/YYYY (Unless you change your organization Settings > Site Prefs to Use international dates (DD/MM/YYYY)), Start/End Time: HH:MM AM/PM
Arrival Time: Minutes prior to start time (for example, 30)

Tip: At this time, schedule imports can have trouble with symbols such as % , @ , # , * etc.

Include Required Information

The following organization template columns can be deleted, if you do not need them. All other columns are required.

End Time
Away Team (For event import files only.)
Event Type
Location Details
Arrival Time
Short Label

If you are running into any issues, the first thing you can do is double check that the device you are attempting to access TeamSnap on meets our system requirements.