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 a Tournament 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.

This method should only be used for the first round of a Tournament. For small changes leading up to the first round or in subsequent rounds, please utilize the dashboard to manually adjust details. For more information on the manual entry method, please view our Manually Entering Info In The Gallus Tournament Software article.

Read on for detailed instructions on how to use this handy feature.

Tutorial Video


Steps To Complete

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

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

  4. On the Tournament checklist page, click Use 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 the prefilled examples.
    1. See the section below for detailed instructions on setting up start holes for shotgun-style events.
    2. For more information on managing handicaps with the GHIN integration, please view our How The Events GHIN Integration Works article.
  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 the spreadsheet from your computer.

  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

    • How League Spreadsheet Imports Work

      Before You Begin Make sure to have an adequate understanding of the Gallus Leagues Software by viewing our League Software Basics article. What's The Point? When creating a League through the Gallus Admin Dashboard, many organizers want a simple and ...

    • How Tournament Cuts 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? Multi-round competitions often require a cut to be made based off overall score. The ...

    • How Tournament Flights 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 running a tournament or competition within the Gallus Tournament Software, a ...

    • 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 ...

    • 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 ...