Bulk import appointments
Import a whole day, week, or month of appointments at once from a spreadsheet β instead of typing them in one at a time. The flow has four steps; this guide walks through each.
Works with any spreadsheet that has the four required columns (patient name, phone, appointment
date, appointment time). Designed especially for Open Dental exports, which Anashi recognizes
automatically. Accepted formats: .csv, .xlsx.
Maximum size: 20 MB. Maximum rows: 5,000.
Step 1 β Upload your file
From the Appointments dashboard, click Import appointments (top right). A modal opens at Step 1 of 4.
Pick your file and click Upload & continue. Anashi parses it and moves you to Step 2. No rows are saved yet β you can still back out at any time.
Step 2 β Map your columns to Anashi fields
Anashi shows your file at the top (name, row count, column count) and tries to auto-detect which column matches which field. Fields with a green auto tag were detected for you β fields without it need a manual selection from the dropdown.
Required fields
These four must be mapped before you can continue.
Optional fields
Leave any unmapped β defaults will be applied automatically.
What each field is for
| Field | Required? | Notes |
|---|---|---|
| Patient name | Required | Used by the AI when speaking to the patient. |
| Phone number | Required | The number the AI dials. If your file has multiple phone columns (Cell, Home, Work), Anashi will prefer Cell automatically. |
| Appointment date | Required | The day of the visit. |
| Appointment time | Required | The time of the visit. |
| Preferred call time | Optional | The hour the AI should call this patient. Defaults to 10:00 AM. Will be respected within your clinic's open hours. |
| Language | Optional | Language the AI speaks to the patient. Defaults to English. |
| Patient note | Optional | Read aloud to the patient by the AI during the call (e.g. "Bring ID"). You can also type it per row in Step 3. |
| Patient number (PatNum) | Optional | Reference only β lets staff look the patient up in Open Dental. Not used by the AI. |
| Description | Optional | Reference only (e.g. procedure list). Not used by the AI. |
When all four required fields are mapped, click Next: review rows to continue.
Step 3 β Review and fix rows
This is the most important step. Every row from your file gets validated, color-coded, and you decide which ones to actually import. There are also clinic-wide settings at the top of this step that apply to the whole batch.
Row statuses
| Status | What it means |
|---|---|
| Valid | Good to import as-is. Selected by default. |
| Warning | Importable, but worth a second look (e.g. odd phone format). Selected by default. |
| Duplicate | Matches an existing appointment. Not selected by default β review before including. |
| Error | Missing a required field or invalid data. Cannot be imported until fixed in the table. |
The three header controls
| Control | What it does |
|---|---|
| Call date | Which day the AI confirmation calls should go out for all imported rows. "Call Today" places them today; other options include the day before, same day as the appointment, or a custom date. |
| Enable automated confirmation toggle | When on, every imported row will get AI confirmation calls scheduled. When off, the rows are imported but no calls fire β your team would handle them manually. You can also override this per row. |
| Bulk apply | Set a single value (Preferred call time, Language, or Patient note) and apply it to every selected row at once β saves clicking through 42 rows individually. |
Row-level editing and the AI per-row toggle
The table below the bulk controls is fully editable β click into any cell to fix it. The last few columns also include a per-row AI toggle so you can leave confirmation calls on globally but turn them off for a specific patient, and an Issues column showing exactly what's wrong with any error rows:
About that "call time has already passed today" warning: if you've set Call date to "Call Today" but the Preferred call time you've configured is earlier than now, those calls won't actually fire. Either move the call time later, or change the Call date to a future option.
Step 4 β Import
When you're happy with the row selection, click Import N appointments at the bottom of Step 3. Anashi creates the appointments, schedules the AI calls (if enabled), and shows a result summary so you know exactly what happened.
You'll see counts for: imported, AI calls scheduled, skipped duplicates, and skipped invalid rows β plus an itemized list of anything skipped so you can act on it.
The new appointments appear immediately on your Appointments dashboard, with their confirmation calls already queued.
Changed your mind partway? Use Back to mapping from Step 3, or Cancel at any step. Nothing is saved to the database until you click the final Import button.