Turning a Gym Membership Spreadsheet Into a Simple Web App

A neighbourhood gym moved member renewals, attendance and trainer slots out of a shared spreadsheet and into a small web app. What they built, what they skipped and what changed.

Turning a Gym Membership Spreadsheet Into a Simple Web App
Gym floor with weights and equipment

A neighbourhood gym in Whitefield had grown to around four hundred members, and the whole operation still ran on one shared spreadsheet. Renewals, payment status, personal training slots and attendance all lived in different tabs. Three people edited it every day, and at least once a week someone overwrote someone else's changes.

The owners were not looking for gym software with a monthly fee per member. They wanted the spreadsheet they already understood, just without the mistakes. Here is how they approached it.

Deciding what the app actually needed to do

They started by listing the questions staff asked the spreadsheet most often. Whose membership expires this week. Has this person paid. Which trainer is free at 7 pm on Thursday. How many people came in yesterday. Four questions covered most of the daily use, so those became the four screens of the app.

Everything else, like diet plans and body measurements, stayed out of the first version. The owners were clear that a smaller tool used every day beats a bigger tool nobody opens.

Building it without hiring a developer

One of the owners used an AI Web App Builder and described the four screens in plain sentences, along with the columns from the existing spreadsheet. The first draft came with a member list, a renewals view sorted by expiry date, a trainer calendar and a simple check in page for the front desk tablet.

They imported the spreadsheet, fixed a handful of messy phone numbers and duplicate names, and asked for two changes: a colour tag for members expiring within seven days, and a login for each staff member so changes could be traced to a person.

What changed in the first two months

  • No more overwritten data, because each staff member edits only through their own login.
  • Renewal reminders go out on time, since the expiring list is the first thing the front desk sees each morning.
  • Trainer double bookings stopped, because the calendar blocks a slot once it is taken.
  • Attendance numbers are now reliable enough to plan which hours need an extra trainer.

What they would tell another gym owner

Start from the questions your staff ask every day, not from a feature list. Keep your existing data, clean it once, and move it over in one go rather than running two systems in parallel. And give every person their own login from day one, because knowing who changed what removes most of the arguments that a shared spreadsheet creates.

The spreadsheet is still around, but now it is an export they download at the end of the month for the accountant, not the place where the business lives.