How can we help you?

How do I import an Athlete spreadsheet to my Wodify environment?

Follow

Wodify allows you to add athletes to your Wodify environment by importing them from a spreadsheet!

To import athletes into your environment:

  1. Head to People > Athletes
  2. Click Import in the top right cornermceclip1.png
  3. Click Download Templatemceclip2.png
  4. Enter the appropriate athlete information in each column of the template that is downloaded.

 

To complete an import, Wodify requires specific formatting (there can be no blank spaces within most cells). Below are the required fields that must be filled out for a successful import:

  • First Name
  • Last Name
  • Email 
    • For an athlete without an email address - they will be imported as a Dependent without a Guardian, but you must specify "TRUE" under "Is Dependent".
    • For an athlete that should be imported as a Dependent with a Guardian, list the Guardian's email address under the "Group" column. Learn more about Groups here.
  • Gender - First letter capitalized as either “Male” or “Female”
  • Date of Birth - Format as 01/01/2000
  • Athlete Status - “ACTIVE” or “INACTIVE”
  • Default Program - Needs to match exactly with a Program listed in your Wodify environment (see Schedule > Programs)
  • Default Location - Needs to match exactly with the Wodify environment (see Gym > Locations)

 

The following fields are optional, and will automatically populate appropriately in the athlete's profile if not specified:

  • State - If one is not specified for US countries, the business's state will be used
  • Time Zone - If not specified, the business's time zone will be used
  • Is Coach, Is Admin, Is Manager - Must be 'TRUE' or 'FALSE' but, if empty, will default to 'FALSE'
  • Province (if outside the US) - If not specified, business's province will be used
  • Country - This is the two digit country code (ie: US for United States, GB for Great Britain)

IMPORTANT: If the athlete's email already exists in your Wodify environment, an athlete account will be created but with an automatically generated email alias.  

 

After completing your spreadsheet, click Select File and choose your spreadsheet. Note: The athletes successfully imported as 'Active' will be active in your system. For Legacy customers, these accounts will be included in your athlete count on your Wodify monthly statement.

There are two Import Options:

  • Overwrite Existing Athletes - To avoid duplicating data you should use this option, especially if you're importing the same information more than once with changes. Do not use this option if you are importing new athletes that are not currently in your Wodify environment. 
  • Send Welcome Email - By choosing this option an email will automatically be sent with username and password credentials to the imported athletes, so they can start using Wodify. This action can also be completed manually through each athlete's profile.

mceclip4.png

Once you've successfully imported the spreadsheets, the athletes will be live in your Wodify environment.

Comments

Check the current status of our products

View status