Import Schedules

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. If you are using a custom file in Excel (.xls) format, you’ll need to save/export it as a CSV file before proceeding. 

Schedule Import for Teams

Who can do this:
  • Roster Members
  • Team Managers
  • Team Owners
  • Commissioners
  • Organization Owners
Where to do this:
  • web app icon
  • mobile app icon

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.

*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

How to Import the Team Schedule File

  1. Click the Schedule tab
  2. Click the Import > Schedule from File button
  3. Click Choose File
  4. Select the file to import from your computer and click Open
  5. 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.
  6. 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.

  7. When ready you can check/uncheck the box to notify roster members of the schedule updates
  8. 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:

  1. For minimal changes, you can open the event details screen within TeamSnap and edit the data as needed
  2. For more widespread changes you can delete the games from your schedule, update the import file, and import the file again.

Schedule Import for Divisions or Full Organization

Who can do this:
  • Roster Members
  • Team Managers
  • Team Owners
  • Commissioners
  • Organization Owners
Where to do this:
  • web app icon
  • mobile app icon

 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.  

Things to do before importing:

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, outside (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

*This template will not work for team-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 you prefer to use your own custom file, just 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 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)
Click to view division and org schedule column headings

Required columns: These columns should not be deleted or your import will fail.

  • Date
  • Start Time
  • Home Team
  • Location
  • Division

Optional columns: These columns can be deleted from your import file if they are not needed.

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

How to Import the Division or Org Schedule File

  1. Click the Schedule tab
  2. Click the Schedule Imports button
  3. Click on the Upload Schedule from File button 
    schedule-import.png
  4. Click Choose File and select your CSV schedule file on your computer
  5. 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.

  6. Click Continue
  7. Click on the Create All Events button
    To check on the status of your import, go back to the schedule imports list. This will indicate whether the import was successful or not.
    • If successful, it will show the events were created.
    • If not, it will display an error status:

    • If you receive an error you'll need to correct the import file data, then re-upload your file. Please keep in mind that importing a file you have previously imported and created events from will not overwrite existing import data.

Getting stuck? Check out Troubleshooting Schedule Import Issues.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.