Importing Games via Spreadsheet

Recommended Steps

  1. Download Template File
  2. Remove Sample Data from Template File
  3. Copy & Paste your game data into the template file
  4. Save the file & import

How Imports Work

Importing games via a CSV spreadsheet file can be done via the import options provided in the system.  You may import up to 10,000 games in one spreadsheet.  The larger your file, the longer it will take.  This option is only available for administrators and assignors/schedulers on the system and is not available for coaches, athletic directors, general members or any other user types.  To access the import page, you would go to Master Game Schedule >> Add Games (top left) >> Import from Spreadsheet.

All imported files must follow our import template format which is available for download on the import page. Files must be saved as a CSV (comma separated values) file which is a simplified version of an Excel spreadsheet.  The order and format of your columns will vary, depending on the setup options you have chosen in your System Settings so be sure to start with our template file so you know the column and ordering structure of the import.  It is important to note that if you change your System Settings, your template format may change too.  We recommend you download a new template file after making any changes to your System Settings.

You can download a template file on the import page in the top right corner using the Download Template File option.  The section will also describe to you which columns are required and which are optional, again, based on your System Settings.

Selecting Import Options

The following options can be selected during the import process.
  • Import Type

    Add New Games
    This indicates that you are trying to add new games to the system.  Any entries in your spreadsheet will be added to the system as a brand new event.

    Update Existing Games
    This indicates that you will be providing an edited spreadsheet to update existing games.  Edited spreadsheets must contain the system game ID number.  Generally, you cannot self-generate spreadsheets for this process and you should be starting with a downloaded spreadsheet of your existing games.  See the mass-edit instructions guide for details and instructions.

  • Name Format
    This indicates whether or not you want to import assignments with your games.  In most cases, you'll select "No Names".  We do not recommend importing assignments with games as it is treated as a system override.  You can see this article for more details.

  • Matching Settings
    The larger section of settings on the import represents how the system should match and identify your content.  These sections begin with "If we cannot match the _________, what should the system do?"  When reading the content of your spreadsheet, the system will search through your subscription to identify entries that match the content of your spreadsheet.  The system will perform these searches in the following order:

    1.  Search for an exact match:  The system will search for an exact match to the term you entered
    2.  Search for a partial match:  If step 1 is unsuccessful, the system will proceed with trying to locate a partial match
    3.  Perform the setting you specify:  If both step 1 and step 2 are unsuccessful, then this is where your selected setting comes into play.  You can instruct the system how to proceed a this point.  We recommend leaving the default as "Show error message", but advanced and experienced users can feel free to adjust these settings as desired.

Import Tips & Restrictions

  • Up to 10,000 games are permitted per file, however, we recommend importing smaller batches for better system performance.
  • Game dates may be no older than the start of your "Current Season" and no later than 2 years in the future from whatever today's current date is.
  • Date format will follow your System Settings format which is either mm/dd/yyyy or dd-mm-yyyy, the key formatting difference being slashes vs. hyphens
    The format mm-dd-yyyy is not accepted. If you want month-day-year formatting, you must use the mm/dd/yyyy format option with slashes, not hyphens.
    The format dd/mm/yyyyy is not accepted. If you want day-month-year formatting, you must use the dd-mm-yyyy format option with hyphens, not slashes.
  • Time format may be 12 or 24 hours, both are accepted.
  • Be sure to carefully read the Preview Page.  It's much easier to cancel an import to fix problems than it is to try to fix problems after completing the import.
  • We don't recommend importing assignments with your games, but if you're considering this, please see this support article.

Help for Schedulers

  1. User Permissions Explained
  2. Importing Games via Spreadsheet
  3. How do I increase the number of maximum licenses?
  4. Why isn't an official showing as available?
  5. Mass Edit & Update Game Information in Bulk
  6. Cancel Games in Bulk
  7. How do I add/confirm an official AFTER a game has been completed?
  8. When are officials no longer available for more assignments on the same day?
  9. How do I add officials to my system if they don't use the internet?
  10. How can I edit my System Settings?
  11. If the user doesn't their receive initial welcome email, is there a way to resend?
  12. How to reschedule a cancelled game
  13. Is it possible to have 2+ individuals set up with administrator permissions?
  14. What are Teams?
  15. What are Locations?
  16. What are Leagues?
  17. What are Game Codes?
  18. What are Official Positions?
  19. Diagram of leagues, game codes and positions...
  20. Is there a way as a scheduler that I can mark a game as "accepted" for an official?
  21. How do I remove an official from my organization?
  22. How do I see who is available when assigning games?
  23. How do I turn on mileage calculation to be shown when assigning games?
  24. How do I change the default game start time?
  25. Is there any way to restrict what games an official can be assigned to based on the official's age?
  26. If an organization has more than one assignor who receives the Declines or Turnback notificiations?
  27. Can I force officials to accept games within a few days?
  28. How I can add our organization logo?
  29. Where do I go to make the renewal payment for my organization?
  30. Is it possible to export to excel a list of mileage for each official by location?
  31. Is there a way I can identify that two officials can't be assigned to work on the same game together?
  32. Where do I get an invoice and be able to print it out as well?
  33. How can a supervisor view all assignments?
  34. Can you export an invoice into an excel spreadsheet?
  35. How do I change the "current season" ?
  36. Is there a way to tell me how far a location is from an officials home?
  37. Who is able to send "Message from the Administrator"?
  38. Is there a way to run a report of number of turnbacks?
  39. Why do I see "no positions created yet"?
  40. How can I rank officials according to seniority?
  41. Can I reset the game counters?
  42. How can I add someone into my organization who already has an account from another organization?
  43. Can assigner accept games for the official?
  44. Can I access usernames and passwords for our member officials?
  45. "No positions created yet"
  46. How do I uncancel a game?
  47. Can a user be both an official and a coach?
  48. How do I input incidental expenses, travel and meal allowance?
  49. Erase / Remove users from your system.
  50. How long will my game info be retained in the system?
  51. Who receives Game Day email notifications?
  52. How do I change the default schedule filter?
  53. What email reminders are sent and when?
  54. What does the activation reminder email look like?
  55. How do I add users?
  56. What is the TBA System?
  57. 2018 Dwolla Pricing Changes
  58. Importing Assignments
  59. How do I make a cancelled game billable (or payable)?
  60. Saving an Excel spreadsheet (.xls or .xlsx) as a CSV file
  61. Restricting Game Levels to members of Contact Groups
  62. How to setup experience-based pay structures
  63. Can officials just self assign themselves and choose their own games?
  64. Extended Archiving Add-On
  65. How do I purchase a subscription?
  66. How to cancel individual games
  67. How to handle rain outs
  68. Email is undeliverable for registration
  69. How do I add another administrator?
  70. Evaluation & Ratings Systems
  71. How does Auto-Assign work?
  72. Available Add-On Services
  73. Getting Started with Sports Engine Integration
  74. Setting Up Sports Engine Integration
  75. Are cancelled games deleted from the system?

Feedback and Knowledge Base