Import your roster

If you are moving an existing club across, you do not have to add members one by one. Send us your roster as a CSV (a spreadsheet saved in .csv format) and we will load the whole club in one go, ratings and all.

We run the import for you

Right now the ePegboard team handles roster imports. You prepare the file to the format below and send it over; we load it and confirm. You can always add or edit members yourself afterwards on the Members page.

What to send

A .csv file with a header row and one member per line. Columns can be in any order, and the header names are not case-sensitive.

Column	Required	Notes
Name	Yes	The member’s name. Must not be blank.
Gender	Yes	Male or Female (also accepts M, F, Man, Woman).
Email	No	Stored as-is. Leave blank if you do not have it.
Phone	No	Stored as-is. Leave blank if you do not have it.
MembershipType	No	Full, Trial or Guest. Blank counts as Full.
Rating	No	A starting rating as a number (see below). Blank starts the player at 1500.

Any columns we do not recognise are simply ignored, so it is fine to leave extra columns from your own spreadsheet in place.

Setting a starting rating

The Rating column takes a number, not a level name. If you leave it blank, the player starts at 1500 (a typical club regular) and settles to their real level over the first few sessions. If you would rather place people roughly, use the number for the closest level:

Level	Number to use
Beginner (never played)	400
Recreational (first few sessions)	800
Novice (casual, building basics)	1100
Intermediate (regular club player)	1500
Advanced (club-strong)	1900
Expert (county / league level)	2300

Do not put the level name in the Rating column - it must be the number, or the row will be rejected. If you are unsure, leave Rating blank and let the system settle everyone. See How ratings work for more.

Example

Name,Gender,Email,Phone,MembershipType,Rating
Alice Adams,Female,alice@example.com,07111 111111,Full,1500
Bob Baker,Male,,,Trial,
Priya Chandra,Female,priya@example.com,,Full,1900

Bob has no email, phone or rating: he is imported as a Trial member starting at 1500.

Before you send it

A few things that cause rows to be skipped, worth a quick check:

• Every row needs a Name and a Gender. Blank either one and that row is skipped.
• Gender is Male or Female (or M / F). Other values are not accepted on import - leave a note and we will sort anything that does not fit.
• Rating must be a number if you fill it in. A level name like “Advanced” will be rejected; use 1900.
• MembershipType must be Full, Trial or Guest (or blank). A typo like “full-time” is rejected.
• Save as UTF-8 CSV (the default from Excel, Google Sheets and Numbers). This keeps accented names correct.

What happens when we import

We run a preview first - no changes are saved until it looks right. The preview tells us, per row, whether it will be created, is a duplicate, or has an error:

• Duplicates (a member with the same name already in your club, or the same name twice in the file) are skipped, so re-sending a corrected file never creates doubles.
• Errors (the checks above) are skipped and flagged, so we can fix those rows with you.
• Everything else is created, with the rating you set or 1500 by default.

We confirm the counts back to you (created, duplicates, anything skipped) so you know exactly what landed.

Next

• Run your first club night - once your members are in, run a session.
• How ratings work - what the starting numbers mean and how they move.