Importing schedules from a file
Manually typing out or copy+pasting game info into your schedule every season? Fugeddahboudit! Instead, you can upload a CSV file of your schedule, map the details to TeamSnap schedule fields, and bada-bing bada-boom, schedule made!
In this article
Attention: CSV files are the only accepted file types for importing organization-level schedules. If you are importing an organization schedule using a custom file in Excel (.xls) format, you’ll need to save/export it as a CSV file before proceeding.
Import division or full organization schedule
If you are an administrator for an account using TeamSnap for Clubs and Leagues, then we recommend downloading the organization schedule import template and plugging in your information for best results.
Download Org Schedule Import Template
*This template will not work for team-level imports.
Importing Prerequisites
✔ Set up all divisions and/or teams in TeamSnap
✔ Add any external (non-league) opponents
✔ Add locations in the organization-level Schedule tab
✔ Make sure all team names, external (non-league) opponent names, and location names in the import file match exactly to how they are spelled in TeamSnap (case-sensitive)
✔ Remove any blank rows, columns, and extra blank spaces before or after any of the data in each cell in your import file
Formatting Requirements
The first row of your file will be read by the system as column headings for mapping the imported information to the correct fields. If you prefer to use your own custom file, ensure that your column headings match the fields in the schedule in order to correctly import schedule information.
- Date: MM/DD/YYYY
- Ensure date format is also set to this format under Team Settings in the Manager tab.
- Teams using international date format must switch to the MM/DD/YYYY format before importing to avoid errors and can switch back after the import is complete.
- Start/End Time: HH:MM AM/PM
- Arrival Time: # of minutes prior to start time (for example, 30)
View division and org schedule import column headings
Required columns: These columns should not be deleted or your import will fail.
- Date
- Start Time
- Division
- Home Team
- Location
Optional columns: These columns can be deleted from your import file if they are not needed.
- End Time
- Arrival Time
- Short Label
- Event Type
- Away Team (For event import files only.)
Importing a Division or Org Schedule File
- Click the Schedule tab
- Click the Schedule Imports button
- Click on the Upload Schedule from File button
- Click Choose File and select your CSV schedule file on your computer
- Decide if you want league-controlled or team-controlled events:
- League-controlled (box unchecked): League-controlled games and events are visible to participating teams, but game results can only be entered at the team-level when allowed under the organization Settings Tab.
- Team-controlled (box checked): Sports org admins and team admins will be able to edit games/events and enter game results, games and events will be displayed in org, division, and team schedule tabs, but can only be edited at the team level. Changes made within a team to an event where the opposing team is in the same league will only be reflected in the team where the change was made.
- Click Continue
- Click on the Create All Events button
To check on the status of your import, go back to the schedule imports list. The status column will indicate whether the import/event creation was successful or not.
Getting stuck? Check out Troubleshooting Schedule Import Issues.
Import team schedules
Need to import a schedule directly to a specific team? If you are an independent team owner or manager, or an organization administrator needing to import the schedule team-by-team, you can use our team schedule import template below, or create your own CSV file to import.
Download Team Schedule Import Template
*This template will not work for division or organization-level imports.
Formatting Requirements
The first row of your file will be read by the system as column headings for mapping the imported information to the correct fields. If using your own custom CSV file, the columns in your file should match the fields in the schedule in order to correctly import schedule information.
- Date: MM/DD/YYYY
- Ensure date format is set this way under Team Settings in the Manager tab
- For teams using international date format, switch to the MM/DD/YYYY format before importing and then switch back after the import is complete
- Start/End Time: HH:MM AM/PM
- Arrival Time: Minutes prior to start time (for example, 30)
- TBD: If you do not have all the details for an upcoming game but need to get it on the schedule as a placeholder, you can enter TBD for the required fields Location, Opponents, and Time.
- Game vs Event: To specify between practices or game events in your team import file, simply omit the Opponent for practices. If there is no opponent specified when the data is imported, it will be saved as an event and labeled as a practice. If there is data in the opponent field, it will be saved as a game. Only events are 'named' via the Name column. Games will be represented as either "at opponent name" or "vs. opponent name" on your schedule.
Click to view team schedule column headings
- Date
- Time
- Name
- Opponent Name
- Opponent Contact Name
- Opponent Contact Phone Number
- Opponent Contact E-mail Address
- Location Name
- Location Address
- Location URL
- Location Details
- Home or Away
- Uniform
- Duration (HH:MM)
- Arrival Time (Minutes)
- Extra Label
- Notes
Importing a Team Schedule File
- Click the Schedule tab
- Click the Import > Schedule from File button
- Click Choose File
- Select the file to import from your computer and click Open
- Map the data to the appropriate fields
- Select the corresponding column name from the drop-down for each column. If you don’t want to import a column, or there is no match, select No Match. We’ll import only the data that has a matching column name. Scout’s honor.
- Select the corresponding column name from the drop-down for each column. If you don’t want to import a column, or there is no match, select No Match. We’ll import only the data that has a matching column name. Scout’s honor.
- Fix any import errors
- Select the appropriate field mapping in the drop-down for mislabeled column headers. You can edit field data for the import by clicking directly into the field to update the information.
- If you don’t correct identified errors the system will not import those fields and they will be left blank when added to TeamSnap. Missing or incorrect data can be added directly to the schedule once it is loaded into TeamSnap.
- When ready you can check/uncheck the box to notify roster members of the schedule updates
- When ready, click Save Schedule to have the system complete the import process
The imported schedule will be available to view under the Schedule tab in TeamSnap. Review the published schedule in TeamSnap to double check for any incorrect schedule data.
If you realize that incorrect data was imported, you have two options for correcting the information:
- For minimal changes, you can open the event details in TeamSnap and edit the data for an individual event as needed.
- For more widespread changes, you can delete the games from your schedule, update the import file, and import the file again.
Common Questions
What's the difference between a game and an event?
The schedule items can be created as either games or events. It is important to create the correct schedule item type because once created, they cannot be switched. Any changes would have to be made by deleting and recreating the required schedule item.
Games: Schedule items where your team competes against an opponent and there is a scored result. This schedule item type includes fields for games including Opponent, Home or Away, Uniform, Enter Results, etc.
Events: Schedule items which can be anything on the schedule that is not a game and does not need results entered including practices, meetings, and parties. This schedule item type includes fields for events including Daily Repeating Events, Weekly Repeating Events, Short Label field, etc.
To distinguish between a game or event, administrators can view the edit screen for the schedule item. The edit screen will be labeled Edit Game or Edit Event.