How to Import Games from a Spreadsheet in Horizon WebRef

Learn how to import games from a spreadsheet onto the Master Game Schedule in Horizon WebRef. This walkthrough is for officiating managers and schedulers who have a season file ready, or a downloaded list that needs an update, and want to confirm what blocks, what warns, and what will be added before anything is saved.

Chapters

1. 00:00 How to import games from a spreadsheet
2. 00:13 Who can import
3. 00:30 Add, then Import from spreadsheet
4. 00:42 Download template
5. 01:27 Open the file in Excel
6. 01:39 Example rows and team names
7. 02:08 Place your games
8. 02:20 Headers and save formats
9. 02:37 Dates, times, and record names
10. 03:15 Officials names in the Official columns
11. 03:30 Save As
12. 03:42 Import type
13. 03:56 Names in the file
14. 04:15 Change matching
15. 04:37 Spreadsheet file
16. 04:48 Games
17. 05:06 Fix this
18. 05:26 How we read this file
19. 05:40 Cancel import and Skip this assignment
20. 05:53 Officials
21. 06:08 Import and Results
22. 06:20 Same work on a phone
23. 06:44 That is how Import from Spreadsheet works
24. 06:57 Explore the Live Demo

Read the Help Center article

• How to import games from a spreadsheet Opens in a new window
• How to import assignments with a game spreadsheet Opens in a new window

Explore the Live Demo All how-to videos