Import your roster

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

You import it yourself

On the Members page, Import CSV loads your whole roster. It previews the file first, so you see exactly what will be created before anything is saved, and you can add or edit members by hand afterwards. Would you rather we did it for you? Prepare the file to the format below, send it over, and we will load it and confirm.

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 - the row is flagged in the preview so you can fix it.
• 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 you import

Import CSV runs a preview first - no changes are saved until it looks right. The preview tells you, 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-importing a corrected file never creates doubles.
• Errors (the checks above) are skipped and flagged, so you can fix those rows and import again.
• Everything else is created, with the rating you set or 1500 by default.

When you confirm, ePegboard reports the counts (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.