Getting Your Clientele Out of a Notebook, Your Phone, or a Closed Booking System
For anyone whose clientele exists but sits somewhere unusable. How to pull names out of paper, phone contacts, Instagram messages or a system with no export, and what it shows you once you have.
This is for the point at which your clientele has outgrown wherever you first wrote it down. It arrives about a year into starting from scratch, and immediately for anybody who has just gone out on their own with a book they built somewhere else.
Most owners have a clientele. Far fewer have one they can use. The names are in a notebook, scattered through a phone, or sitting in a system with no export button, and none of that can tell you who is due next week or who has quietly stopped coming.
The destination in every case is the same: one spreadsheet, four columns, saved as CSV. Name, mobile, last service, last visit date. Everything below is how to get there.
If it is on paper
The only real option is typing, and the way to make it bearable is to stop trying to do all of it.
Work backwards from the most recent pages rather than forwards from the start. Your last six months contain nearly everybody still active, and the further back you go the higher the share of people already gone. Enter the recent ones, stop when the names stop being familiar, and treat the rest as archive.
An hour a day for a week gets most people through several hundred clients. One long sitting almost always ends in abandonment somewhere around name eighty.
If the handwriting is clear, photographing pages and using your phone's text recognition speeds it up, though it makes errors on names and numbers and everything needs checking.
If it is in your phone contacts
Better, because phones export. Both iPhone and Android can produce a contacts file, usually as vCard rather than CSV, which needs converting.
The real problem is that your contacts also hold your dentist, your sister and a plumber you called once, so the export is a starting point rather than a list. Export everything, sort by name, delete the obvious non-clients. Tedious, still far faster than paper.
Check the number formats before you start rather than after cleaning four hundred rows. Mixed formats break imports.
If it is in Instagram or Facebook messages
The hardest, and worth being realistic about.
Both platforms let you request a data download including message history, but what arrives is a compliance archive rather than anything usable, and extracting a client list from it is genuinely painful.
For most people the better move is forward rather than backward. Put a booking link in your profile so future enquiries arrive structured, and message your active clients once asking them to book through it. You lose the archive and gain a system, which is the better trade. If you do want history, limit yourself to recent conversations. The people you messaged last month are the ones still worth having.
If your booking system has no export
Check before concluding there is none. Exports are often present but buried under reports, clients or account settings, and sometimes restricted to a higher plan tier. Support will usually tell you directly.
If there genuinely is none, you are left with what you can see on screen, and working through the client list manually is slow but finite. Depending on where you are, data protection rules may give you a right to obtain data held about you, though how that applies to a business account and to your clients' details rather than your own is not straightforward.
The broader lesson is worth taking now rather than later. A system you cannot get your own client list out of is a system that owns your business. Whatever you move to, check the export works before you depend on it.
Cleaning it up
- Inconsistent phone formats. Pick one and apply it everywhere.
- Names in one column versus two. Decide before you start, not halfway.
- Duplicates, especially from phone exports where somebody exists twice.
- Missing numbers. A client with no contact detail is a memory, not a list entry. Park those separately.
- Mixed date formats, which is the worst because the import appears to work and produces nonsense.
Sort by number to find duplicates. Sort by date to find where your list stops being current.
What the list shows you that the notebook never did
This is the reason the afternoon is worth it, and it is not about tidiness.
Sort by last visit date and two groups appear that you could not see before. The clients who are due in the next couple of weeks, who are cheap to keep if you reach them now. And the clients who are well past their normal rhythm and have quietly gone, who almost every owner underestimates the number of.
That second group is usually the biggest single pot of recoverable revenue in a small service business, because those people already know you and already liked the work. They did not leave. Nothing prompted them and nothing noticed.
A notebook cannot show you that. It records what happened, not what stopped happening, which is why the absence is invisible until the diary is thin.
Where Plebco fits
Plebco imports a CSV directly, which is why the destination above is a spreadsheet rather than anything more elaborate. Once the list is in, it tracks each client's own rhythm rather than treating everybody as one group: reminders before appointments, a nudge when somebody is due, and a message when a regular falls behind their normal gap.
The booking page is free, so new clients arrive already structured instead of joining the pile you just spent a week digging out. Your data exports as CSV whenever you want it, for the reasons above.
See how it works, or read how to win back the clients your list just surfaced.
Where these numbers come from
This article describes general data-handling practice. Where it refers to rights to obtain data, application varies by jurisdiction and by whether the account is personal or business.