Gym attendance sheet in Excel, free to download.

Mark each visit, count visits per member and see who hasn’t come in for 10 days, in Excel or on paper. No sign-up.

Download the attendance sheet

Free, with no sign-up or email.

What’s in the sheet

A month of visits, and who has stopped coming.

  • A month at a glance

    Type the month once, and the dates and weekdays fill in, 28 to 31 days.

  • One P per visit

    Type P in a member’s row on each day they come in. Marked days are shaded.

  • Visits this month

    Counted for each member, so you can see who comes often and who rarely does.

  • Last visit and days since

    Days since turns bold once a member hasn’t come in for 10 days or more.

Using attendance to keep members

  • Mark at the door

    Mark members as they walk in, not at the end of the day from memory.

  • Check days since every week

    Sort by days since and call everyone at 10 days or more.

  • Look for zero visits

    A member who paid but hasn’t come in this month needs a call before renewal time.

  • One sheet per month

    Copy the sheet for each new month and keep last month’s for comparison.

Attendance in UsefulDesk

Check members in at the desk by name or Member ID, see the visits left on packs, and see who hasn’t come in for 10 days or more. Attendance in UsefulDesk.

Questions

Is it free? Do I need to sign up?

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

How do I mark attendance?

Type the month at the top, then type P in a member’s row on each day they come in. Visits, last visit and days since fill themselves in.

How do I start a new month?

Copy the sheet: right-click its tab, choose Move or Copy, then Create a copy. Change the month and clear the marks. Keep one sheet per month in the same file.

Why 10 days?

A member who hasn’t come in for 10 days or more is often about to drop off, and a call can still bring them back. UsefulDesk uses the same 10 days for its At risk list.

Can I use it in Google Sheets?

Yes. In Google Sheets, choose File, then Import, and upload the Excel file. The visit counts and the days since work there too.

Can I bring this attendance into UsefulDesk?

No. UsefulDesk keeps attendance from each member’s first check-in in UsefulDesk. Bring your members in with the free member register, and attendance starts from your first day.

See who stopped coming without adding up the register.

Fourteen days free. Check members in at the desk, and see who hasn’t come in for 10 days or more.