In the following article we cover the following…
Manually typing or cutting/pasting game info. into your schedule? Fugetaboutit. Now you can upload a file (.XLS, .XLSX or .CSV), map the game details to TeamSnap schedule fields, and boom!! Instant schedule. Get started with a Schedule template here!
Take a look at a typical game below to see what type of information is saved on the TeamSnap Schedule. For each game, you can save date, time, opponent, location, and location details. You can also save additional information like opponent contact, location address, away or home, uniform, duration, and arrival time (see the schedule template for a complete list).
What type of files can I import?
You can upload .XLS, .XLSX, or .CSV file formats.
Here’s an example of a file that you might want to import. The first line of your file will be read as column headings. In order to import information about new games, the columns in your file should roughly match the fields in the schedule. The example below includes the date, time, home or away, opponent name, and location name. Please note, the Date format needs to be mm/dd/yyyy. The date format needs to be mm/dd/yyyy on this import and also under Team Settings. You can switch back to INTL as soon as the import is complete.
You may not want to import all of the information in your spreadsheet, so the import feature lets you select which columns to import.
To import this file, login to TeamSnap and select the schedule tab for your team. Then select “Import Schedule.”
To import, click “Choose a File.”
Then select the file to import from your directory and click “Open.”
For each column of data, select the corresponding TeamSnap Column Name from the pull down headers. 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.
It’s okay. Mistakes are a part of life, young padawan. In this example, the system noticed that some of the dates were not entered in the correct format. To edit the information, just select the field, and make the change.
If you don’t have the correct information, the system will not import incorrect field and leave it blank, and you can go back later to add any missing or incorrect data directly to the schedule.
Once you finish editing your game data, select save schedule. To view the updated data, simply click on a game in the Schedule tab.
Once you review the schedule, you might realize that you imported the wrong data. You have two options for correcting information:
- If you have just a few changes, you can select each game and edit the data for each one OR
- If you have quite a few changes, you can delete the games from your schedule, make the changes in your original file, and import the file again.
For additional help, check out this video — coming soon to a theatre near you!
Often you may not have all the details for an upcoming game but you need to get it on the schedule as a placeholder. Since Location is a required field, you can just enter TBD in your original file or on the file upload screen (see below). You can also use TBD for Opponents and Time.
Can I import an event or practice?
To add Practices or Events to the schedule, simply omit the Opponent. When the data is imported, it will be saved as an Event and labeled as a ‘Practice’. You can then go in and change the Event Name or any other details. If you do not know the specific time, you can also enter TBD and add it later.
Did you know coaches and parents can sync Team Schedules directly to their personal calendars? Check out this page.