Migrating from Excel and paper to a real PMS without losing your mind

Almost every clinic we onboard has the same starting point. A patient register in Excel, sometimes two or three Excel files maintained by different staff. A WhatsApp group for appointments. A physical receipt book. A pile of consent forms in a cupboard. And the doctor's personal phone, which has years of patient conversations on it.

This works, in the sense that the clinic is functioning. It does not scale, and it does not survive a staff change.

This post is the playbook for migrating off this setup, written for clinic owners. There are three honest pacing options. Pick the one that matches your appetite for change.

The three migration paces

Fast (3 weeks): only the future matters

You bring over: nothing historical. From day one of week one, all new appointments, patients, treatment plans, and payments go into the new system. The old Excel is frozen and kept as a read-only archive. If you need to look up a patient from before the cut-over, you open the spreadsheet.

This is the right pace for clinics that have been running for less than 3 years, or where most active patients have been seen recently and will be re-registered organically.

Medium (5 weeks): active patients only

You bring over: every patient who has had an appointment in the last 18 months. Their basic record (name, phone, age, allergies, last treatment, balance owed). Older patients stay in the Excel archive.

This is the right pace for most clinics. It captures everyone who is operationally relevant without trying to digitise five years of inactive history.

Slow (8 weeks): everything

You bring over: every patient ever, every old treatment, every consent, every payment record. Including the cupboard of paper forms.

This is rarely worth it. The cost is high (someone is doing data entry for two months) and the value is low (most of those records will never be touched again). The case for this pace is regulatory: if you operate in a state that requires a 7-year retention policy and you cannot rely on the paper, you may need to digitise.

For 90 percent of clinics, the answer is medium pace.

The migration checklist (medium pace, 5 weeks)

This is the version we have run with dozens of clinics. Adjust the dates to your situation.

Week 0: prep

• Decide who owns the migration. One person. Not the doctor (who has clinical work). Not the front desk (who has patient flow). Ideally a coordinator or a senior staff member with 2 to 3 hours per day to spare.
• Take a hard look at your Excel files. Note: how many patient records, how dirty the data is (missing phone numbers, duplicates, inconsistent name formatting), how many fields you actually use.
• Pick a cut-over date. Friday after work is good. Two weeks of patient flow under the new system before you stop using Excel for anything new.
• Tell the team. The team always finds out at the wrong moment when they are not told first. Block 30 minutes one morning, explain what is happening, set expectations.

Week 1: data cleanup in Excel

This is the unglamorous bit. The temptation is to skip it and "clean it up in the new system". This is always a mistake. Cleaning in Excel is 3x faster than cleaning in any PMS.

• Standardise phone number formatting. Strip country codes if some have them and some do not. Pick one convention.
• Remove duplicates by phone number. Almost every spreadsheet has them. Collapse manually.
• Fill or mark missing required fields. Name, phone, last visit, balance. If a row cannot have these filled in, mark it for archive (not migration).
• Export a clean CSV. This is what gets imported.

Week 2: import and audit

• Import the cleaned CSV into the PMS.
• Audit a 5 percent random sample. Pick 1 in 20 records, open them in the PMS, compare with the source row. Look for: dropped fields, garbled characters in non-English names, wrong phone-number formatting.
• Fix the import script if there is a systematic issue. Re-import. This is normal. Almost every migration has at least one round of "wait, the dates came in wrong".
• Spot-check pending balances. These are the rows your patients will notice if they are wrong. They must match.

Week 3: parallel running

• Front desk uses both systems for one week. Every new appointment goes into both Excel and the PMS. Yes, double work. Yes, just one week.
• This is the test. Does the new system actually handle the patient flow? Are there workflows you do that the new system does not support? Find out now, not at cut-over.
• Daily 15-minute team check-in: what is annoying, what is missing, what is broken.

Week 4: cut over

• End of week 3 (Friday): freeze the Excel. From Monday morning, only the PMS.
• Hold a 30-minute team meeting on Monday. Reaffirm the rules. Front desk uses the PMS. Doctor uses the PMS. No more "let me just put it in Excel for now".
• The first week will feel slower. By the end of the second week, it will feel faster than Excel ever was.

Week 5: lock in habits

• Run a "what is broken" debrief at the end of week 5. Fix the top 3 issues.
• Decide what to do with the Excel archive. Most clinics keep it as a read-only file, locked, in case they need to look up a pre-migration patient. Some upload it to the PMS as a static document attached to a "legacy" patient record.
• Migrate the WhatsApp group conversations only if there is a legal or clinical reason to. Usually there is not.

Things that always go wrong

These will happen. Plan for them.

• Phone numbers get re-formatted weirdly. Test this aggressively before going live.
• One staff member resists. Always one. The fix is rarely persuasion. The fix is making the new workflow obviously easier than the old one.
• The first week feels chaotic. It is. It will normalise. Do not roll back.
• A patient walks in claiming they were promised a discount that is not in the system. Have a clear policy: front desk can honour it, mark a note, and the doctor reviews the next day.
• A printer or label printer refuses to talk to the new system. Plan for an extra hour with whoever sets up your hardware on cut-over day.

What success looks like

By the end of month 2, the team should be unable to imagine going back to Excel. By month 3, you should be able to pull a patient record in 5 seconds, run a basic revenue report in under a minute, and know exactly which patients are overdue without anyone having to remember.

If you are not there by month 3, the migration was incomplete. Identify what people are still working around (usually one specific report or one specific workflow) and finish that piece.

The decision that matters

The hardest part of this is not technical. It is committing to the cut-over date and not flinching. Clinics that hesitate end up running parallel systems for months and getting the worst of both worlds. Set the date, prep properly, run parallel for one week, and then close the Excel. The discomfort lasts about 14 days. The new operational floor lasts forever.