Roster -- Import from a File

Takedown Scoring and Stats supports Roster and Opponent Team import from a file. For teams not on Trackwrestling or USA Wrestling, this is a significant time-saver compared to manually entering names into Takedown. Of course, teams on Trackwrestling and USA Wrestling can be downloaded directly from our database.

Preparing the Roster Data

Roster data is imported from a Comma Separated Values (CSV) text file.  In this simple text file, each row represents a single wrestler and each piece of information in the row is separated from the adjacent piece of information by a comma.

The first row in the file contains the column "headers" which describe the information in the file:

Header Name	Meaning	Allowable Values/Format	Available for Opponent Team?
Last Name	Wrestler last name	Any text	Yes
First Name	Wrester first name	Any text	Yes
Gr.	Grade	Any of: pre-K, K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13	No
Yr.	College year	Fr., So., Jr., Sr., RS Fr., RS So., RS Jr., RS Sr., Redshirt, n/a	No
Birthdate	Birthdate	Format: d/m/yyyy. d and m can be one or two digits. yyyy must be four digits. Examples: 1/23/2023, 12/4/2023	No
Phone	Telephone number	Any format and values. Examples: 123-456-7890, 123 456 7890, 456_7890	No
Email	Email address	Valid email address	No
Cert. Date	Weight certification date	Format: d/m/yyyy. d and m can be one or two digits. yyyy must be four digits.	No
Cert. Wt.	Weight on certification date	Integer or decimal. Integer is 3 characters max. Example: 123.7	No
MWC	Minimum weight class	Integer, 3 characters max. Example: 125	Yes
MWW	Minimum wrestling weight	Integer or decimal. Integer is 3 characters max. Example: 123.7	No

Important details:

1. Headers names must appear exactly as in the table above. For example: 'Last Name' works, 'Last name' doesn't work.  For convenience, the exact header names are:
   Last Name, First Name, Gr., Yr., Birthdate, Phone, Email, Cert. Date, Cert. Wt., MWC, MWW
2. All headers aren't required
3. Header order does not matter
4. Data order in a row matters and should correspond to the header order
5. Minimum headers are Last Name and First Name
6. Minimum row data is Last Name and First Name
7. If Cert. Date or Cert Wt. is present, both pieces of data must be present
8. All headers are available for Roster. Some headers are available for an Opponent Team roster (see table).
9. Empty/blank rows are not supported. Delete empty or blank rows as they will cause the import to fail.
10. A zero for certified weight is not supported. Change the weight to a positive number or delete the row. 

Here's an example of a simple roster import file:

Last Name, First Name
Smith, John
Sanderson, Cael
Gable, Dan

A more complex example:

Last Name, First Name, Gr., Cert. Date, Cert Wt. MWW, MWC
Smith, John, 11, 11/1/2013, 140, 132, 133
Sanderson, Cael, 12, 11/1/2013, 195, 182, 184
Gable, Dan, 10, 11/1/2013, 156, 148, 149

Importing the Data into Takedown

Conveniently, most spreadsheet applications, including Excel and Google Sheets, can easily save data to a CSV file.

The easiest way to import a roster file into Takedown to email to your iPad the CSV file as an attachment. Once the file is received on the iPad:

1. Open the email message
2. Tap the attachment
3. Tap the sharing icon in the upper right corner
4. Tap the Takedown icon (scroll to the right if necessary)

This will bring up Takedown where you'll select the Season into which the roster should be imported along with the team name. Import the file as your Roster or select an Opponent Team name.