Why spreadsheets are the default
Almost every medical tourism company starts in a spreadsheet, and there is nothing irrational about that. It is free, everyone knows it, it needs no setup and it works on day one. A CRM has to be configured, learned and adopted; a spreadsheet is ready the minute your first enquiry arrives.
The problem is not that spreadsheets are bad. It is that they become the single source of truth. As records and people multiply, the file stops being a tool that helps and becomes a fragile asset that has to be protected.
Six signs you have passed the threshold
If three of these are true, you are past it:
- "Which one is the latest?" There are several copies on desktops and one was sent over WhatsApp.
- Messages are not in the sheet. To see what was discussed you have to look at a colleague's phone.
- Follow-ups get missed. "I'll call next week" records sit for three weeks; no reminder reaches anyone's screen.
- Reports are made by hand. Monthly conversion takes hours to produce and is calculated differently every time.
- No permissions. Anyone who opens the file sees every patient's phone number, and a departing employee takes a copy.
- Source is unknown. Because you cannot tell which ad produced which patient, budget is allocated on instinct.
Point five is also a legal exposure: health data is a special category under GDPR and KVKK, and holding it in an unprotected sheet carries real liability. See patient follow-up system and security.
Calculating the threshold
The decision is arithmetic, not instinct:
Cost of loss = (monthly leads × share not properly followed) × conversion rate × gross revenue per patient
For a company taking 200 leads a month, failing to properly follow 15% of them, converting at 4%, at €2,000 per patient: 200 × 0.15 × 0.04 × €2,000 = €2,400 a month. That figure is a multiple of any CRM subscription.
Headcount is an independent threshold. Once more than two people touch the same pipeline, you have a coordination need that file sharing cannot solve.
Migrating without losing anything
The technical part is easier than expected; the preparation matters more. In order:
- Clean. Merge duplicates, normalise phone numbers to international format, remove empty rows.
- Fill in source. Write "unknown" where you do not know — never leave it blank. Empty fields quietly corrupt later reports.
- Map statuses. Translate free-text statuses ("interested", "thinking", "hot") into the CRM's fixed list. This step creates most of the value in the migration.
- Import. Use the import module, starting with a 20-record trial run.
- Run in parallel. Two weeks: new leads only in the CRM, open files in both. Then the spreadsheet becomes a read-only archive.
What to watch in the first 30 days
Changing software does not by itself change results; changing measurement habits does. Four numbers for the first month:
- Average first-response time.
- Open records with no next step (target: zero).
- Leads and quote-conversion by channel.
- Open records per consultant — imbalance means the routing rules need work.
All four come from reports. The full measurement framework is in conversion rates.