Skip to main content

How to import assignments with a game spreadsheet

Place up to five officials on each imported game, then decide what to do when someone is not available or an official's name does not match.

New Horizon Experience. This article describes the New Horizon Experience. You can follow these steps on a computer or in the Horizon WebRef mobile apps for Android and iOS.

Watch the walkthrough first if you want to see the whole path, then use the steps below as you work. You can follow the video on a computer or in the Horizon WebRef apps.

This article is for officiating managers, schedulers, and organization administrators who already know how to import games from a spreadsheet and now want Horizon to place people from official-name and position columns in the same file. Officials who only work games cannot import, and neither can coaches, athletic directors, League Personnel, or location personnel.

Importing assignments with games is an advanced path, not the everyday way most organizations assign. The regular assign tools still apply availability, eligibility, and conflict checks while you pick people. Use this walk-through when you already have officials' names in the file and you are ready to review every placement before you import.

If the page still says Schedule Mass Import and asks you to choose a CSV file, you are on the older legacy layout. Skip ahead to If you still see the older legacy desktop or laptop layout at the end of this article.


What changed

On the old legacy import page, named officials were treated as a complete override. Horizon did not check availability, eligibility, or conflicts. That is no longer true on the New Horizon Experience. On the old legacy page, it is still a complete override, and the older layout section at the end explains that path.

The Officials step now checks each named person for available, eligible, a matching position, and a time that does not overlap another row in this file. Horizon still will not invent a person who is not in the organization. You decide whether to skip that assignment, fix the file, or import anyway as an override.


Set the name order

On Import type, leave Add new games selected unless you are updating a downloaded list. Under Names in the file, choose how the officials' names are written: Last name, first name or First name, last name. That control is about people's names, not team names or location names. Choose No names (recommended) only when the file has no official names or positions. If the file has officials' names and you leave No names selected, Horizon warns that those assignments will not be imported.

If you choose a name order but the file has no row with both an official's name and a position, Horizon stops and asks you to go back to No names or add an official's name and a position to at least one row.

Import type on a phone. Names in the file offers No names, Last name, first name, and First name, last name.

Name and position columns

You can import up to five assignments per game. Each assignment is a pair: the official's name in one column and the assigned position in the next (Official 1 with Position 1, through Official 5 with Position 5). Those Official columns hold people's names. They are not the same as Home Team and Away Team, which hold team names. Download the template so the headers match what Horizon expects.

Write officials' names in the order you selected. Extra spaces in an official's name are shown as a middle dot on Fix this, which is how you can see why a cell looks right but still warned. Horizon matches after cleaning those spaces.

If the two cells look reversed, Horizon can swap them and tell you it used one value as the name and the other as the position. The same position twice on one game is allowed. More officials than the game needs is a warning, not a block, and Horizon still imports that assignment.


The Officials step

After you confirm the game facts, Horizon opens the Officials step when the file includes names and you chose a name order. The coach line tells you to check each named official for available, eligible, a matching position, and a time that does not overlap another row in this file.

Officials step on a phone. Skip all and Override all sit above All, Needs a fix, Warnings, and Ready counts.

Skip all assignment issues leaves those people off the games, and the games still import. Override all assignment issues marks those placements as overrides, for example when someone is unavailable or ineligible. Use override only when you have reviewed the list and you still want those people on the games.

Select a row to open Fix this for that assignment. You will see Your file (official's name and position as written), Horizon checked (not found, extra spaces, not available, not eligible, overlapping time, or a position that does not exist for that game code), Closest matches when an official's name or position is close, and Do this next.

Fix this on a phone for a position that was not found. Skip this assignment sits under Do this next.

Skip this assignment leaves that person off the game, and the game still imports. A short confirmation says the assignment will be skipped. Assign this person puts them back if you change your mind. Import cannot continue while an unskipped match error remains, such as an unknown official's name or unknown position with matching set to Show an error.

Import anyway is the override for someone who is not available or not eligible. Horizon will still create the game and place that person, and it marks the assignment as an override. Do not use this as a shortcut around an official's name that was not found.

Named official matching can also be set to Skip that assignment under Change matching. That fallback skips a missing person automatically instead of showing an error, and the game still imports.


After you import

Results still show Created, Updated, and Assignments skipped. Skipped means those people were left off. The games themselves were imported unless a game row still needed a fix.

Results on a phone after import, with Created, Updated, and Assignments skipped counts.

If you are updating existing games, imported assignments replace what was on those rows, and officials who lose a published assignment are emailed. For everyday assigning after the games exist, use the regular assign tools so Horizon can keep applying its eligibility and conflict checks while you work.


If you still see the older legacy desktop or laptop layout

On the old legacy import page, placing officials' names from the file is a complete override. Horizon does not check availability, eligibility, conflicts, or the other assign rules. It places the people you listed if it can match the official's name exactly, so you must check those assignments yourself after import.

Under Name Format, choose Lastname, Firstname or Firstname, Lastname. Name Format is about people's names, not team names. You can still import up to five official-name-and-position pairs per game, and you must keep the old legacy template column order. If an official's name cannot be matched, legacy import either imports the game without that person (YES - Import the Game Anyways) or shows an error and skips that game.

Use the New Horizon Experience Officials step when you can, so Horizon can check available, eligible, position, and overlapping times before anything is saved. If you stay on the old legacy page, import the games with No Names and assign afterward with the regular assign tools.

Did this answer your question?