Help System Search

Importing a Spreadsheet

 

Use the Schedule Import feature to instantly publish your enitre season schedule so that it's live on your site. Once live, you can esily edit the Scores, Stats, Standings or make Scheudle changes as needed.

 

Preparing Your Spreadsheet (Video)

Preparing Your Spreadsheet: Compatible Formats
  • XLSX (Excel),
  • XLS (Excel 97-2003),
  • CSV (comma delimited),
  • TXT (tab delimited)
Preparing Your Spreadsheet: Date & Time Format

Start and/or end times should include AM or PM.

For example, in this date, it's impossible to determine AM or PM:

10/16/17 8:30

 

The correct format is:

10/16/17 8:30 AM

Preparing Your Spreadsheet: Column Headings

The system will need column headings set so that it understands where to put the information you're importing. Set column headings such as:

 

Date|Time|Home Team (or Practice description)|Away Team|Location|Game Type (Game/Practice)

 

Your prepared spreadsheet should look similar to this sample:

 

 

Multi-Team Website Tip:Save time by making sure that the team names in your spreadsheet match the team names in your multi-team website.
 

Contact Support to include up to 50 characters to the Game Preview in your import.

Preparing Your Spreadsheet: Home vs. Away

In order to add a Game, two teams must be listed with one team being a part of your structure.

 

Set one column as Home and another column as Away and list the teams for the game in the appropriate column. If one of the teams is not a part of your structure, they will be identified as a "non-league team" during the import process.

Importing Your Schedule (Video Above)

Once you've prepared your spreadsheet for import, multi-team sites will start with the Select the type of Import dropdown. If you're importing a Schedule for more than one team in your multi-team website, choose Multiple Teams (League).  If you're importing for only one team in your organization, choose the single team from the dropdown.

 

Click import my data. Copy the data from your spreadsheet and paste it into the large white field. It's totally fine if it looks strange - click Submit Pasted Text to move on.

 

From here, the system will compare the data from your spreadsheet to the data within your website. If it is not sure about any of the data you've submitted, you'll receive an error message & will not be able to move on until you tell the system what the data is or select to ignore the data completely. Ignored data is skipped & will not be added through the import.

 

Once you've matched all of the data, you will move on to reviewing the teams, game types, & locations. In each step, you may need to identify or ignore data before going to the Final Review.

Tips & Notes
  • If you are importing an excel workbook, only the first tab will be imported.
  • Schedules will be imported into the current season. Contact Support if you'd like to import into a different season.
  • Up to 30 teams &/or locations can be added via the import.

Tips & Notes for Multi-Team Sites

  • Important: In a League or Multi-Sport Organization, Schedule Imports can only be done by Roles based from the Main HQ. Team-level Roles cannot Import Schedules.
  • If your multi-team site is divided up into groups or divisions, it may be easier to go to Teams & Schedules > Teams & Packages to setup your groups and teams before importing. Alternately, you can do your import in smaller chunks.
  • To avoid confusion in both the import process as well as to visitors to your website, we strongly recommend that each team in your structure have a unique name. If you have different age groups that feature the same team names, use the age group as part of the name. For example:

Troubleshooting
  • If you receive a "data limit exceeded" error, contact Support. We will be happy to review your data and help you with the import process. 

 

Toll-free Support Hotline

(800) 486-0505
Weekdays 9:00 AM - 4:00 PM (EST)
Phone support not available on federal holidays.

Email Support

HomeTeamsONLINE continues to expand and improve its features thanks to the feedback and comments from our users. Please let us know if you have any questions or suggestions.

Email Contact Form