How to Move Your Dental Clinic from Paper or Excel to Software in One Week
In short: You can move a dental clinic from paper or Excel to software in a week if you move only active patients. Clean the list on day one, set up the clinic, import patients from a CSV or Excel file, enter upcoming appointments by hand, train staff, then go live with the old files kept for reference.
Most clinics that still run on a notebook or an Excel sheet know it is costing them: a double booking here, a payment nobody wrote down there. They stay anyway, because the move itself looks bigger than the problem: years of patient files, a team that is busy, and no quiet week to do it in.
It is smaller than it looks. The trick is to stop trying to move everything. This article is a seven-day plan, with the checklists you need on each day, built around one rule: move the patients you will see again, and let the archive stay where it is.
Before day one: three decisions (30 minutes)
- Pick a go-live date, about a week away, and tell the team. A date with no deadline slides forever.
- Name one person who owns the move. Not “everyone”. Usually the clinic manager or the front-desk lead, with the dentist deciding the price list.
- Decide what moves and what stays. The rule that works: move patients seen in roughly the last one or two years, plus anyone with an appointment or treatment in progress. Keep the rest on paper or in the old file, and add them when they come back.
Also keep your old system as it is. You are not deleting anything; you are starting to write new things somewhere else.
Day 1: Clean the list
Software is only as tidy as what you put in it. A spreadsheet of patients usually has duplicates, a phone number in three formats, and a column that means different things in different rows. An hour of cleaning here saves days later.
Make one sheet with one patient per row and these columns:
| Column | What to write | Notes |
|---|---|---|
| Name | Full name, or first and last in two columns | The only column that is required |
| Mobile | The patient’s own mobile | Used to detect duplicates and later to send WhatsApp messages |
| Gender | Male or Female (or ذكر / أنثى) | Optional |
| Birth date | 1990-03-14 or 14/03/1990 | Day first, as written in the region |
| If you have it | Optional | |
| City | Optional | |
| Notes | A short administrative note | Not a medical history (see day 7) |
What to fix before moving on:
- One row per person. Merge duplicates. If two patients share a mobile (a parent and child, for example), decide whose number goes on which row.
- Mobile numbers in one format, digits only.
- Remove people you will not see again, or move them to a second sheet to keep.
- Paper files: type only your active patients. Name and mobile are enough to start; the rest can be completed at the next visit.
If the data lives in another program, export it to Excel or CSV first and clean that.
Day 2: Set up the clinic
Create your account (new clinics start on the Basic plan free for 14 days, with no card) and follow the six setup steps on the dashboard. The full walkthrough is in getting started with Synora, in short:
- Add a dentist and make them bookable.
- Add a treatment room.
- Set working hours, so the calendar offers only real times.
- Open a cash register, the drawer your payments will be recorded against.
- Register your first patient (this is where the import takes over).
- Book your first appointment.
Also on this day: start the WhatsApp approval if you want reminders. A reminder template must be approved by Meta, and that is the one step you cannot rush, so submit it now and let it wait while you do the rest. Use the reminder templates as a starting point. Reminders on WhatsApp are part of Basic and Pro; reminders by email work on every plan.
Day 3: Import the patients
On the Patients screen, open Import. The steps are short:
- Download the template and paste your cleaned sheet into it, or use your own sheet as long as it has a name column. Synora recognises common column names in English and Arabic (“Name” / “الاسم”, “Mobile” / “الموبايل”, and so on).
- Upload the file. It accepts Excel (
.xlsx) or CSV, up to 1,000 patients per file. For a bigger list, split it into several files. - Check the preview. Synora shows which columns it understood and the first rows. If a column was ignored, fix its heading and upload again.
- Import. It runs in batches with a progress bar, then lists every row it did not create and why.
Three behaviours worth knowing:
- Duplicates are skipped, not doubled. A patient whose mobile is already in the clinic is not added again, so importing the same file twice is safe.
- A bad row does not stop the others. A row without a name is reported with its row number, and the rest import.
- Your plan’s patient limit applies. The Free plan holds up to 50 patients; once you reach the limit the remaining rows are reported as over the limit. Basic and Pro have no patient limit. See pricing.
Then check it by hand: open ten patients you know well, including your longest-standing and your most awkward. If their names and numbers are right, the import is right.
What the import does not bring
Be clear about this with the team, because it decides what you do on day 7:
- It brings in patients: names, contact details, gender, birth date, city and notes.
- It does not bring appointments, treatment history, X-rays, invoices or unpaid balances.
So the old paper file or sheet stays your reference for history, and you build the new history from the first visit forward.
Day 4: Prices, team and roles
- Price list. Every new clinic gets a starter procedure catalogue in Arabic and English with default prices. These are rough starting figures, not market prices: the dentist should go through it and set the clinic’s real prices. Treatment plans and invoices are built from it.
- Team. On Basic and Pro you invite each person by email and choose their role (dentist, receptionist, accountant). The receptionist’s role can book and take payments but not cancel an invoice or close the cash register, which is what you want. See staff and permissions. On the Free plan there is one account, the owner’s.
- Upcoming appointments. Appointments are not imported, so enter the next two to four weeks of the existing diary by hand. This is the most tedious step of the week, and the most important: it is what makes day 6 safe.
Day 5: Rehearse and train (1 to 2 hours)
Do a dry run with the whole team before real patients are involved. Book five pretend patients through their whole journey:
- Book an appointment in the calendar.
- Mark the patient arrived, seated, done.
- Take a payment on the invoice, in cash and by card.
- Move one appointment and cancel another.
- Close the day’s cash register.
Each person should do the part they will do for real: the receptionist books and takes payment, the dentist opens the file and the chart. Write down every question; the list becomes a one-page cheat sheet by the front desk.
Two practical points. Synora runs in the browser and needs an internet connection: its offline mode (Basic and Pro) covers only a saved schedule and arrival check-ins, so agree on a backup, such as a phone’s hotspot. And decide now who covers when the person who knows the system is off.
Day 6: Go live
On the go-live morning:
- Everything new goes into the software: new bookings, new patients, every payment.
- The old system is read-only. Look things up in it; write nothing new.
- A short huddle first thing, and a second five minutes at lunch for what went wrong.
- Keep the cheat sheet at the front desk.
Resist the temptation to keep both going “just in case” for weeks. Two diaries are how appointments get missed. One week of overlap at most.
Day 7: Review and close the first day properly
- Close the cash register and compare it to what is physically in the drawer. Closing the day is part of Synora’s billing.
- Complete patient files at the next visit. The import brought contact details only, so medical alerts such as allergies and conditions must be entered into each patient’s medical history when they next come in, not left in a notes cell. Make it part of the check-in routine for the first month.
- List the unpaid balances from the old system on one sheet. They are not imported, so collect them as patients return and record the payments going forward. Ask your accountant how to treat them in your books.
- Review the week: what slowed you down, what should be set up differently?
When this is a bad week to move
- During a holiday rush or your clinic’s busiest season.
- With the one person who knows the plan away.
- If the clinic cannot get dependable internet during opening hours. Fix that first.
Check the comparison first, if you are still unsure
If you are not sure software is worth it yet, read a notebook, Excel, Access or clinic software?. And if you are comparing programs, 10 questions to ask before choosing will keep you honest.
Try it on a real week
Synora’s trial gives you the full Basic plan for 14 days with no card, and then the Free plan if you do not pay, so you can run this seven-day plan without paying and decide afterwards. Nothing is deleted when a clinic moves to the Free plan; its limits are on the free plan page.
Quick questions
Can I import appointments or treatment history?
No. The import brings patients only. Enter upcoming appointments by hand and keep the old file for history.
Can I import from my current dental program?
Only through a file. Export your patients to Excel or CSV from the old program, then import that file. There is no direct connection to other software.
How long does the import take?
A clean file of a few hundred patients imports in minutes. Most of the time goes into cleaning the list and checking the result, not into the import itself.
What if my list is longer than the Free plan allows?
The rows over the limit are reported, not lost, and the rest import. Either start with your most active patients and add the others as they return, or use Basic or Pro, which have no patient limit.
Do I have to stop using the old system immediately?
Stop writing in it on go-live day. Keep it for looking things up until the new history catches up.
Next: Getting started