Novità: un assistente AI che risponde con i dati reali della tua palestra. Scopri

Switch from a spreadsheet to MoveMembers

Your member list already exists, in a spreadsheet. This page says what the import screen takes from it, what a person moves for you, for free, when it does not, and how to switch without losing a week.

Who should not switch

A spreadsheet costs nothing, you know it by heart, and for some gyms it is the right tool. Three honest cases.

A handful of members, all paying at the desk

If nobody books ahead, nobody needs a reminder and everyone pays you in person, the spreadsheet does the job. Switching would cost you an evening for a difference you would not notice.

Your spreadsheet is also your accounts

If the file holds your bookkeeping, your coaches' pay or formulas built over years, none of it is imported: MoveMembers reads a list of members, not formulas or extra tabs. If those tabs are what keeps you running, keep them.

You are in your busiest weeks

A switch needs one quiet evening to check the import and one week of attention at the desk. Do not do it the week of an opening, a camp or a grading. Pick a quieter week and come back then.

What the import screen reads, and what we move for you

Checked against the import screen as it works today. What it does not read, we bring across for you as part of the free migration.

DataImportedWhat to know
NameYesOne Name column, or First name and Last name, joined in the order you choose.
Email and phoneYesThe apostrophe Excel puts in front of a number is removed. The country code is not added for you: write it in the file.
Join date, birthdate, notes, tagsYesWithout a join date column, members are recorded as joining on the day of the import.
Current planYesStart date, end date, total credits, credits left and status. The plan name must match your catalogue, or the import can add it there, without a price.
Class timetableYesFrom a second CSV file, in Classes. Coaches named in the file must already exist in MoveMembers.
Attendance historyNoNot read by the import screen. Send it to us and we bring it across, for free.
Past payments and receiptsNoA Paid column only marks the current plan as settled. Send us the rest and we bring it across.
Belts, disciplines, levelsNoNot read by the import screen. Send them to us and we bring them across, or set them on each profile.
Emergency contacts, guardians, photosNoFilled in on each profile afterwards, or sent to us and brought across.
Signed waiversNoThe import screen marks no waiver as signed. Send us your signed copies and we bring them across.
Upcoming bookingsNoMembers book again as soon as the timetable is live, or we bring their bookings across for you.
Bank cardsNoSee the section on cards below.

Bank cards: none come across

A spreadsheet holds no card, so there is nothing to move, and MoveMembers imports none.

Monthly card auto-pay exists, but it is the member who sets it up from their own space, and only once you switch it on. Members otherwise pay online when they buy, through your own Stripe account, or at the desk in cash or by transfer, recorded in a few seconds.

Online payments land directly in your Stripe account. MoveMembers takes no commission on them; only Stripe's own fees apply.

Prepare your spreadsheet

The import reads a CSV file: one line of headers, then one line per member.

  • Start from the template. Members › Template downloads the headers the import recognises, with your own plan names in the example row. The headers stay in English on purpose: do not translate them.
  • Keep one line per member. Two lines with the same email become one member, so a couple sharing an address needs two addresses.
  • Write each date column in one format. Year-month-day (2026-09-01) can never be misread. If every day in the file is 12 or under, the import asks you which order the dates use.
  • Write plan names as they appear in your catalogue. Upper and lower case do not matter.
  • Put the country code in front of phone numbers, for example +66.
  • In Excel: File › Save As › CSV UTF-8. In Google Sheets: File › Download › Comma-separated values (.csv).
  • In MoveMembers, open Members › Import, match the columns, read the review screen, then confirm. Nothing is written before you confirm.

Switch day

Ten points, in order.

  1. 01

    Pick the day: a Monday in an ordinary week, not the first day of a promotion.

  2. 02

    The evening before, stop writing in the spreadsheet. Save a copy and name it as the archive.

  3. 03

    Create your plans in the catalogue before importing, with their real prices.

  4. 04

    Fill in the template, save it as CSV UTF-8 and import it.

  5. 05

    On the review screen, read the ignored columns, the date format and the rows that share an email.

  6. 06

    Open ten profiles at random and compare them with the spreadsheet.

  7. 07

    Import or build the timetable, and open one week of classes.

  8. 08

    Take one real payment at the desk and check the receipt.

  9. 09

    Send the message below to your members, in the channel they actually read.

  10. 10

    Keep the archived spreadsheet read-only for a month before you put it away.

The message for your members

Ready to copy. Replace what is in brackets before you send it.

Hi [first name], From [date], [gym name] runs bookings and memberships in a new app. Your membership has been carried over. To book your classes: [link to your member space] Nothing changes at the desk: you can still pay there as usual. If anything on your account looks wrong, reply to this message and we will fix it. [gym name]

Domande

Questions before you import

Can I import an Excel file (.xlsx) directly?
No. The import reads CSV files. An Excel workbook dropped in as it is gets recognised and refused, with the fix: in Excel, File › Save As › CSV UTF-8, then import that file. Commas, semicolons and tabs are all read as separators, and the text encoding is detected.
What happens if I import the same file twice?
Nothing is duplicated. Each line is matched to an existing member by ID, then email, then phone, and that member is updated instead of created again. A plan with the same start date is not added a second time. Columns your file does not carry leave the profile as it was.
How many members can one file hold?
Up to 5,000 lines per import. A bigger file is refused with its line count rather than cut short in silence: split it in two and import both, one after the other.
I have more members than my plan covers. Will the import stop?
No. Everything is imported, and the review screen tells you beforehand how many members go past your plan, and until which date. Past 20 active members, everything keeps working until 30 days after your first import. After that, adding members by hand pauses until you archive the ones who stopped coming or move to Pro, and everything else keeps working.
The plan names in my spreadsheet do not exist in MoveMembers. What happens?
The review screen lists them before anything is written. A tick box adds them to your catalogue with no price, so the memberships are kept, and you set the prices afterwards. Without it, those members are imported without those memberships. Adding plans needs the permission to change settings.
Can I undo an import?
Yes, for 24 hours. Undo the last import, in the Members import and export menu, removes the members and plans that import created. A member who has since booked or paid is listed first, and you decide. Members that already existed and were only updated keep their new values.

Two ways to go from here

See it with a sample gym

The live demo opens the software itself, filled with a sample gym. No signup.

Ask before you switch

Email us or message us on LINE with your questions about your file. Describe its columns: there is no need to send us your member list. Something specific in your spreadsheet? Tell us, we find a way.

What we commit to

  • No contract when you sign up online: plans run month to month, cancel anytime.
  • No commission on the payments your members make.
  • Your data leaves the way it came in: CSV exports of members, payments and plans in Settings › Data & history, on every plan.

Gestisca i corsi di domani con MoveMembers.

Apra il suo account in due minuti. Max è suo per 14 giorni. Nessuno la chiamerà.

  • 14 giorni di Max gratis
  • Senza carta di credito
  • Nessuna chiamata commerciale
  • Trasferiamo i Suoi membri gratuitamente