Entries spreadsheet layout (CSV/Excel)

Besides Lenex, SDIF and Hy-Tek, swimming entries can come from a spreadsheet: CSV or TXT (semicolon-separated) or Excel (.xlsx). It is the simplest route for teams that build their entries outside a management program. The layout is the SwimRankings/Splash entries format.

Import the file under Transfers › Import › CSV/Excel (see Import entries). Before anything is saved, the preview shows what will be created.

File structure

Line	Content
1	The meet: name, city, country, course and date, separated by ;
2	The column names, in UPPERCASE and separated by ;. Any order
3 onwards	One entry per line

Required columns

Column	What goes in it
DISTANCE	Distance in metres: 50, 100, 200, 400, 800, 1500. For relays, the distance of one swimmer (100 in a 4x100)
STROKE	FREE, BACK, BREAST, FLY or MEDLEY
ENTRYTIME	Entry time as MM:SS.cc or SS.cc (1:02.50, 54.30), or NT with no time
GENDER	M, F or X (mixed). For relays, the event gender
CLUBCODE	The club’s official code in the federation (ECP, MTC)
CLUBNAME	Full club name
RELAYCOUNT	1 for individual events; 4 (or 8) for relays
FIRSTNAME and LASTNAME	Swimmer first and last name (individual events). Or FULLNAME with the full name
BIRTHDATE	Date of birth as DD.MM.YYYY or DD/MM/YYYY. Blank for relays
LICENSE	Swimmer registration. In Brazil, only the CBDA ID; leave blank if unknown
NATION	Swimmer country, World Aquatics 3-letter code (BRA, ARG)

Caution

No time is NT. Do not use 99:99.99 to mean “no time”: the system would read it as a real time and seed the swimmer last.

Optional columns

Column	What goes in it
YOB	4-digit year of birth, instead of BIRTHDATE. The date becomes 01/01 of that year — prefer the full date
CLUBNATION	Club country. Without it, the swimmer’s NATION is used
HANDICAP	Para swimming sport class (S9, SB8, SM9)
EXCEPTION	Para swimming exception code
RELAYNUMBER	The club’s relay team: 1 = A, 2 = B. Needed when a club enters more than one team in the same event

Relay swimmers

To send the line-up along, add the swimmer columns with the leg number at the end (1 to 4): FIRSTNAME1, LASTNAME1, GENDER1, BIRTHDATE1 (or YOB1), LICENSE1 for the first, FIRSTNAME2… for the second, and so on up to the fourth. HANDICAP<n> and EXCEPTION<n> also work per swimmer.

Example

Meet header, two individual entries and a relay with its line-up:

Regional Swimming Meet;Curitiba;BRA;LCM;15.08.2026
RELAYCOUNT;DISTANCE;STROKE;LASTNAME;FIRSTNAME;GENDER;BIRTHDATE;CLUBCODE;CLUBNAME;NATION;ENTRYTIME;LASTNAME1;FIRSTNAME1;GENDER1;BIRTHDATE1;LASTNAME2;FIRSTNAME2;GENDER2;BIRTHDATE2;LASTNAME3;FIRSTNAME3;GENDER3;BIRTHDATE3;LASTNAME4;FIRSTNAME4;GENDER4;BIRTHDATE4
1;400;FREE;Silva;Pedro;M;14.03.2009;ECP;Example Swim Club;BRA;4:59.99
1;200;MEDLEY;Souza;Carlos;M;02.07.2008;ECP;Example Swim Club;BRA;2:21.01
4;100;MEDLEY;;;M;;ECP;Example Swim Club;BRA;4:31.02;Silva;Pedro;M;14.03.2009;Souza;Carlos;M;02.07.2008;Lima;Mateus;M;20.01.2009;Rocha;Lucas;M;11.11.2008