How to import your ClubSpark members into Setsy

A lot of clubs already have their members in ClubSpark. Up to now, getting them into Setsy meant typing them in or tidying up a spreadsheet so it matched our paste format. For a club with a hundred-odd members, that's an evening gone before you've run a single session.

Now you can upload the ClubSpark member export as it is.

How to do it

1. In ClubSpark, export your members as a CSV file.
2. In Setsy, go to Players, then Bulk import, and open the Import from ClubSpark tab.
3. Choose the file.
4. Check the summary and click Import.

The video above runs through it.

What you'll see before anything is saved

Once you pick the file, Setsy shows you what it found: how many members are in the file, how many are already on your player list, any names that appear twice, and any rows with no name. Then it tells you how many players it will add.

Nothing is saved until you click Import, so if the numbers look off you can go back to ClubSpark and fix the export first.

A few things worth knowing

Only names and genders are sent to Setsy. The file is read in your browser. ClubSpark exports carry a lot of personal detail, like addresses, email addresses and ages, and none of that leaves your computer.

Everyone in the file is imported. That includes juniors and lapsed members. If you don't want them, filter them out in ClubSpark before you export.

Nobody gets added twice. Anyone already on your player list is left as they are. So at the start of each season you can import a fresh export and only the new members come in.

New players start on a Mid rating. ClubSpark doesn't know how well people play, so everyone comes in at Mid (3) with singles off. When the import's finished, Setsy offers to take you to Bulk edit, where you can set ratings for everyone on one screen.

Demo players are removed. If you still have the demo players from when you signed up, they're cleared out once your real players are in.

Plan limits still apply. If your file has more new members than your plan has room for, the first ones that fit are imported and Setsy tells you how many were left out.

Not on ClubSpark?

The copy and paste option is still there on the other tab. Paste names straight from a spreadsheet and you're away.

If your club uses a different membership system and you'd like an import for it, let me know which one. If enough clubs ask for the same system, I'll build an importer for it.

Thanks, Marty