How League Spreadsheet Imports Work

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 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 Leagues Software once for a seamless first round setup experience.

This method should only be used for the initial upload of a League Roster. 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 the below articles:
  1. How League Rosters Work
  2. How League Teams Work
  3. How League Flights Work

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. Click Leagues in the top-right of the page.

  4. Select the League you'd like to upload a spreadsheet for.

  5. On the League checklist page, click Upload Spreadsheet Template.

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

  7. 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.
  8. Once finished and saved in your spreadsheet editor of choice (XLSX format), go back to the spreadsheet upload page in the League software, click Choose File, and select the spreadsheet from your computer.

  9. Click Import.

  10. DONE!
    1. If you have a large league (many rounds and players), the page may tell you to come back in a few minutes as it needs time to import all of the data into your league. (You can navigate away from the page and the data will continue to upload.)
    2. Once finished, all of the information within the spreadsheet will 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 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 ...

    • Manually Entering Info For Leagues

      Before You Begin Make sure to have a proper understanding of Leagues by viewing our League Software Basics article. What's The Point? League admins need a way to input their League Rosters and manage player/team details throughout the entirety of the ...

    • How League Rosters Work

      Before You Begin Make sure to have an adequate understanding of the Gallus Leagues Software by viewing our League Software Basics article. Tutorial Video What's The Point? The heartbeat of any League is the Players that participate within it. League ...

    • How League Leaderboards Work

      Before You Begin Make sure to have an adequate understanding of Leagues by viewing our League Software Basics article. What's The Point? Leagues are all about competition. As users keep score in a facility's app, they expect to see a breakdown of ...

    • Leagues User Experience

      Before You Begin Make sure to have an adequate understanding of Leagues by viewing our League Software Basics article. What's The Point? Users must follow a specific process to join an event on the day of a League round. This article will outline ...