Import your clients from a CSV file

Invite many clients at once from a spreadsheet: download the template, add your file, check the rows and send.

On this page

You can invite many clients at once with a CSV file. On the client list, click Import CSV, add your file, check the rows and send. Each client gets the invitation email.

1. Download the template

In the side menu, click Clients. At the top of the client list, click Import CSV. The Import clients from CSV window opens.

Click Download template. Gymkee saves the file invite-template.csv with four columns: firstName, lastName, email and lang. It holds two sample clients: replace them with your own clients, one client per row.

First name, last name and email are required. The lang column is optional.

2. Add your file

Drag your file onto the window, or click choose a file and pick it on your computer. Gymkee accepts .csv files only. If your list is in Excel or Google Sheets, save or download it as a CSV file first.

Gymkee reads the first row of the file as the column names, so you have nothing to match by hand. If a required column is missing, Gymkee does not read the file and a message names the missing column.

3. Check the rows

Each client in your file becomes a row with First name, Last name, Email, Lang, Groups and Subscription. In each row you can:

  • fix a value by clicking in its cell,
  • pick one or more groups in Groups,
  • pick a subscription in Subscription,
  • remove the row with the cross at its end.

To start again with another file, click Re-import.

If some rows of your file have a problem, a warning appears above the table as soon as the rows appear, for example 1 row needs attention. It counts the rows with a missing first name, last name or email, a wrong email, or a lang other than en, fr, es, de, pt or it, and the second copy of an email used twice in the file. Most of these rows are not red yet: find them in the table and fix them as described below. A lang other than en, fr, es, de, pt or it never turns red: the row takes your own language and can be sent. The warning counts the file as it was read, so fixing a cell does not change it: it stays until you remove the row or click Re-import. The red cells and the send button show what is left to fix.

Gymkee shows errors in red:

  • An email that appears on two rows is red on both as soon as the rows appear. Fix or remove one of the two and the red clears on both.
  • A missing first name, last name or email, or an email with a typo, turns red once you click into the cell and leave it.

While a row still has an error, the send button does not send the invitations. When you click it, Gymkee shows the message Fix highlighted rows instead. If no row has a first name, a last name and an email, the send button cannot be clicked at all.

4. Send the invitations

Click the send button. It shows how many invitations go out, for example Send 6 invitations. Gymkee counts only the rows where the first name, the last name and the email are filled in.

The Invitation results window then lists your clients under Sent, Skipped and Failed, with the reason next to each client who was not invited. If 2 invitations failed, the window shows Retry failed (2): click it to put those clients back in the table, then click the send button again. Click Add more clients to import another file, or Done to close the window.

Each client under Sent gets the invitation email and appears in the Invitations tab of your client list.

Good to know

  • Column names also work in French or with spaces, for example "first name", "prénom", "nom" or "e-mail".
  • The lang column accepts en, fr, es, de, pt and it. An empty cell or any other value takes your own language, and you can change it in the Lang cell of the row.
  • You can send up to 200 clients at a time. For a longer list, split it into several files.
  • If you do not see Import CSV, your role in the team does not let you invite clients. Ask the person who manages your workspace.

Was this article helpful?

Still need help?

Our team and Dwayne, the Gymkee AI assistant, are here for you.

Ask Dwayne