League Bulk Schedule Import

If you need to add many games simultaneously, you may want to upload a .CSV schedule via our Staff Web Portal to get games added more quickly. The Bulk Schedule Import tool can be accessed from an existing Organization on http://web.gc.com.

What is Required‍

1. All teams included in the schedule must already be included into the Organization.

As an organization admin you may create the teams yourself from scratch and invite the coaches to take control of them or you may invite an existing team that has already been created in GameChanger. Either way, in order to schedule against a team it must be active and joined to the organization. The Bulk Schedule Importer tool will also allow you to download a list of teams that have joined the Organization to make this process a little easier if you are constructing the schedule yourself from scratch.

2. The ability to edit the .CSV template to upload into the GameChanger site

Once you have downloaded the formatted .CSV template, you will have to edit it to match your organization's schedule. An application that can work with spreadsheets will be required to do this:

• Microsoft Excel and Apple Numbers allow the editing of the .CSV template we will provide which can then be saved as a .CSV file to be imported.
  
  
• Free web-based tools like Google Sheets make the importing of a .CSV spreadsheet easy as well. Once completed, you can then export the .CSV to your computer for importing.

3. You must be an Org Admin to import the organization's head-to-head schedule

The user must be the Organization Admin to import all of the head-to-head games into the system. Coaches are able to access their Team Events that are created automatically from the creation of head-to-head games but they are unable to create the head-to-head game itself.

‍
How does the Bulk Importer Tool work?

1. Go to your GC Web Portal and select the organization that you are the administrator for. 
   
   NOTE: If you have not created an organization yet, you can learn how to create one here.
   ‍
2. From the Organization schedule page select the Add Games dropdown and select Import Teams' Schedule from Spreadsheet:
3. 
4. Download the .CSV Template and your organization's custom Team List to get started:
5. 
6. Select your completed .CSV from your files and import it to be analyzed for errors.
   ‍
7. Correct any errors in your .CSV file that the import validation tool finds:
8. 
9. Once successful click the Import Schedules button to create all of the head-to-head games in your Organization.
10. 

Notes: 

• If you need to schedule placeholder events due to uncertain schedule details, you can learn how here.
• If you need assistance with exporting a schedule from Sports Connect and formatting that file for import, you can learn how here.