CSV template and format
Column specifications, delimiters, date formats, and encoding options for CSV import.
Prerequisites: You're on Step 1 of CSV import.
Standard Columns
The CSV template has 7 standard columns (in this order):
1
First Name
Yes
Jane
2
Last Name
Yes
Smith
3
Discipline
Yes
WAG
4
Date of Birth
Yes
01/15/2012
5
Club Name
Yes
Sunrise Gymnastics
6
Level Name
No*
Level 5
7
Additional Identifier
No
ABC-1234
*Level is required when importing for a meet registration, optional for club-only import.
Custom Columns
Any columns after the 7th are treated as custom fields. Gym Art Meets reads the header name and creates a custom field for each extra column. These map to meet-specific custom fields during registration.
Import Settings
Click the Settings gear on Step 1 to configure:
Delimiter
Comma, Tab, Semicolon, Pipe
Comma
Text Qualifier
Double quotes ("), Single quotes (')
Double quotes
Date Format
dd/MM/yyyy, MM/dd/yyyy, yyyy-MM-dd, and more
MM/dd/yyyy
Encoding
UTF-8, ISO-8859-1, Windows-1252
UTF-8
End of Line
LF (\n), CRLF (\r\n)
Auto-detect
Skip Empty Rows
On / Off
On
Trim Whitespace
On / Off
On
Data Start Row
Row number where data begins
2 (after header)
Tips
Excel users: Save as "CSV UTF-8" for best compatibility.
Google Sheets users: File → Download → CSV works out of the box.
Date issues are the #1 import error. Make sure your date format setting matches your actual data. See Fix CSV import errors.
Discipline values: Use the discipline codes your meet expects (e.g., WAG, MAG). Check the meet's level configuration.
Related
Last updated