Home / Guides / Clinic managers and front desk
Clinic managers and front desk
How do you organise patient leads in a spreadsheet?
To organise patient leads in a spreadsheet, use one row per person, a fixed set of columns for source, interest, status and next step, and a weekly review. Keep sensitive health detail out of it.
Enquiries arrive from calls, messages, forms, referrals and walk ins, and they end up in notebooks, inboxes and people's memories. A basic spreadsheet can fix that, if it is set up with some discipline. This guide shows a simple structure that a coordinator can maintain in a few minutes a day.
The direct answer
Create one sheet with one row per person. Use a short set of columns: date, name, contact method, source, interest, status, owner, next step and next step date. Add a dropdown for status so the data stays clean, and review the sheet at the same time every week.
Step 1: Choose the columns
Keep it small. Every extra column is one more thing people skip. A good starter set:
- Date received
- Name and one contact detail
- Source: phone, message, form, referral, walk in, event
- Interest: the service they asked about, in a few words
- Status: a dropdown, see below
- Owner: who is responsible for the next move
- Next step and Next step date
- Contact permission: yes, no or stop
- Notes: short, factual, non clinical
Step 2: Define statuses and stick to them
Use a short list that everyone understands.
- New
- Replied
- Consultation booked
- Attended
- No show
- Treatment started
- Not now, with a date to revisit
- Closed
Lock the status column to a dropdown. Free text creates "interested", "Interested!" and "int" in the same column, and then you cannot filter anything.
Step 3: Enter every enquiry the same day
Make it part of the routine: if it came in, it goes on the sheet before the end of the day. A quick check at close, scanning the missed call list, inbox and message inbox, catches the strays. Without this step the sheet is a partial picture, and partial pictures lead to wrong decisions.
Step 4: Use filters and colours for action
- Filter by next step date equal to today or earlier, so you see what is due or overdue.
- Colour rows with no reply for more than your target time.
- Filter by owner so each person sees their own list.
Start each day by opening the due list. It takes two minutes and prevents the quiet loss of people who were never answered.
Step 5: Weekly review
Once a week, spend fifteen minutes on four questions.
- How many new enquiries came in, and from which sources?
- How many were replied to within our target?
- How many booked, and how many attended?
- Which rows are stuck, and what is the next step for each?
Use only the counts you actually have. The point is to see where enquiries stall, not to produce impressive numbers. Our lead generation page covers how this tracking connects to the rest of the process.
Step 6: Protect patient data
A lead sheet is not a medical record. Keep clinical detail, diagnoses and test results out of it and store those in your proper patient system. Limit access to the people who need it, use a shared drive with sign in, avoid emailing copies around, and follow your local data protection rules. If someone asks you to delete their details or stop contacting them, record that and act on it promptly.
When the spreadsheet starts to strain
A spreadsheet works well at small volume. If you find rows going stale, double entries or people forgetting to update it, an automation can add new enquiries to the sheet and remind owners about overdue next steps. Moving to a booking or customer system is a later step, and it is easier when your statuses are already clean.
Train everyone to use it the same way
A tracker is only as good as the habits around it. Hold a ten minute walk through, show an example row, and agree the rules: same day entry, dropdown statuses, short factual notes, and a next step date on every open row. Put the rules in a note at the top of the sheet. When new staff join, this one page saves repeated explanations and keeps the data consistent, which makes your weekly review far easier.
Common mistakes
- Too many columns. Nobody fills in thirty fields.
- Free text statuses. Use a dropdown.
- No owner. Unowned rows do not get followed up.
- No next step date. Without a date, the row is just a record.
- Several versions of the sheet. Keep one shared master.
- Storing sensitive health details. Keep them out.
- Messaging everyone listed. Only contact people who asked you to, and honour opt outs.
Getting a ready made version
The Clinic Lead Kit includes tracker templates you can copy, along with a manual and message templates. If you would rather have the whole enquiry flow set up and maintained for you, our done for you service can do that, and you can start a conversation here.
Questions people ask
What columns should a patient lead spreadsheet have?
Date received, name, contact detail, source, interest, status, owner, next step, next step date, contact permission and short notes. Keep clinical information out of it.
Is it safe to keep patient leads in a spreadsheet?
It can be, if access is limited, the file sits in a protected shared location, and you store only the minimum necessary details. Follow your local privacy rules and keep clinical data in your proper records system.
When should we move off a spreadsheet?
When volume makes updates unreliable, or when you need automatic reminders and routing. Clean statuses and a clear process now will make any later move much easier.
Want this handled, or want the playbook?
We can set the whole thing up for you, or you can follow the same steps yourself with the manual, templates and trackers.