Skip to content
← Resources

Importing patients

Load your diabetes register from a spreadsheet export.

Import patients in Organisation → Patients from a CSV file exported from your records system, or add them one at a time. Every row is validated before anything is saved, and problems are listed by row.

Columns

The first row must contain these column names. Unknown columns are ignored; blank cells are treated as missing.

ColumnNotes
record_numberRequired. Your records system’s patient number; used to match bookings and device data.
given_nameRequired.
family_nameRequired.
date_of_birthRequired. YYYY-MM-DD.
sexfemale, male, other or unknown.
diabetes_typeFor example type_1, type_2.
emailOptional contact detail.
phoneOptional contact detail.
preferred_channelHow the patient prefers to be contacted (for example sms, phone, email). Patients without one are not offered slots.
latest_hba1c_mmol_molOptional. Most recent HbA1c in mmol/mol (IFCC). If your records use %, add a latest_hba1c_percent column instead.
hba1c_dateOptional. YYYY-MM-DD of that HbA1c.

Template

record_number,given_name,family_name,date_of_birth,sex,diabetes_type,email,phone,preferred_channel,latest_hba1c_mmol_mol,hba1c_date
MRN-0001,Amara,Okoye,1968-03-14,female,type_2,amara@example.com,+00 0000 000000,sms,62,2026-09-20

Good practice

  • Use the same record number your scheduling system uses, so bookings and device data match the right patient.
  • Import in batches; a re-import of the same record number does not create a duplicate.
  • Record a contact preference for everyone you may offer a slot to.

Next: Waiting list and slot fill