TournamentBee Guide · Organizers

IMPORT ENTRIES

Add confirmed players or teams from the tournament Registrations tab without self-registration. Use the full-screen spreadsheet, paste from Excel, or upload an Excel/CSV file that matches the template for the selected event.

How import works

Spreadsheet page · paste or upload

Open the tournament → Registrations → Import entries.
Select the event to import into (required). Columns change for singles vs doubles.
Download the Excel template, type into the sheet, paste from Excel, or upload a filled file — then Validate → Import.
Imported registrations are created as confirmed (draw-eligible) and marked Imported.

Import one event at a time. The event you select applies to every row in the sheet or file.

Excel template

Best way to match the format

On the import page, click Download template after selecting the event. You get an .xlsx file with:

The exact header row TournamentBee expects (do not rename or reorder columns)
Example data rows you can overwrite or delete
Dropdowns for role, gender, and affiliation type
Comments on each header explaining the field

Fill the template in Excel or Google Sheets, then either paste the cells into the import page or use Upload Excel / CSV. CSV exports also work (UTF-8, UTF-16, or Windows-1252).

Paste & auto-fix

What changes when you paste or upload

Names and affiliation names are title-cased unless you type them yourself after paste.
Phone is normalised to 10 digits starting with 0 (e.g. +94 77… → 077…).
SLB values like 7702 or slb-7702 become SLB7702.
Cells that were altered show an amber corner — hover to see the original value.

Team template

One row per roster member

Use this when the tournament format is team. Group players with the same team_name. Exactly one row per team must have role=captain.

Column reference

Column	Required	Notes
team_name	Yes	Same value groups members into one team
role	Yes	captain or roster (exactly one captain per team)
first_name	Yes	Player first name
last_name	Yes	Player last name
date_of_birth	Yes	YYYY-MM-DD (e.g. 1998-05-12)
phone	No	Optional — 10 digits starting with 0 (e.g. 0771234567)
gender	Yes	male or female
slb_number	No	Optional — format SLB7702 (digits alone become SLB… on paste/upload)
affiliation_type	No	school, club, or individual — leave blank to default to individual
affiliation_name	If school/club	Required for school/club; must be blank when type is individual or empty

Example — 1 team entry (Falcons)

One team named Falcons: 1 captain + 2 roster members. In the file this is three data rows under the same header.

team_name	role	first_name	last_name	date_of_birth	phone	gender	slb_number	affiliation_type	affiliation_name
Falcons	captain	Amal	Perera	1998-05-12	0771234567	male	SLB1001	club	Colombo BC
Falcons	roster	Nimal	Silva	1999-03-21	0772345678	male	empty	individual	empty
Falcons	roster	Kasun	Fernando	2000-11-02	0773456789	male	empty	school	Royal College

Roster size must meet the event’s min/max and any male/female minimums from rubbers.
TournamentBee creates a player account for each person automatically (no TournamentBee ID in the file).
If affiliation_type is blank, it defaults to individual.

Individual template

One row per entry

Use this when the tournament format is individual. Download the template after selecting the event — singles templates have player columns only; doubles templates also include partner columns. Leave affiliation_type blank to default to individual.

Singles columns

Column	Required	Notes
first_name	Yes	Entrant first name
last_name	Yes	Entrant last name
date_of_birth	Yes	YYYY-MM-DD
phone	No	Optional — 10 digits starting with 0
gender	Yes	male or female
slb_number	No	Optional — format SLB7702 (digits alone become SLB… on paste/upload)
affiliation_type	No	school, club, or individual — leave blank to default to individual
affiliation_name	If school/club	Required for school/club; must be blank when type is individual or empty

Example — singles event (no partner columns)

first_name	last_name	date_of_birth	phone	gender	slb_number	affiliation_type	affiliation_name
Amal	Perera	1998-05-12	0771234567	male	SLB1001	club	Colombo BC
Nimal	Silva	1999-03-21	0772345678	male	empty	individual	empty

Doubles columns

Column	Required	Notes
first_name	Yes	Entrant first name
last_name	Yes	Entrant last name
date_of_birth	Yes	YYYY-MM-DD
phone	No	Optional — 10 digits starting with 0
gender	Yes	male or female
slb_number	No	Optional — format SLB7702 (digits alone become SLB… on paste/upload)
affiliation_type	No	school, club, or individual — leave blank to default to individual
affiliation_name	If school/club	Required for school/club; must be blank when type is individual or empty
partner_first_name	Yes	Partner first name
partner_last_name	Yes	Partner last name
partner_date_of_birth	Yes	YYYY-MM-DD
partner_phone	No	Optional — 10 digits starting with 0
partner_gender	Yes	male or female
partner_slb_number	No	Optional — same format as slb_number (e.g. SLB7702)
partner_affiliation_type	No	school, club, or individual — leave blank to default to individual
partner_affiliation_name	If school/club	Required for school/club; must be blank when type is individual or empty

Example — doubles event (includes partner columns)

first_name	last_name	date_of_birth	phone	gender	slb_number	affiliation_type	affiliation_name	partner_first_name	partner_last_name	partner_date_of_birth	partner_phone	partner_gender	partner_slb_number	partner_affiliation_type	partner_affiliation_name
Amal	Perera	1998-05-12	0771234567	male	empty	club	Colombo BC	Kasun	Fernando	1999-01-10	0773456789	male	empty	school	Royal College
Sahan	Jayasuriya	1997-08-09	0711112233	male	SLB2002	individual	empty	Dilshan	Wickramasinghe	1998-01-15	0712223344	male	empty	individual	empty

Tips

Avoid common import failures

Keep the header row exactly as in the template (column names and order).
Prefer the Excel template — or paste/upload a file with the same headers.
Phone must match 0XXXXXXXXX (10 digits).
Dates must be YYYY-MM-DD (other common formats are normalised on paste).
Validate first — fix any row errors before Import.
Leave affiliation_type blank to default to individual (same for partner columns on doubles).
Always download a fresh template after selecting the event so singles, doubles, and team columns match.

Where to get the template

Org portal → Tournament → Registrations → Import entries → select event → Download template

Paste or upload → Validate → Import

Back to all guides