Excel is how a lot of good clinics started. It’s free, everyone knows it, and on day one it does exactly what you need: a list of patients, a sheet of appointments, a column of who owes what.
Then the clinic grows. Two people edit the same file and one overwrites the other. The appointments sheet has six tabs. The balance column hasn’t matched the cash drawer since March. Someone keeps a separate notebook for the lab. The file lives on one computer, and when that computer is off, nobody knows tomorrow’s schedule.
If that sounds familiar, you don’t need a bigger spreadsheet. You need to move. Here’s a plan that takes about a week without closing the clinic for a single day.
Before you start: decide what moves and what doesn’t
Not everything in your files is worth importing. Be strict:
- Must move: active patients with phone numbers, upcoming appointments, and each patient’s current balance.
- Nice to have: past visit history, treatment notes, insurance details.
- Leave behind: patients with no visit in years and no balance, old price lists, half-finished experiments.
You can always look things up in the old files later. Archive them read-only somewhere safe and keep them for as long as your records policy requires.
Day 1: export and clean the patient list
Put all your patients in one sheet with one row per patient. At a minimum:
- Full name, as the patient would recognise it.
- Mobile number, in the same format for everyone (country code or not, but consistent).
- Date of birth or age, if you have it.
- Gender, if you record it.
Then remove duplicates. Most clinic files have the same patient two or three times, under slightly different spellings or old phone numbers. Sort by phone number and merge rows that match. This is the most tedious step and the most valuable. A clean patient list makes everything after it easier.
Day 2: opening balances
For every patient who owes the clinic money, or has paid in advance, write down one number: the balance today. Don’t try to move years of invoice history. A single opening balance per patient, agreed with whoever handles the money, is enough to start with.
Do the same for labs and suppliers: what you owe each one today.
Day 3: set up the new system
Most of this is a one-time job. In BeClarified, a short setup wizard walks you through it:
- You: your name and email.
- Clinic: name, address (printed on invoices and prescriptions), number of treatment rooms and usual hours. This is the only step you must finish.
- Week: close your days off and set each day’s hours.
- Prices: tick the procedures you offer and type your price.
- Team: add dentists and assistants, or send them an invite to set their own password.
- Logo: for prescriptions, invoices and the patient app.
Everything after the clinic details can be skipped and finished later in Settings. Our setup guide goes through each step in more detail.
Day 4: import
Send the cleaned patient list, upcoming appointments and opening balances to the vendor’s team, or import them yourself if the system allows. With BeClarified, our team imports patients, appointments and balances from your Excel or CSV export for you.
If you track stock, you can paste your current items straight in: name, category, unit, pack size, quantity, unit cost, expiry and the warning level, one row each.
When the import is done, spot-check it. Open ten random patients and compare them with your spreadsheet: name, phone, balance. Check tomorrow’s appointments one by one.
Day 5: train the team on real work
Don’t train on a demo clinic. Train on tomorrow’s actual schedule. Have reception check in the first patients of the day in the new system while the old sheet stays open for reference.
Focus on the four things everyone does every day:
- Booking and moving an appointment.
- Checking a patient in.
- Recording what was done.
- Taking a payment.
Everything else (reports, insurance, labs, payroll) can come in week two.
Days 6–7: run in parallel, then switch
For a day or two, record everything in the new system first and copy only the essentials to the old sheet. You’ll quickly notice that nobody opens the sheet any more. That’s your signal.
Pick a quiet day, usually the start of the week, and make the old files read-only. From now on, the new system is the only record.
Common mistakes to avoid
- Importing everything. Ten years of messy data in a new system is still messy data.
- Switching on your busiest day. Start on a quiet morning.
- Training only the owner. Reception and assistants use it most.
- Keeping both systems “just in case”. Two records means neither is trusted. Set an end date for the old one.
What changes after the move
The first week feels slower. By the third, most clinics notice the difference: the schedule is visible from any device, balances are right without a monthly reconciliation, reminders go out on their own, and the end-of-month numbers take minutes instead of a weekend.
If you’re still deciding which system to move to, start with our guide to choosing dental clinic software, or try BeClarified free from the pricing page.
Frequently asked questions
Can we keep our patient file numbers? Usually yes. Include them as a column in the export and ask for them to be imported with each patient.
What about paper files and X-rays? Don’t scan everything up front. Scan a patient’s records when they next visit, and attach them to their file. Within a few months, your active patients are all digital.
How long does the import take? For a typical clinic with a clean export, a day or two. Cleaning the data is usually what takes longest, which is why it comes first.
Do we need new computers? No. A cloud system runs in a modern browser on the computers you already have, and on tablets and phones.