How Tournament Spreadsheet Imports Work

How Tournament Spreadsheet Imports Work

Before You Begin

Make sure to have an adequate understanding of the Gallus Tournament Software by reading our Tournament Software Basics article.

What's The Point?

When creating an Event through the Gallus admin dashboard, many organizers want a simple and intuitive way to get all of the information about their event into the software quickly. The Spreadsheet Import functionality provides a familiar way to collect information in an Excel spreadsheet and import it into the Gallus Tournament Software once for a seamless setup experience. Read on for detailed instructions on how to use this handy feature.

Steps To Complete

  1. Log into the Gallus Admin Dashboard.
  2. Click Tournaments.

  3. Select the event you'd like to upload a spreadsheet for.

  4. On the main tournament checklist page, click click here to import via spreadsheet template.

  5. On the ensuing page, click Download Template to download an Excel spreadsheet directly to your computer.

  6. Open the file in Excel (or Google Sheets) and fill out the information in the same format as provided.
    1. See the section below for detailed instructions on setting up start holes for shotgun-style events.
  7. Once finished and saved in your spreadsheet editor of choice, go back to the spreadsheet upload page in the tournament software, click Choose File, and select it.

  8. Click Import.

  9. DONE! All of the information within the spreadsheet should now be viewable within the event.

Setting Up Start Hole For Courses Using 9-Hole Group Names & Hole Number Overrides

Before You Begin

For more information on 9-Hole Group Names and Hole Number Overrides, please view our How The Scorecard & GPS Works article. If your facility is utilizing this feature (due to being a 27-holer or having a unique hole number configuration), read on. Please disregard this section if you are a standard 18 or 36-hole facility.

Using The Start Hole Column

This column is designed to use the jargon you have set up in the Courses section of your app. If Nine-Hole Group Names &/or Hole Number Overrides are inputted in the course you have selected within the tournament software, you can use them within this column to make setup simpler.

Let's use an 18-hole course with two nines, Olde and Creek, each with holes 1-9 as an example. The holes are labeled in the Courses section of the dashboard as follows:
  1. Olde 1
  2. Olde 2
  3. Olde 3
  4. Olde 4
  5. Olde 5
  6. Olde 6
  7. Olde 7
  8. Olde 8
  9. Olde 9
  10. Creek 1
  11. Creek 2
  12. Creek 3
  13. Creek 4
  14. Creek 5
  15. Creek 6
  16. Creek 7
  17. Creek 8
  18. Creek 9

The following inputs in the StartHole column of the spreadsheet will yield the following results:
  1. Olde 1A
    1. This is the standard formatting we're looking for when a course is using 9-hole group names. It attaches the proper hole assignment of Olde 1A.
  2. Creek 1A
    1. This is the standard formatting we're looking for when a course is using 9-hole group names. It attaches the proper hole assignment of Creek 1A.
  3. 2
    1. Without the 9-hole group name, the system assumes the standard 1-18 hole formatting. This will assign the group to the second hole of the course, in this case Olde 2A.
  4. 11
    1. This will do the 11th hole of the course, in this case Creek 2A.
  5. 3B
    1. This will assign the third hole and the B group- in this case Olde 3B.
  6. Creek 14A or Olde 14B
    1. This is an invalid hole, so the system skips it and uses the last valid value above it- in this case Olde 3B.


    • Related Articles

    • Manually Entering Info In The Gallus Tournament Software

      Before You Begin Make sure you have an adequate understanding of the Gallus Tournament Software by reading our Tournament Software Basics article. What's The Point? In order to run an event in the Gallus Tournament Software, players, groups, and, if ...
    • Tournament Software Basics

      What's The Point? The Gallus Golf Tournament Software is designed to provide a best-in-class experience for the users of an app by providing live scoring and a suite of reporting for the organizers running the event. It is designed to be an ...
    • How The Scorecard And GPS Works

      What's The Point? The Scorecard & GPS section of a Gallus Golf custom-branded mobile app allows users to keep score in their app, view interactive hole renderings with GPS yardage, and post their score when they're finished. If you're interested in ...
    • Creating A New Event In The Gallus Tournament Software

      Before You Begin Make sure you have an adequate understanding of the Gallus Tournament Software by reading our Tournament Software Basics article. What's The Point? In order to run an event in the Gallus Tournament Software, its framework must first ...
    • Gallus Tournament Software Print Materials

      Before You Begin Make sure to have a basic understanding of the Gallus Tournament Wizard by viewing our article on Tournament Software Basics. Every option in the print materials section is based on the information entered on the main tournament ...