RacqtA template instead of guesswork
A ready-made CSV with all columns and three example rows.A ready-made CSV with all columns and three example rows. Copy your data in, upload, done.
Download template
Switching guide
From the Excel list to a running club.
Your members are in a spreadsheet? Then switching is a file upload with a preview. It works just as well without a list.Your members are in a spreadsheet? Then switching is a file upload with a preview. And if you’re starting from scratch, it works just as well — only without a file.
- Preview before anything is imported
- Duplicate email addresses are skipped
- Accounts are only created when you invite
Option 1 · You have lists
Imported in five steps.
A CSV file with semicolons as separators. You see every row before it is imported — nothing is created without your say-so.The import reads a CSV file with semicolons as separators. You see every row before it is imported — nothing is created without your say-so.
- 01
Save the list as CSV
In Excel: File › Save As › CSV UTF-8. The separator is the semicolon — the default in German Excel.In Excel: File › Save As › CSV UTF-8. Numbers and LibreOffice can do the same. Racqt uses the semicolon as the separator — the default in German versions of Excel.
- 02
Adjust the column headings
Name the first row as in the table below. The order and extra columns don’t matter.The first row contains the column names. Name them as in the table below. The order and any extra columns don’t matter — anything Racqt doesn’t recognise is ignored.
- 03
Create categories first
The preview reports unknown categories as errors. So create them first under Members › Categories.If the “kategorie” column contains a name that doesn’t exist in the club yet, the preview reports it as an error. So create adults, juniors, non-playing members and so on beforehand under Mitglieder › Kategorien (Members › Categories).
- 04
Upload and check the preview
Dashboard › Members › CSV import. The preview shows every row with its status; errors are named individually.Dashboard › Mitglieder › CSV-Import (Members › CSV import). Racqt reads the file and shows every row with name, email and status. Rows with errors are named individually — missing name, unknown category or “already a member”.
- 05
Confirm the import
Only valid rows are imported. Correct, upload again — existing members are skipped.Only the valid rows are imported. You can correct the faulty ones at your leisure and upload the file again — members who already exist are skipped, not created twice.
These are the columns Racqt reads.
Case and order don’t matter. Other columns are ignored. Column names stay in German.Upper and lower case don’t matter, nor does the order. Columns not listed here are ignored. The column names stay in German, exactly as the import expects them.
- anrede optional
Example Frau
Salutation
- vorname Required*
Example Anna
First name; first or last name must be present
- nachname Required*
Example Berger
Last name
- geburtsdatum optional
Example 14.03.1986
Date of birth: DD.MM.YYYY or YYYY-MM-DD
- email optional
Example anna.berger@beispiel.de
Without an address: member without an account, can be invited later
- telefon optional
Example 0201 1234567
Phone
- strasse optional
Example Am Wiesenweg 4
Street
- plz optional
Example 45657
Postcode
- ort optional
Example Musterstadt
Town
- mitgliedsnr optional
Example M-001
Your existing membership number
- kategorie optional
Example Erwachsene
Category; must be created first
- rolle optional
Example mitglied
Role: mitglied · vorstand · platzwart · mannschaftsführer
| Column | Required? | Example | Note |
|---|---|---|---|
| anrede | optional | Frau | Salutation |
| vorname | Required* | Anna | First name; first or last name must be present |
| nachname | Required* | Berger | Last name |
| geburtsdatum | optional | 14.03.1986 | Date of birth: DD.MM.YYYY or YYYY-MM-DD |
| optional | anna.berger@beispiel.de | Without an address: member without an account, can be invited later | |
| telefon | optional | 0201 1234567 | Phone |
| strasse | optional | Am Wiesenweg 4 | Street |
| plz | optional | 45657 | Postcode |
| ort | optional | Musterstadt | Town |
| mitgliedsnr | optional | M-001 | Your existing membership number |
| kategorie | optional | Erwachsene | Category; must be created first |
| rolle | optional | mitglied | Role: mitglied · vorstand · platzwart · mannschaftsführer |
* It’s enough if the first name or last name is filled in.
After the import
What happens after the import.
- The import doesn’t create accounts — the email addresses are only contact addresses. Nobody can simply sign in.The import doesn’t create any accounts: we store the email addresses as your members’ contact addresses — so nobody can simply sign in.
- You invite your members when you’re ready. Each person then creates their own account.You invite your members when you’re ready. With the invitation link, each person creates their own account or accepts the invitation with their existing Racqt account.
- Until then, courts, fees and teams work even without active member accounts.Until then, you keep working in the dashboard as usual: courts, fees and teams work even without active member accounts.
Stays behind
What doesn’t come along.
- Fee data and SEPA mandates Members have to grant mandates themselves — that’s what the direct debit scheme requires. You set up fee groups in the dashboard.
- Old bookings and statistics Racqt starts with a clean booking calendar. Your old history remains available in your old solution.
- Photos and documents You upload images, statutes and forms directly where they belong — media library, statutes, online sign-up.
Option 2 · From scratchOption 2 · You’re starting from scratch
It works just as well without a list.
No existing data, no legacy. Members join by themselves.No existing data, no legacy. You set up the club once and let members join by themselves.
- 01
Create your club
Name, town, colours and logo — the app appears in your colours.Name, town, colours and logo. That gives your club its address on Racqt, and the app appears in your colours.
Help centre: Create your club - 02
Courts and times
Courts, opening hours and blocked times. Then bookings can start.Create courts, set opening hours and blocked times. Then bookings can start.
Help centre: Courts and times - 03
Categories and roles
Adults, juniors, non-playing — and who can do what in the club.Adults, juniors, non-playing members — and who can do what in the club: committee, treasurer, groundskeeper, sports director.
Help centre: Categories and roles - 04
Bring in members
Invite one by one or open online sign-up.Either invite them one by one or open online sign-up on your club page — then new members register themselves.
Help centre: Bring in members
Frequently asked questions
Before you start.
Is your question missing? We’re also happy to look at your list together.
Write to usWhat about members without an email address?
The email column can stay empty — children and non-playing members are perfectly normal members, they just don’t use the app. You only need an address when you want to invite someone; you can do that at any time later via “Konto einladen” (Invite account).
We have several lists — members, teams, fees.
Start with the member list; everything else depends on it. Afterwards, you create teams in the dashboard and add members to them; fee groups likewise.
What happens with duplicate entries?
Racqt checks the email address. Anyone who is already a member with that address is marked “already a member” in the preview and skipped during the import. For rows without an email, the preview warns you if the name and birthday already exist — check those rows before you confirm.
Can we get out again?
Yes. The member list can be exported as CSV at any time (opens directly in Excel) — with the same fields you put in. There is no minimum term.
How large can the file be?
Up to 5 MB — enough for several thousand members. Simply split larger lists.
Send us your list — we’ll tell you what’s missing.
One look at your spreadsheet is enough. Free and without obligation.One look at your spreadsheet is enough, and you’ll know in advance how many rows will go through cleanly. Free and without obligation.