Loading Ball in the 6

Preparing the next page.

Loading…

ballinthe6

Store

Organization guide

Move your spreadsheet into Ball in the 6

Choose the data, select a spreadsheet, and review every row before anything is saved.

Open Import Data

Before you start

Use a clean copy of the source. Keep the original unchanged until you verify the imported records.

Permission for the organization action you need
A CSV, unencrypted XLSX, Google Sheet, or OneDrive XLSX workbook
Program and division IDs when the destination requires them
A small test file for the first import

Three parts. One final confirmation.

1
Choose data
Select Programs, Teams, Roster, Registrations, or Staff.
2
Choose source
Upload a spreadsheet or connect the account that holds it.
3
Review and import
Match the columns, validate the rows, then confirm the write.

Column matching and validation do not save records. Only the final Confirm import action writes valid rows.

Details when you need them

Open the section related to your file or question. Start with the complete workflow if this is your first import.

Complete workflowThe exact sequence from destination selection through result verification.

1
Choose the destination
Open Organization, choose Import data, then select Programs, Teams, Roster, Registrations, or Staff.
2
Download the template when needed
Keep the template headings, replace the example row, and save a working copy. Your own headings also work when you map them during review.
3
Choose the source
Upload CSV or unencrypted XLSX, choose a native Google Sheet, or search your OneDrive for an XLSX workbook.
4
Choose the table
For XLSX, Google Sheets, and OneDrive workbooks, select the worksheet and a header row from 1 through 100.
5
Confirm the columns
Confirm the source heading beside every required destination field. Set unrelated optional columns to Do not import.
6
Validate the rows
Choose Validate and review. Read the ready, skipped, and total counts plus every visible row error. Nothing is saved yet.
7
Confirm the write
Choose Confirm import only when the destination, sample values, and counts are correct. Valid rows are added and invalid rows are skipped.
8
Check the result
Verify the new records on the destination page and remove any disposable test records through the normal product workflow.

Supported sources and limitsCSV, XLSX, Google Sheets, Microsoft OneDrive, and Apple Numbers export guidance.

Source	How it works	Current limit
CSV upload	A .csv file from your computer. Row 1 is normally the header.	2 MB and 1,000 data rows
XLSX upload	An unencrypted .xlsx workbook. You choose the worksheet and header row.	10 MB, 1,000 reviewed rows, 200 columns
Google Sheets	Connect Google and use Google Picker to choose one native Google Sheet and worksheet.	1,000 reviewed rows, 200 columns
Microsoft Excel	Connect Microsoft, search your OneDrive, and choose one unencrypted .xlsx workbook and worksheet.	10 MB, 1,000 reviewed rows, 200 columns
Apple Numbers	Export to Excel for multiple worksheets or CSV for one table, then upload the exported copy.	The CSV or XLSX limit applies

Native .xls, .numbers, .xlsm, encrypted workbooks, ZIP64 workbooks, PDF extraction, and SharePoint or shared-library browsing are not supported. Export or save an approved CSV or XLSX copy instead.

What each destination createsRequired fields, dependency order, and the record created by each import.

Destination	Required source fields	Result
Programs	Program name, type, sport, season, start date, end date, and fee	Adds draft programs. It does not publish them.
Teams	Program ID, division ID, and team name	The program and division must already exist, and the division must belong to that program.
Roster	Program ID and player name	Adds a confirmed roster registration. Email and date of birth are optional.
Registrations	Program ID and player name	Adds a pending registration. Imported family details do not prove consent, a guardian relationship, a waiver, or payment.
Staff	Email, name, and role code	Creates a seven-day invitation. It does not activate staff automatically.

Build in dependency order

Import programs first. Create their divisions, then import teams. Import roster players and registrations after the target programs exist. A program Players import fixes the program destination automatically.

Program type codes: MINI, REC, SKILL, CAMP, REP, AAU, HS, PRIV, COLL, LEAGUE, TOURNAMENT, PROS, SPEC, SEASON, CLINIC.

Staff role codes: HEAD_COACH, ASST_COACH, VOLUNTEER, REFEREE, SCOREKEEPER, PROGRAM_ADMIN, ORG_ADMIN, TRAINER, MANAGER, FIRST_AID.

What the review protectsHow validation, duplicate risk, and the final confirmation work.

Column suggestions are suggestions. Confirm every required field.
The server validates the canonical table without writing records.
Review shows up to 50 sample rows and reports the complete ready and skipped counts.
The final confirmation sends the reviewed table to the selected destination.
Imports do not edit existing records. Repeating a program file can create duplicates.
There is no one-click rollback. Verify a small batch before importing more.

Google, Microsoft, and privacyProvider permissions, stored connections, and information that must not be imported.

Provider consent is separate from Ball in the 6 sign-in. Google asks for identity information and file-scoped access through Google Picker. Microsoft asks for identity information, offline access, and delegated read-only Files.Read access to the signed-in user’s OneDrive. Neither connector requests file write permission.

The connected account label and encrypted access and refresh tokens are stored for the signed-in Ball in the 6 user. Other organization staff do not inherit that connection. Disconnect removes the stored Ball in the 6 connection, not the provider account or workbook.

Do not import passwords, payment-card data, health records, unneeded youth information, or proof of consent. A spreadsheet does not establish verified parent-child status, a signed waiver, payment, eligibility, or official Gamebook statistics.

PermissionsThe organization role permission required for each action.

The organization owner has every organization permission. Other active staff members and coaches need a role containing the permission below. Ask the owner when an action is missing or denied.

Action	Required permission
Open the importer and connect a provider	Programs: view
Import programs	Programs: create
Import teams	Programs: edit
Import roster or registrations	Registrations: edit
Import staff invitations	Staff: invite
Export programs or teams	Programs: view
Export roster or registrations	Registrations: view

TroubleshootingDirect fixes for connection, file, heading, and permission problems.

Setup required: The application administrator has not completed that provider configuration. Use local CSV or XLSX until it is enabled.
Account was not connected: Consent was cancelled, rejected, or expired. Choose Connect again and finish the provider screen.
No OneDrive workbook found: Search for part of the exact filename. Only .xlsx files in the signed-in user's OneDrive are listed.
Wrong headings: Choose another worksheet or header-row number, then choose Review columns again.
Permission denied: Ask the organization owner to assign a role with the required destination permission.
File rejected: Remove encryption or macros, save as ordinary XLSX, reduce the file below 10 MB, or export the worksheet as CSV.
Connection expired: Choose Connect again. Reconnecting replaces the stored provider connection for your Ball in the 6 account.

ExportsAvailable spreadsheet exports and current exclusions.

Programs, Teams, Roster, and Registrations provide Export CSV and Export XLSX actions. Exports are limited to the active organization. The program Players area exports only that program’s confirmed roster. Staff export and PDF report export are not part of this workflow.

Loading Ball in the 6

Preparing the next page.

Organization guide

Move your spreadsheet into Ball in the 6

Choose the data, select a spreadsheet, and review every row before anything is saved.

Open Import Data

Before you start

Use a clean copy of the source. Keep the original unchanged until you verify the imported records.

Permission for the organization action you need
A CSV, unencrypted XLSX, Google Sheet, or OneDrive XLSX workbook
Program and division IDs when the destination requires them
A small test file for the first import

Three parts. One final confirmation.

1
Choose data
Select Programs, Teams, Roster, Registrations, or Staff.
2
Choose source
Upload a spreadsheet or connect the account that holds it.
3
Review and import
Match the columns, validate the rows, then confirm the write.

Column matching and validation do not save records. Only the final Confirm import action writes valid rows.

Details when you need them

Open the section related to your file or question. Start with the complete workflow if this is your first import.

Complete workflowThe exact sequence from destination selection through result verification.

1
Choose the destination
Open Organization, choose Import data, then select Programs, Teams, Roster, Registrations, or Staff.
2
Download the template when needed
Keep the template headings, replace the example row, and save a working copy. Your own headings also work when you map them during review.
3
Choose the source
Upload CSV or unencrypted XLSX, choose a native Google Sheet, or search your OneDrive for an XLSX workbook.
4
Choose the table
For XLSX, Google Sheets, and OneDrive workbooks, select the worksheet and a header row from 1 through 100.
5
Confirm the columns
Confirm the source heading beside every required destination field. Set unrelated optional columns to Do not import.
6
Validate the rows
Choose Validate and review. Read the ready, skipped, and total counts plus every visible row error. Nothing is saved yet.
7
Confirm the write
Choose Confirm import only when the destination, sample values, and counts are correct. Valid rows are added and invalid rows are skipped.
8
Check the result
Verify the new records on the destination page and remove any disposable test records through the normal product workflow.

Supported sources and limitsCSV, XLSX, Google Sheets, Microsoft OneDrive, and Apple Numbers export guidance.

Source	How it works	Current limit
CSV upload	A .csv file from your computer. Row 1 is normally the header.	2 MB and 1,000 data rows
XLSX upload	An unencrypted .xlsx workbook. You choose the worksheet and header row.	10 MB, 1,000 reviewed rows, 200 columns
Google Sheets	Connect Google and use Google Picker to choose one native Google Sheet and worksheet.	1,000 reviewed rows, 200 columns
Microsoft Excel	Connect Microsoft, search your OneDrive, and choose one unencrypted .xlsx workbook and worksheet.	10 MB, 1,000 reviewed rows, 200 columns
Apple Numbers	Export to Excel for multiple worksheets or CSV for one table, then upload the exported copy.	The CSV or XLSX limit applies

Native .xls, .numbers, .xlsm, encrypted workbooks, ZIP64 workbooks, PDF extraction, and SharePoint or shared-library browsing are not supported. Export or save an approved CSV or XLSX copy instead.

What each destination createsRequired fields, dependency order, and the record created by each import.

Destination	Required source fields	Result
Programs	Program name, type, sport, season, start date, end date, and fee	Adds draft programs. It does not publish them.
Teams	Program ID, division ID, and team name	The program and division must already exist, and the division must belong to that program.
Roster	Program ID and player name	Adds a confirmed roster registration. Email and date of birth are optional.
Registrations	Program ID and player name	Adds a pending registration. Imported family details do not prove consent, a guardian relationship, a waiver, or payment.
Staff	Email, name, and role code	Creates a seven-day invitation. It does not activate staff automatically.

Build in dependency order

Program type codes: MINI, REC, SKILL, CAMP, REP, AAU, HS, PRIV, COLL, LEAGUE, TOURNAMENT, PROS, SPEC, SEASON, CLINIC.

Staff role codes: HEAD_COACH, ASST_COACH, VOLUNTEER, REFEREE, SCOREKEEPER, PROGRAM_ADMIN, ORG_ADMIN, TRAINER, MANAGER, FIRST_AID.

What the review protectsHow validation, duplicate risk, and the final confirmation work.

Column suggestions are suggestions. Confirm every required field.
The server validates the canonical table without writing records.
Review shows up to 50 sample rows and reports the complete ready and skipped counts.
The final confirmation sends the reviewed table to the selected destination.
Imports do not edit existing records. Repeating a program file can create duplicates.
There is no one-click rollback. Verify a small batch before importing more.

Google, Microsoft, and privacyProvider permissions, stored connections, and information that must not be imported.

PermissionsThe organization role permission required for each action.

The organization owner has every organization permission. Other active staff members and coaches need a role containing the permission below. Ask the owner when an action is missing or denied.

Action	Required permission
Open the importer and connect a provider	Programs: view
Import programs	Programs: create
Import teams	Programs: edit
Import roster or registrations	Registrations: edit
Import staff invitations	Staff: invite
Export programs or teams	Programs: view
Export roster or registrations	Registrations: view

TroubleshootingDirect fixes for connection, file, heading, and permission problems.

Setup required: The application administrator has not completed that provider configuration. Use local CSV or XLSX until it is enabled.
Account was not connected: Consent was cancelled, rejected, or expired. Choose Connect again and finish the provider screen.
No OneDrive workbook found: Search for part of the exact filename. Only .xlsx files in the signed-in user's OneDrive are listed.
Wrong headings: Choose another worksheet or header-row number, then choose Review columns again.
Permission denied: Ask the organization owner to assign a role with the required destination permission.
File rejected: Remove encryption or macros, save as ordinary XLSX, reduce the file below 10 MB, or export the worksheet as CSV.
Connection expired: Choose Connect again. Reconnecting replaces the stored provider connection for your Ball in the 6 account.

ExportsAvailable spreadsheet exports and current exclusions.

Loading Ball in the 6

Before you start

Three parts. One final confirmation.

Choose data

Choose source

Review and import

Details when you need them

Choose the destination

Download the template when needed

Choose the source

Choose the table

Confirm the columns

Validate the rows

Confirm the write

Check the result

Build in dependency order

Loading Ball in the 6

Before you start

Three parts. One final confirmation.

Choose data

Choose source

Review and import

Details when you need them

Choose the destination

Download the template when needed

Choose the source

Choose the table

Confirm the columns

Validate the rows

Confirm the write

Check the result

Build in dependency order