Importing Your High School or College Team
Importing is only recommended for college and high school teams
If you are a club team, we recommend that you add parent and wrestlers to your team by opening up registration for your next season. Typically that results in cleaner data and less confusion for your parents, since they will need to set up their account before they pay. See here for details on how to get ready to accept your first registration in WrestlingIQ as a club team.
If you don't want to import your team one by one, WrestlingIQ gives you the ability to upload a CSV file that will import wrestlers, invite them, and also invite parents (if you want).
Importing Wrestlers
Navigate to Roster - Wrestlers - Import
There are two helpful templates for you to use here if you choose:
- A Google Sheets template is available for you to duplicate and fill out. If you do not want to use the Sheets spreadsheet, make sure your .csv file has the headers in the first row as described (capitalization matters). This will be more helpful if you already have all of the parent and athlete information on hand. Some coaches also take a laptop to the first day of practice and have the kids enter their information into the spreadsheet directly.
- The second option is the ability to collect parent/athlete information through a Google Form questionnaire and convert that information for importing. This will be more helpful if you still need to collect information from parents and athletes and want an easy link to send out for responses.
Both of these templates can be helpful tools depending on whether you already have information on hand or still need to collect it from parents. Whatever avenue you choose, just remember that the information needs to be converted to a .csv before upload.
Tip: If you get this error (see below) make sure you export as a .csv and then upload!
Once you upload the CSV file and click the 'Upload' button WrestlingIQ will give you a chance to review the import and do a basic check to try to throw out any duplicates. For wrestlers, duplicates are based on first name and last name—exact spelling matches—and a date of birth if given. Parents duplicates are detected by an exact spelling match.
Here's what the importer might show after you upload the file, but before you begin the import:
Tap the 'Import' button and WrestlingIQ will save all of the importable wrestlers and parents to your account. If you entered emails, invites will be sent to the wrestlers/parents, which will let them create an account to begin receiving messages, viewing the calendar, etc.
Want to see who has accepted their invites?
The 'Invite Status Report' in the reports area of WIQ is what you want. That will show you who has accepted and allow you to quickly resend any invites for outstanding accounts.
Duplicate data? Run a merge
If you ended up with duplicate accounts, the easiest way to deal with it is to merge the two accounts together.