Editing Templates Without Excel - Importing and Exporting on Google Sheets

If you do not have access to Microsoft Excel, you can easily use our templates on Google Sheets by importing the File, then exporting the completed version back into Excel format.

Import our Template into Google Sheets:

1. Download the template from the App Portal
2. Open a New Template on Google Sheets
3. Click File > Import
4. Select the downloaded Portal template

 

     5. Enter your data on the template, then follow the Export steps to convert it back into an Excel file

 

Export the Template from Google Sheets:

With your completed spreadsheet open on Google Sheets, click:

1. File > Download > Microsoft Excel

.   

    2. You can now complete the Import/upload process inside of the App Portal

 

 

Steps to Upload & Publish on the Portal:

1. On your Dashboard, scroll down to Quick Actions > Import Data
2. Follow the page prompts to confirm your Data Type (Excel), Template Type (Game, Roster, etc.) and Team for the Upload, then
3. Select the completed file
4. Click Start Import
1. The next page reviews your data - any errors will need to be corrected
5. Click Finalize Import (scroll to the bottom of the page - not available if there are errors)
6. PUBLISH your upload so it’s visible in the app:
1. Go to App Content > Games, Special Events, Players, etc (based on your template type)
2. Click on the Drafts folder

     3. Mass-select or choose which need to be published

     4. Scroll to the bottom of the page and select “Publish” to show them in the app