Import Schedule for Standalone Teams

Manually typing or cutting and pasting game info into your schedule every season? Fugeddahboudit! Now you can upload a CSV file, map the details to TeamSnap schedule fields, and bada-bing bada-boom!

You can use our CSV team schedule import template or create your own CSV file to import. If you use your own file, make sure your column headings match the system data mapping 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

Prepare to Import

 

 

The first row of your file will be read by the system as column headings for mapping the imported information to the correct fields. In order to import information about new games, the columns in your file should roughly match the fields in the schedule.

Formatting requirements:

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: :MM Minutes prior to start time

 

 

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.

To specify between practices or game events in your import file, simply omit the Opponent for practices. When the data is imported, it will be saved as an event and labeled as a practice if there is no opponent specified, or a game if there is data in the opponent field.

Import the 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 TeamSnap 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
  9. The imported schedule will be available to view under the Schedule tab in TeamSnap

What Happens Next

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.