A standard eLogbook export

In short. An eLogbook export has no patient names, but it carries a lot of clinical detail. The app reads the date, your role, the side, notes, complications, age and sex and files them on the case. It joins your hospital’s records for the same patient automatically.

Start from Import a spreadsheet on your case list. The preview shows the column mapping the app worked out, so you can confirm or adjust it before anything is brought in.

How it maps

The date. eLogbook stores dates as plain serial numbers, such as 45000. The app turns each one back into a real date, so cases land in the right month and year.
Your role. The Supervision column (Performed, Assisted, Supervised or Observed) sets whether you were the primary surgeon, the assistant or observing, and whether you operated independently or under supervision.
The side. Left, right or bilateral, decoded from the export’s own coding.
Notes and complications. The operation notes, including any “Diagnosis:” line, come in as the case notes. A complication note is filed as the complication.
Age and sex. Shown quietly beside the case. A sex you did not record, a “U” in the export, is left blank.
ASA grade, urgency and supervising consultant. These have no boxes of their own, so the app places them at the front of the case notes, for example ASA 1 · CEPOD 1 · Supervising consultant C000123. The Consultant column is the consultant under whose name the case sat, so it is kept as a note and never filed as the operating surgeon.

Names, hospitals and confirmation

It joins your hospital records. The export carries the MRN, so an eLogbook case for a patient lands on the same case as your hospital sheet records. The eLogbook fills in the clinical history, and the hospital sheet fills in the name and confirms the case, in whichever order they arrive.
It comes in unconfirmed, and that is intended. An eLogbook is your own record. Its cases are trusted for clinical detail but are not confirmed until a hospital sheet backs them. A “Validated” tick in eLogbook is a consultant’s sign-off, which is a different thing from the hospital’s financial record.
Your wording wins. Your own logbook’s wording for procedure, side and site replaces billing wording on matched cases, and anything you typed or dictated is never changed. See which version wins.
Re-importing changes nothing. The same export again does not create copies.

The cases come in without names. To fill them, read A logbook without patient names.

Less common

A renamed hospital. The export may carry an older hospital name, for example Old Name Hospital for a hospital now called something else. The import shows which of your existing hospitals it is filing under so you can confirm. It remembers the old name so it resolves by itself next time, and the hospital does not split into two.
Two of your own records disagree. You settle it with one tap. See which version wins.
Names are scrambled on your phone as they come in. See Where your data lives.