Coachful
Coachful
ToolsBlogContact
Sign in
Guides
November 6, 202628 min

Client Tracker Spreadsheet for Coaches: Columns and Formulas

Client Tracker Spreadsheet for Coaches: Columns and Formulas

Yes, you can run a coaching practice from a client tracker spreadsheet, and for the first ten or fifteen clients it often works well. This guide gives you the full build for Google Sheets or Excel: five tabs, every column with its type, the status values, the formulas for sessions left, renewal date, revenue per client and days since last contact, the conditional formatting rules, the sharing settings, and a 20-minute weekly review that keeps the sheet honest. You can copy every block below straight into a blank file.

The other half of the answer matters just as much. A spreadsheet records what happened; it does not book the session, take the payment, send the reminder or ask the client how their week went. The strain usually shows once the roster passes what you can review in one sitting, or the first time they add a payment plan, a group program or a second coach. When that happens, Coachful is the purpose-built option: booking, payments, contracts, programs, check-ins and the client record live in one account, and your clients are imported for you during onboarding. We make Coachful, so read the limits section with that in mind; the build guide itself works whatever you decide.

What does a client tracker spreadsheet need to do for a coach?

It needs to answer five questions in under a minute: who is active, who is running out of sessions, who is due to renew, who owes money, and who has gone quiet. Everything else in the sheet exists to feed those answers.

A generic sales CRM template tracks deals. A coaching practice tracks relationships that run for weeks or months, with a fixed number of sessions, a start and end date, and a real risk that a client drifts away halfway through. The table below lists the jobs a coaching tracker has to do and how well a spreadsheet handles each one.

JobCan a spreadsheet do it?Workaround in the sheet
Keep one row per client with contact details and packageYes, wellClients tab with a Client ID column
Count sessions used and sessions leftYes, if every session is loggedSessions log tab plus a COUNTIFS formula
Show renewal and end datesYesStart date plus package length formula
Track payments and balancesPartly: records them, cannot collect themPayments tab you update by hand from your processor
Flag clients who have gone quietPartly: only from contact you logDays since last contact plus conditional formatting
Book sessions and sync calendarsNoA separate booking tool, then copy the date in
Send reminders and check-insNoCalendar reminders to yourself, manual messages
Give clients their own viewPoorlyA separate file per client, shared one by one
Store contracts and signaturesNoA link column pointing to a signed PDF in a private folder
Work for a team with different permissionsPoorlyProtected ranges and separate files per coach

If most of your work is the first five rows, the sheet will serve you. If the bottom five are where your hours go, keep reading the build anyway, because the structure below is also the cleanest way to prepare your data for a move later.

Google Sheets or Excel: which should you build it in?

Build it in whichever you already open every day. Both handle every formula in this guide; the differences are in sharing, mobile use and how tables fill formulas down.

  • Google Sheets lives in the browser, works with a free Google account, keeps version history automatically and shares by email address. As listed in November 2026, Google's help center caps a spreadsheet at up to 20 million cells or 100 MB, far more than a coaching roster will ever use (Google Drive help center, "Files you can store in Google Drive"). Dropdowns sit under Insert > Dropdown; conditional formatting under Format > Conditional formatting.
  • Excel works on the desktop and on the web, and its Tables feature (Insert > Table) copies formulas down automatically when you add a row, which removes the most common spreadsheet error. Dropdowns sit under Data > Data Validation > List; conditional formatting under Home > Conditional Formatting > New Rule > Use a formula. Save it to OneDrive or SharePoint if you want version history and controlled sharing.

Every formula below uses functions that exist in both: COUNTIFS, SUMIFS, MAXIFS, VLOOKUP, IF, IFERROR and TODAY. MAXIFS needs Excel 2019 or Microsoft 365; older desktop versions do not have it.

Thinking of launching your coaching business?

Answer a few questions and Coachful builds it around you: your website, programs, booking and payments. Ready in minutes.

Build your platform

How do you build the client tracker spreadsheet, step by step?

Create one file with five tabs in this order: Lists, Packages, Clients, Sessions, Payments. Add a sixth tab called Review once the rest works. Keep the order, because later tabs look up values from earlier ones.

Step 1: the Lists tab (your dropdown values)

Put each list in its own column with a header in row 1. Every dropdown in the file points here, so changing a value once changes it everywhere.

Column A: Status
Lead
Onboarding
Active
Paused
At risk
Renewal due
Completed
Alumni

Column B: Session type
1:1 session
Group session
Check-in call
Async message

Column C: Payment method
Card
Bank transfer
Payment plan

Column D: Source
Referral
Instagram
LinkedIn
Podcast
Website
Past client

Eight status values is the practical maximum. Fewer than five and you lose the difference between a paused client and one who has drifted; more than eight and nobody applies them consistently.

  • Lead: had a discovery call, has not paid.
  • Onboarding: paid, first session not yet held.
  • Active: in a package and attending.
  • Paused: agreed break with a restart date in Notes.
  • At risk: missed sessions or no contact for 14 days or more.
  • Renewal due: package ends within 21 days.
  • Completed: package finished, no renewal yet.
  • Alumni: finished and not expected back soon; keep for referrals and testimonials.

Step 2: the Packages tab

One row per offer. The Clients tab looks these up, so you type the price and length once.

A: Package name      (text)       e.g. Career Reset 12
B: Sessions included (number)     e.g. 12
C: Length in weeks   (number)     e.g. 16
D: Price             (currency)   e.g. 1800
E: Billing           (text)       Upfront / Monthly / Plan

Step 3: the Clients tab (one row per client)

Freeze row 1 and column B so the header and names stay visible as you scroll. Format date columns as dates and money columns as currency before you type anything.

  1. A: Client ID (text): C-001, C-002 and so on. Never reuse an ID. Every other tab joins on this, not on the name, because two clients can share a name and people change surnames.
  2. B: Name (text)
  3. C: Email (text)
  4. D: Phone (text, so leading zeros and plus signs survive)
  5. E: Status (dropdown from Lists!A2:A9)
  6. F: Package (dropdown from Packages!A2:A20)
  7. G: Start date (date)
  8. H: Sessions included (formula, looked up from Packages)
  9. I: Sessions used (formula, counted from Sessions)
  10. J: Sessions left (formula)
  11. K: End or renewal date (formula)
  12. L: Package price (formula, looked up from Packages)
  13. M: Paid to date (formula, summed from Payments)
  14. N: Balance (formula)
  15. O: Last contact (formula, latest date in Sessions)
  16. P: Days since last contact (formula)
  17. Q: Next session (date, typed or pasted from your calendar)
  18. R: Main goal (text, one line in the client's words)
  19. S: Source (dropdown from Lists!D2:D10)
  20. T: Agreement signed (checkbox)
  21. U: Lifetime revenue (formula)
  22. V: Notes link (link to a private document, not the notes themselves)

Column V is deliberate. Session notes can hold sensitive personal detail, and a spreadsheet is easy to share by accident. Keep the notes in a separate, tightly shared document and store only the link here.

Step 4: the Sessions tab (one row per contact)

A: Client ID          (text, must match Clients!A)
B: Date               (date)
C: Type               (dropdown from Lists!B2:B5)
D: Minutes            (number)
E: Counts to package  (dropdown: Yes / No)
F: Short summary      (text, one line, no sensitive detail)

Log every touchpoint here, including a voice note or a quick check-in message, with Counts to package set to No. That is what makes the days-since-contact column trustworthy.

Step 5: the Payments tab (one row per payment received)

A: Payment date   (date)
B: Client ID      (text)
C: Amount         (currency)
D: Method         (dropdown from Lists!C2:C4)
E: Reference      (text: processor transaction ID or invoice number)

Step 6: paste the formulas

Enter these in row 2 of the Clients tab, then fill down (in Excel, convert the range to a Table first and they fill themselves). They work as written in both Google Sheets and Excel.

H2  Sessions included
=IFERROR(VLOOKUP(F2, Packages!$A:$E, 2, FALSE), "")

I2  Sessions used
=COUNTIFS(Sessions!$A:$A, A2, Sessions!$E:$E, "Yes")

J2  Sessions left
=IF(H2="", "", H2 - I2)

K2  End or renewal date
=IF(OR(G2="", F2=""), "", G2 + VLOOKUP(F2, Packages!$A:$E, 3, FALSE) * 7)

L2  Package price
=IFERROR(VLOOKUP(F2, Packages!$A:$E, 4, FALSE), "")

M2  Paid to date (current package, since start date)
=SUMIFS(Payments!$C:$C, Payments!$B:$B, A2, Payments!$A:$A, ">="&G2)

N2  Balance
=IF(L2="", "", L2 - M2)

O2  Last contact
=IF(COUNTIF(Sessions!$A:$A, A2)=0, "", MAXIFS(Sessions!$B:$B, Sessions!$A:$A, A2))

P2  Days since last contact
=IF(O2="", "", TODAY() - O2)

U2  Lifetime revenue (every payment, all packages)
=SUMIFS(Payments!$C:$C, Payments!$B:$B, A2)

Format O2 as a date and P2 as a plain number, or the sheet will show a date where you expect a count. If you bill monthly packages instead of fixed lengths, replace the K2 formula with =IF(G2="", "", EDATE(G2, 3)) for a three-month term.

Revenue per client sits in column U. For a practice-level view, add two cells at the top of the Review tab: total lifetime revenue with =SUM(Clients!U:U) and average revenue per paying client with =AVERAGEIF(Clients!U:U, ">0").

Step 7: conditional formatting that does the watching for you

Select the Clients range from A2 to the last column and row you expect to use, then add these custom formula rules. Order matters: put the most urgent rule first.

Rule 1  Red fill     =AND($P2<>"", $P2>=14, $E2="Active")
        Active client with no contact for 14 days or more

Rule 2  Orange fill  =AND($J2<>"", $J2<=1, $E2="Active")
        One session or fewer left

Rule 3  Yellow fill  =AND($K2<>"", $K2-TODAY()<=21, $K2>=TODAY())
        Package ends within 21 days

Rule 4  Bold red text on column N
        Money still owed

Rule 5  Grey text    =OR($E2="Completed", $E2="Alumni")
        Finished clients fade back

The 14-day and 21-day thresholds are starting points. A weekly coaching cadence might use 10 days for the quiet flag; a monthly mentoring practice might use 40.

Step 8: views and filters

In Google Sheets, use Data > Create a filter view and save three views: Active now (Status is Active, Onboarding or At risk), Renewals (sorted by column K, ascending) and Money owed (column N greater than 0). Filter views do not change what other editors see. In Excel, use the filter arrows on the Table header, or Sheet View on files stored in OneDrive or SharePoint.

Step 9: the sharing settings

  • Set general access to Restricted in Google Sheets, or share with Specific people in OneDrive. Never use "anyone with the link" for a file that holds client contact details.
  • Never share the master tracker with a client. A client who can open the file can see every other client.
  • Turn on two-step verification on the account that owns the file.
  • If an assistant helps with admin, give them Commenter or Viewer access unless they truly need to edit, and protect the formula columns (Data > Protect sheets and ranges in Sheets; Review > Protect Sheet in Excel).
  • Do not use IMPORTRANGE or linked workbooks to build client-facing views from the master. Whoever can see the destination file can often reach more of the source than you intended.

What should the Review tab and the weekly routine look like?

Twenty minutes on the same day each week is enough. The Review tab gives you counts at a glance, and the routine turns the coloured rows into actions.

Review tab, column A labels and column B formulas

Active clients        =COUNTIF(Clients!E:E, "Active")
At risk               =COUNTIF(Clients!E:E, "At risk")
Renewals in 21 days   =COUNTIFS(Clients!K:K, ">="&TODAY(), Clients!K:K, "<="&TODAY()+21)
Quiet 14+ days        =COUNTIFS(Clients!P:P, ">=14", Clients!E:E, "Active")
Total owed            =SUMIF(Clients!N:N, ">0")
Lifetime revenue      =SUM(Clients!U:U)
Avg revenue/client    =AVERAGEIF(Clients!U:U, ">0")

The weekly routine:

  1. Log the week. Add every session and message from the past seven days to the Sessions tab. Check your calendar against it.
  2. Reconcile payments. Open your payment processor's dashboard and add any payment not yet on the Payments tab, with its reference number.
  3. Work the red rows. For each quiet active client, send a short personal message and set the status to At risk if it is the second week in a row. The guide on managing client drop-off and disengagement has wording that does not sound like a chaser.
  4. Work the orange and yellow rows. Clients with one session left or a package ending within 21 days get a renewal conversation booked, not an email.
  5. Chase balances. One polite note per client with a balance; record the date in their notes document.
  6. Update statuses. Move finished clients to Completed, and Completed clients older than 60 days to Alumni.
  7. Check sharing. Once a month, open the Share dialog and remove anyone who no longer needs access.
A laptop showing a coaching dashboard with a client list on a desk beside a paper planner and highlighters
Coachful's coach dashboard with the demo client list and status indicators, on a laptop beside a weekly planner.

What does a filled-in example look like?

Here is an example for a fictional career coach with 12 clients, as the Clients tab might read on a Friday in November 2026. The names, packages and figures are illustrative, not a rate recommendation; set your own prices from your costs, hours and market.

The example practice has three packages: Career Reset 12 (12 sessions over 16 weeks, $1,800 upfront), Job Search Sprint (6 sessions over 8 weeks, $900) and Leadership Monthly (2 sessions a month, $450 a month).

IDClient (example)StatusPackageSessions leftRenewal dateBalanceDays since contactLifetime revenue
C-001Amira HaddadActiveCareer Reset 1272027-01-14$04$1,800
C-002Ben OkaforRenewal dueCareer Reset 1212026-11-20$06$3,600
C-003Chloe MarshAt riskJob Search Sprint42026-12-03$45019$450
C-004Daniel KimActiveLeadership Monthly12026-12-01$09$2,700
C-005Elena RossiOnboardingCareer Reset 12122027-02-25$02$1,800
C-006Farid NasserActiveJob Search Sprint22026-11-26$03$900
C-007Grace LiuPausedCareer Reset 1252027-01-28$031$1,800
C-008Hannah BergActiveLeadership Monthly22026-12-04$45016$1,350
C-009Isaac MensahActiveCareer Reset 12102027-02-04$05$1,800
C-010Julia SantosCompletedJob Search Sprint02026-10-30$012$900
C-011Kofi AsanteLead8$0
C-012Laura NovakAlumniCareer Reset 1202026-07-09$0112$1,800

Reading it the way the conditional formatting would on that Friday:

  • Red: Hannah Berg is Active with 16 days since contact and $450 owed. That is the first message of the week. Chloe Marsh has already been moved to At risk with 19 days of silence and a half-paid sprint.
  • Orange: Daniel Kim has one session left this month. Ben Okafor is down to the last session, with a renewal date is two weeks away, so he is already marked Renewal due.
  • Yellow: Farid Nasser's sprint ends on 26 November with two sessions left, so those two sessions need booking now.
  • Grey: Julia Santos and Laura Novak are finished. Laura is a good person to ask for a referral; the referral tracking spreadsheet template adds a tab for exactly that.

The Review tab for this example would show 5 active clients, 1 at risk, 2 renewals within 21 days, 1 quiet active client, $900 owed and $18,900 in lifetime revenue, an average of $1,718 across the 11 clients who have paid. Those figures are the example's arithmetic, nothing more.

What the sheet cannot show: whether Chloe went quiet because she got the job, whether Hannah opened your last email, and whether Elena has filled in her intake questions. For progress on goals rather than admin, pair this sheet with one of the coaching client progress tracker templates.

What does the client see, on a phone?

With a spreadsheet, the client sees nothing unless you build them a separate file. That is the part of the DIY setup most coaches underestimate.

The common workaround is one small file per client with their sessions, homework and goals, shared to their email address. On a phone, that means the client installs or opens the Sheets or Excel app, signs in with an account that matches the email you shared to, and pinches and scrolls across columns built for a laptop. Nothing reminds them it exists. You also have to keep each client file in step with the master by hand, which doubles the weekly routine.

Compare that with a client app. In Coachful, the client opens an app with your branding and sees their next session, their program for the week, their habits and check-ins, and documents you have shared. The screens below are from Coachful's demo account.

Client coaching hub showing the next session and tabs for programs, sessions, progress and documents
What a client sees in Coachful's demo: the next session, tabs for Overview, Programs, Sessions, Progress and Documents, and a pre-session task.
Client habits dashboard with habit cards for meditation, exercise, journaling and reading
A demo client's Growing Habits dashboard with habit cards such as Morning Meditation at 12 of 30 days.

If the client view matters to how you coach, the guides on coaching software with a client app and the Coachful client app go further.

Which one looks like you?

Coachful builds your coaching website from a few answers, in a design chosen for your niche, with programs, booking and payments ready behind it.

Build your platform

Where does a client tracker spreadsheet stop working?

It stops working when the sheet has to do something instead of record something. Here are the limits that matter, in the order coaches usually hit them.

Privacy and sharing risk

A spreadsheet has one permission level per file, not per client row. One wrong click in the Share dialog exposes every client at once, and a forwarded link keeps working until you notice. If you coach clients in the EU or UK, the GDPR applies to the names, emails and notes in that file, including the principles of data minimisation and security (overview of the GDPR). Decide how long you keep records and when you delete them; the guide to a client record retention and deletion policy walks through it. Rules differ by country, so check with an attorney where you practise.

Health, fitness and wellness coaches have an extra line to hold: coaching is not medical care, and a tracker is not a medical record. Do not log diagnoses, medication or test results in it. When a client describes symptoms, a new diagnosis or a mental health crisis, refer them to a doctor or licensed clinician and note only that you referred.

Payments

The Payments tab is a copy of reality, typed by you. It cannot charge a card, retry a failed subscription, split a fee into a payment plan or issue an invoice. Every payment exists twice, once in your processor and once in the sheet, and the two drift apart the week you skip reconciliation.

Booking and reminders

The Next session column is only as current as your last copy-paste from the calendar. The sheet cannot offer times, block a slot, detect the client's time zone, create a video link or remind anyone. Missed sessions often trace back to this gap.

Check-ins between sessions

Days since last contact measures your contact, not the client's engagement. A spreadsheet cannot ask a client how the week went, record a habit streak or notice that daily check-ins stopped on Tuesday. The guide to the best client check-in app for coaches covers what that layer looks like.

Mobile

Both Sheets and Excel have phone apps, and both are fine for glancing at a row. Adding a session, selecting from a dropdown in a narrow column or reading 22 columns on a phone between calls is slow enough that coaches start keeping a second list in their notes app, and the sheet stops being the single source.

A team

The day a second coach or an assistant joins, you need per-person views, per-coach availability and permissions that hide notes from people who do not need them. Protected ranges help with formulas; they do not give you a per-row privacy model. Most teams end up with one file per coach and a fragile summary sheet on top.

None of this makes the sheet a bad start. It makes it a recording tool. If you recognise three or more of these limits in your week, the comparison below is the useful next step; the longer roundup of client tracking software for coaches covers more options.

Coachful client overview with populated demo client profiles and activity summaries
Coachful's client overview with demo client profiles and illustrative activity summaries.

What is Coachful, and how does it replace the tracker?

Coachful is a coaching platform built for coaches who deliver programs, not just sessions: solo coaches, coaches growing into a small team, and coaches replacing four to six tools. One subscription covers booking, payments, contracts, program delivery with habits and check-ins, courses, a community, a website with funnels and email, and an AI assistant, with one login for the coach and one branded app for the client. The company is based in Tallinn, Estonia, and is rated 4.5 on Trustpilot from 21 reviews.

Mapped onto the spreadsheet you just built:

  • Clients tab becomes the client record: goals, check-ins, habits, notes, intake answers, tags, payments and sessions in one place, with a status of thriving, active, quiet or at risk, and an AI briefing per client before each session.
  • Sessions tab becomes booking pages with availability rules, buffers, minimum notice and time-zone detection, two-way sync with Google, Apple/iCloud and Outlook calendars, built-in video or automatic Zoom, Meet or Teams links, paid sessions and session credits.
  • Payments tab becomes real payments through your own Stripe Connect or Razorpay account: one-time, subscriptions, payment plans, coupons and refunds, with an invoice per transaction and manual invoices when you need one. Coachful charges a 0% platform fee; only Stripe or Razorpay processing applies.
  • Agreement signed checkbox becomes a coaching agreement with e-signature, sent before the first call and stored on the client record.
  • Days since last contact becomes check-ins and habit tracking the client completes in their app, plus email reminders, SMS 24 hours before and WhatsApp one hour before a session once messaging is enabled.
  • Review tab becomes the analytics view with revenue, client activity and retention.
Coachful coach dashboard showing 29 demo clients with task completion and status indicators
The coach dashboard in Coachful's demo account: 29 demo clients with task completion percentages and status indicators such as thriving and at risk.
Monthly sessions calendar with colour-coded coaching sessions for September 2026
The sessions calendar in Coachful's demo account for September 2026, with 1:1 sessions and accountability calls colour-coded.
Coachful payments tab with an invoice table showing client, amount, status and date columns
Coachful's Payments tab with two sample invoices for a demo program.
Coaching flows library with welcome, morning check-in and evening check-in flow cards
Coachful's coaching flows library with Welcome, Morning Check-in and Evening Check-in flows.

What Coachful does not do, so you can rule it out quickly: it is not HIPAA-certified and offers no BAA, so it is not for clinical record-keeping or insurance billing. There is no PayPal and no permanent free plan. The client app ships under the Coachful listing with your branding, not under your own App Store account. There is no Salesforce or HubSpot integration and no multi-stage sales deal board for large teams.

Pricing is flat and monthly; lower plans cap the number of clients, Pro is unlimited and team plans add coach seats (current plans: Lite: $29/month for up to 5 clients; Solo: $49/month for up to 20 clients; Pro: $99/month with unlimited clients; Studio: $199/month with unlimited clients). For a 12-client practice like the example above, the relevant plan is Solo: $49/month for up to 20 clients. Monthly plans cancel in one click.

Why Coachful stands out: a free white-glove service. From Create > We'll build it for you, you describe what you want and the Coachful team builds it inside your own account, usually within about 24 hours. That can be a website, a funnel, a program, a course outline, an onboarding journey, a form or an email sequence. You can attach up to 8 reference links and up to 10 files, such as your current spreadsheet structure, your package descriptions and your logo. Nothing is invented: no fake credentials, testimonials or prices, and gaps are left for you to fill. It does not cover recording videos, logo design, ad management or ongoing marketing. One recent example: a leadership coach with a Squarespace renewal days away got one clean homepage with a repeated "talk with me" button. More in how the free white-glove service works.

Coachful Create page with the We will build it for you card
The Create page in Coachful with the We'll build it for you card.

To start: open a free trial, then use the white-glove request for anything you would rather not build yourself. Your clients, programs and content are imported for you during onboarding.

Join Coachful now

How does the spreadsheet compare with Coachful and dedicated coaching tools?

Criteria, in one line: one login for the whole client journey, delivery between sessions, total stack cost at 12 clients, and setup effort. Prices are as listed by each vendor in October 2026; the spreadsheet row assumes you already have a Google or Microsoft account.

OptionStarting pricePrice at 12 clientsBooking and remindersPaymentsClient app or portalCheck-ins and habits
CoachfulLite: $29/month for up to 5 clientsSolo: $49/month for up to 20 clientsBooking pages, two-way calendar sync, email, SMS and WhatsApp remindersYour Stripe Connect or Razorpay; 0% platform feeBranded client appYes: habits, morning and evening check-ins, streaks
Spreadsheet (Google Sheets or Excel)No extra cost with an existing accountSame, plus your booking and payment toolsNoRecords onlyA shared file per clientNo
Paperbell$97/mo ($80.83/mo annual)$97/mo, unlimited clientsBooking includedStripe or PayPal; no added transaction fee statedClient portal; mobile browser, no native app (older profile)No goal or habit tracking (older profile)
CoachAccountable$20/mo for 2 active clients$120/mo (Level 3, 20 active clients)Sessions and scheduling includedInvoicing; processor fees applyWeb portal; no native mobile app (older profile)Action plans, metrics and worksheets
Satori$33/mo ($27.50/mo annual) for up to 10 active paying clients$49/mo Pro (older profile: 50 active clients)Scheduling included; no native Zoom integration (older profile)Stripe or PayPal; no Satori feeClient portal; no native mobile app (older profile)Packages and programs
Practice Better$0/mo Sprout for 3 clients$69/mo Professional ($59/mo annual); Starter caps at 10Scheduling includedPractice Better Payments, powered by StripeClient portal; branding from PlusPrograms; aimed at wellness and nutrition practitioners

The spreadsheet looks cheapest until you add the booking tool, the payment tool, the e-signature tool and the messaging app it relies on. The dedicated tools above each cover part of the journey: Paperbell focuses on admin for solo coaches without goal or habit tracking, CoachAccountable prices per active client, Satori caps active clients per tier, and Practice Better is built around wellness and nutrition practices with charting. Coachful is the one that covers the admin and the delivery between sessions under one login.

Paperbell's homepage presenting its all-in-one admin for solo coaches
Paperbell's homepage in October 2026.
CoachAccountable's homepage presenting its coaching back-office software
CoachAccountable's homepage in October 2026.
Satori's homepage presenting its coaching practice software
Satori's homepage in October 2026.
Practice Better's homepage presenting its practice management software
Practice Better's homepage in October 2026.

For the bigger picture of replacing a spreadsheet plus a chat app, see how to replace spreadsheets and Slack in coaching, or the coaching client management software page.

How do you move from the spreadsheet into Coachful?

Clean the sheet, hand it over, rebuild your packages as offers, then invite clients. Your clients, programs and content are imported for you during onboarding, so the work on your side is mostly preparation and decisions.

Here is a short walkthrough of the clients area you will be moving into:

Before the import

  1. Deduplicate. Sort the Clients tab by email and merge any duplicate rows. The Client ID column makes this safe.
  2. Fix statuses. Make sure every row has a status. Leads and Alumni can come across too, which keeps your referral and re-engagement list intact.
  3. Export a clean copy. In Google Sheets, File > Download > Comma-separated values for each tab; in Excel, File > Save As > CSV. Keep the original file read-only as your archive.
  4. Gather the notes. List where each client's notes document lives so it can be attached to the right record.

What you rebuild rather than import

  • Packages become offers with real checkout: one-time, subscription or payment plan, through your own Stripe Connect or Razorpay account.
  • Your availability becomes booking pages with buffers, minimum notice and calendar sync.
  • Your welcome email becomes an onboarding flow, with the coaching agreement sent for e-signature before the first call and intake questions on booking.
  • Your check-in messages become check-ins and habits inside a program, so engagement shows on the client record without you logging it.

If you would rather not build these yourself, the free white-glove request covers programs, onboarding journeys, forms and email sequences. Attach your Packages tab as a file and describe each offer.

What clients notice

They receive an invitation to your branded client app, where their upcoming sessions, program and documents appear. The next booking comes from your booking page rather than an email thread, reminders arrive on their own, and payments go through a checkout instead of a bank transfer request. Tell them in your next session that the change is coming, and send one short message the day you switch so the invitation does not look unexpected.

Running both for a short overlap

Keep the spreadsheet read-only for one full billing cycle. Check each client's sessions left and balance against the new record once, then stop updating the sheet. Running both for longer than a month is how double entry comes back.

Two screens on a table, one showing a client's coaching hub and one showing a monthly session calendar
The client's coaching hub with the next session, and the coach's session calendar, from Coachful's demo account.

What are the most common client tracker spreadsheet mistakes?

Most of them come from treating the sheet as a notebook instead of a database.

  • Joining on names instead of IDs. Two clients called Sam, or one client who marries, and the formulas quietly count the wrong sessions.
  • Typing values into formula columns. One typed number in Sessions left breaks the logic for that row forever. Protect formula columns.
  • Free-text statuses. "active", "Active " and "ongoing" are three different values to COUNTIF. Use dropdowns from the Lists tab.
  • Merged cells and blank rows. Both break filters and sorting. Keep one header row and one row per record.
  • Session notes in the tracker. The more sensitive detail sits in a widely shared file, the bigger a sharing mistake becomes. Link to notes; do not store them.
  • Logging only paid sessions. Days since contact then flags clients you spoke to yesterday by message.
  • Skipping reconciliation. After three weeks without matching the Payments tab to your processor, the Balance column is fiction.
  • Sharing the master with clients or contractors. Build separate files, or move to a tool with per-client access.
  • Forty columns. If a column has not changed a decision in a month, delete it.

For more on structuring what you track, the coaching tracker page and the free progress tracker tool are good next stops.

Frequently asked questions

Is there a free client tracker spreadsheet template for coaches?

The structure in this guide is the template: copy the Lists, Packages, Clients, Sessions and Payments blocks into a blank Google Sheet or Excel workbook and paste the formulas into row 2. Building it yourself takes under an hour and means you understand every formula when something looks wrong.

How many clients can a spreadsheet handle?

Technically far more than any coaching practice needs; Google lists up to 20 million cells per spreadsheet as of November 2026. The practical limit is your time. The weekly reconciliation and copy-pasting grow with every client, and they jump the moment you add payment plans, a group program or a second coach.

Should I track session notes in the spreadsheet?

No. Store a link to a private notes document instead. Notes often contain sensitive personal detail, and a tracker gets shared with assistants and accountants far more often than notes should be.

How do I calculate sessions left automatically?

Log every session in a Sessions tab with a Client ID and a Counts to package column, count them with =COUNTIFS(Sessions!$A:$A, A2, Sessions!$E:$E, "Yes"), and subtract that from the sessions included in the package. The full formula set is in Step 6 above.

Can clients see their own row in a shared spreadsheet?

Not safely. Sheets and Excel share whole files, not rows, so a client with access to the master can see everyone. The workaround is a separate file per client, which you then keep in sync by hand. A client app such as Coachful's gives each client their own view without that maintenance.

Is a Google Sheets client tracker GDPR compliant?

The tool alone does not make you compliant or non-compliant; how you use it does. Restrict access, collect only what you need, set a retention period and be able to export or delete a client's data on request. Requirements vary by country, so check with an attorney if you are unsure.

What is the free white-glove service in Coachful?

It is a build service included on every Coachful plan. You describe what you want, such as a website, funnel, program, onboarding journey or email sequence, attach up to 8 links and 10 files, and the Coachful team builds it in your account, usually within about 24 hours. It does not include recording videos, logo design, ads or ongoing marketing.

Will I lose my spreadsheet data if I move to Coachful?

No. Clients, programs and content are imported for you during onboarding, and you can keep the original spreadsheet as a read-only archive. Coachful also exports your full client data as a ZIP if you ever need it back out.

Does Coachful work for health and fitness coaches who track clinical data?

Coachful is not HIPAA-certified and does not sign a BAA, so clinical records and insurance billing belong in a clinical system. For coaching work it includes a Fitness and Nutrition pack with workouts, nutrition targets, progress photos and weekly check-ins; see the fitness and nutrition page.

Can a team of coaches share one client tracker spreadsheet?

They can, but it gets fragile: everyone with edit access can see and change every row. Coachful's team plans add coach seats with per-coach availability and staff permissions; the page for coaching teams explains how they work.

Join Coachful now
Share

More in Guides

Guides

Spiritual Website Template: 5 Designs and Copy You Can Use

Five calm homepage designs, copy you can paste for every page, the claim and testimonial rules spiritual practitioners trip over, and a builder comparison with dated prices.

Nov 6, 202627 min
Spiritual Website Template: 5 Designs and Copy You Can Use
Guides

Health Coach Website Template: 4 Designs and Copy You Can Use

Four wellness homepage designs, copy for every page with [bracketed] fill-ins, the scope and claims rules health coaches must follow, and a step-by-step build.

Nov 6, 202624 min
Health Coach Website Template: 4 Designs and Copy You Can Use
Guides

90 Leadership Coaching Questions for Every Session

A working bank of 90 leadership coaching questions across ten themes, with a situation table, a four-stage session sequence, a labelled example dialogue and pre-session prompts you can track over time.

Nov 6, 202628 min
90 Leadership Coaching Questions for Every Session

Start Your Coaching
Journey Today

You didn't become a coach to manage 6 apps. Try Coachful free — takes 5 minutes — and watch your coaching business take off.

Elizabeth Gentzkow
Emily Fulcher
John Winders
James Wallace
Salma Mostafa

Built for coaches who take their clients seriously

Elizabeth Gentzkow
Emily Fulcher
John Winders
James Wallace
Salma Mostafa
Christopher Duff
Gilli Moon Aliotti
Margie Wilson
Lakayann Outerbridge
Coachful
Coachful
BlogPrivacyTermsRefundsContact

© 2026 Coachful. All rights reserved.