UsefulDesk
Start 14-day trial

Gym member register in Excel, free to download.

Plans, expiry dates, days left and fees due for every member, in Excel, CSV or a page to print. No sign-up.

Start 14-day trial Download the Excel file

Download the member register

Free, with no sign-up or email.

What’s in the register

The details you need to see who is due and who owes.

  • Name, mobile and member ID

    The mobile number the member uses on WhatsApp, and your own member number if you have one.

  • Plan, start and expiry date

    Pick the plan from a dropdown of your plans, kept on the Plans sheet.

  • Days left

    Works itself out from the expiry date. Plans ending within a week are shaded.

  • Fee, amount paid and amount due

    Amount due works itself out, so a part-payment is never forgotten.

  • Payment mode and date

    Cash, UPI, Card or Bank transfer, and when they last paid.

  • Trainer, birthday, gender and notes

    Optional. Leave out what you don’t use.

Keeping a member register that works

  • One row per member

    When a member renews, update their row instead of adding a new one.

  • Always write the expiry date

    The joining date alone doesn’t tell you who is due. The expiry date does.

  • Check days left every Monday

    Sort by days left and message everyone whose plan ends this week.

  • Write the full mobile number

    Ten digits, the number the member uses on WhatsApp, so a reminder reaches them.

From this register to UsefulDesk

The headings match UsefulDesk’s import, so a filled-in register imports as it is. Or let our team do it for you, free.

  1. Fill in the register

    One row per member, with at least the name, mobile, plan and expiry date.

  2. Upload it

    In UsefulDesk, go to Members, then Import, and upload the file.

  3. Check the columns

    UsefulDesk recognises these headings and matches them for you to check.

  4. See who is due

    Your plans are matched or added, and you can see who is due this week.

Questions

Is it free? Do I need to sign up?

It is free. There is no sign-up and no email address to give.

Can I use it in Google Sheets?

Yes. In Google Sheets, choose File, then Import, and upload the Excel file or the CSV. The Excel file keeps its dropdowns and the days left and amount due columns.

How do I see whose membership ends this week?

Look at the Days left column. Plans ending within a week are shaded, and a number below zero means the plan has ended. Sort or filter the column to bring them to the top.

What do I do when a member renews?

Change the start date, expiry date, fee and payment on their row. One row per member keeps the register short and easy to check.

Can I add my own columns?

Yes. Add them after Notes. Keep the headings in the first row as they are, so the sheet still imports cleanly into UsefulDesk.

Can I move this register into UsefulDesk?

Yes. Save the file and upload it in UsefulDesk under Members, then Import. UsefulDesk recognises these headings, so the columns are matched for you to check, and your plans are matched or added as new ones.

I keep a paper register. Can you move it for me?

Yes, at no charge. Send us your Excel sheet or a photo of your register, and give our team access from Settings. We’ll add your plans and members and get your reminders ready.

Stop checking the register for who is due.

Fourteen days free. Import this register and see who is due this week.

Start 14-day trial