CSV format requirements
GetDues accepts standard CSV files with the following columns:
Required columns:
member_name, parent_name, email, phone
Example row:
Sarah Johnson, Mike Johnson, mike@email.com, 555-123-4567
Column details:
- member_name: The player, student, or member’s name (e.g., “Sarah Johnson”)
- parent_name: The parent, guardian, or contact’s name (e.g., “Mike Johnson”)
- email: Valid email address for reminders and portal access
- phone: Phone number for SMS reminders (US format: 555-123-4567 or 5551234567)
Note:
Column order doesn’t matter, but column names must match exactly (case-insensitive). Extra columns are ignored.
Exporting from TeamSnap
TeamSnap makes it easy to export your roster. Here’s how:
Log in to TeamSnap
Go to your team page in TeamSnap and navigate to the Roster tab.
Export roster
Click the Export button (usually in the top-right or under a menu). Choose CSV format.
Format columns
TeamSnap exports include more columns than needed. Open the CSV in Excel or Google Sheets and ensure you have: member_name, parent_name, email, phone. Delete or ignore extra columns.
Save and import to GetDues
Save as a .csv file and upload it to GetDues.
Creating a CSV in Google Sheets
If you’re building your roster from scratch, Google Sheets is an easy tool:
| member_name | parent_name | phone | |
|---|---|---|---|
| Sarah Johnson | Mike Johnson | mike@email.com | 555-123-4567 |
| Alex Smith | Jamie Smith | jamie@email.com | 555-987-6543 |
Steps to download as CSV:
- In Google Sheets, click File → Download → Comma Separated Values (.csv).
- Save the file to your computer.
- Upload it to GetDues from your team dashboard.
Step-by-step import flow
Once you have a properly formatted CSV:
Go to your team dashboard
Click Add Members and select Import from CSV.
Upload your CSV file
Click Choose File and select your .csv file.
Review and confirm
GetDues will show a preview of your members. Check for any errors or missing data. You can edit individual rows before importing.
Import members
Click Import. Your team roster is now live in GetDues.
Common errors and fixes
“Missing required column: email”
Your CSV is missing the email column. Add a column with this exact name (case doesn’t matter). Make sure the header row is the first row.
“Invalid email format in row 5”
Check row 5 for a malformed email address (e.g., missing @, extra spaces). Fix it in your spreadsheet and re-upload.
“Phone number format not recognized”
GetDues expects US phone numbers in the format 555-123-4567 or 5551234567. Remove country codes (+1) and extra characters.
“File is not a valid CSV”
Make sure you saved as .csv format, not .xlsx (Excel) or .gsheet. Re-export from Google Sheets or Excel as CSV.
Need help importing your roster?
Send us your CSV and we’ll help troubleshoot any issues.
Contact Support