Medical Chronology Template: Free Google Sheet, Word, and CSV (with a Fictional Example)

From thousands of pages to strategic clarity in hours.

Medical chronology vs medical record analysis

The short answer: A medical chronology template is a fill-in table that lists every medical encounter in date order. Ours has six columns: Date, Provider, Facility, Visit Type, Summary, and Source Page Citation. Download the free fictional template below, add one row per encounter, and cite a source page on every row so anyone can check it against the record.

Download the template (fictional examples included): Google Sheet · Word (.docx) · CSV

A blank grid is easy to find. A template you can still defend when opposing counsel, an adjuster, or your own supervising attorney asks "where does it say that?" is harder to come by. This guide covers what goes in each column, how to fill the template in seven steps, how to adjust it for personal injury, medical malpractice, insurance defense, and claims work, and a fully fictional worked example you can copy.

What goes in each column

The template uses six columns. Each one answers a question a reader will ask.

ColumnWhat goes in itCommon mistake
DateDate of service as documented. Add 24-hour time when the record has it. Use a range for a series (for example, a block of therapy visits).Using the print, fax, or signature date, which moves care to the wrong day.
ProviderThe person who delivered or documented the care, with credential as written (MD, DO, PA-C, RN, PT).Writing "the hospital" when a named person made the entry.
FacilityWhere the care happened, down to the department when it matters (ED, surgical unit, radiology).Leaving it blank when a provider works at more than one location.
Visit TypeOne label from a fixed list: Emergency visit, Office visit, Specialist consult, Imaging, Procedure, Therapy series, Missed appointment, Gap in care, Late entry, Conflict, Record (undated).Making up new labels mid-case, which breaks filtering.
SummaryWhat the record says, in plain language: complaint, key findings, assessment, plan. Mark patient-reported history as reported.Mixing your opinion into the facts.
Source Page CitationBates number if the records are stamped; otherwise source name plus page, such as "Fictional Ortho Clinic, p. 14."Citing a whole document ("ED records") instead of a page.

Above the table, the template has a short matter header: matter name, patient initials and date of birth, incident date, records included (source and page or Bates range), records outstanding, and preparer, version, and date. The "records outstanding" line matters more than it looks. A gap in the chronology can mean a gap in care or a gap in the production, and the header is where you record which is which.

How to fill in the medical chronology template in 7 steps

1. Inventory every source before you open the template

List each provider and facility, the date range each set covers, and the page count. Then skim for references to records you do not have: a referral to a specialist, an outside MRI, a transfer. Add each one to "records outstanding." This takes minutes and prevents the most expensive kind of mistake: a chronology that looks complete but never included a provider.

2. Pick one citation convention and write it down

Most templates we looked at assume your records are already Bates-stamped. Many real productions are not. They arrive as a mix of PDFs, scanned images, faxes, and portal exports. Decide on one convention for the whole case before entering a row:

  • Stamped records: use the Bates number of the exact page.
  • Unstamped, one file per source: source name plus page ("Fictional Valley Medical Center, pp. 4-7").
  • Unstamped, many files per source: file name plus page ("FictionalOrtho_2026-04.pdf, p. 3").

If the records are stamped later, update each citation to the Bates number rather than keeping two systems.

3. Fill in the matter header

Complete every line, including version and date. When new records arrive, save a new version instead of overwriting the old one, so everyone knows which chronology they are reading.

4. Enter one row per encounter, using the date of service

Work through the records and create a row for each encounter or significant event. Use the date care happened, not the date a page was generated. For a series of similar visits, such as ten physical therapy sessions, one range row with the first and last date is usually enough, as long as the citation covers every page in the range and the initial and final evaluations are summarized.

5. Write the Summary in the record's terms

Keep the Summary factual and short. Three habits make it defensible:

  • Reported vs. found. "Patient reports tingling in right hand" is different from "decreased sensation on exam."
  • Planned vs. performed. "MRI ordered" and "MRI performed" are separate facts on separate dates.
  • Values and times. Include them when the case may turn on them.

6. Add rows for what is missing, conflicting, late, or undated

The rows that decide a case are often not treatment rows. Add a "Gap in care" row for a stretch with no records and note whether records are outstanding. Add a "Conflict" row when two records disagree, citing both pages. Add a "Late entry" row for an addendum, showing both the event time and the time it was written. Put records with no date of service at the bottom as "Undated" instead of guessing.

7. Sort, de-duplicate, and spot-check citations

Sort by Date. Rows out of order usually mean a date-format error. Remove duplicate copies of the same page (a lab result often appears in three places) and keep the earliest primary source. Then pick rows at random and open each cited page. If a citation is wrong, check the rest of that source.

Fictional worked example

FICTIONAL EXAMPLE. The patient (Morgan Lake), providers, facilities, dates, and citations below are invented for illustration. No real records were used.

Matter: Lake v. Fictional Driver (fictional) · Incident: rear-end collision, 03/02/2026 · Records outstanding: none known

DateProviderFacilityVisit TypeSummarySource Page Citation
03/02/2026Unit 12 crew (paramedic)Fictional County EMSEMS transportRear-end collision at low speed. Patient reports neck pain 6/10, denies loss of consciousness. Cervical collar applied; transported to ED.Fictional County EMS, p. 2
03/02/2026A. Placeholder, MDFictional Valley Medical Center EDEmergency visitNeck pain after collision. CT cervical spine: no acute fracture. Assessment: cervical strain. Cyclobenzaprine prescribed. Plan: follow up with primary care in 1 week.Fictional Valley Medical Center, pp. 4-7
03/09/2026B. Sample, DOFictional Family PracticeOffice visitPatient reports ongoing neck pain and new tingling in right hand. Exam: reduced cervical rotation. Plan: physical therapy referral and cervical MRI (ordered, not yet performed).Fictional Family Practice, p. 3
03/18/2026C. Notreal, MD (radiology)Fictional Imaging CenterImagingMRI cervical spine: C5-6 disc protrusion. Mild degenerative changes also noted. PRE: degenerative finding noted on the same report.Fictional Imaging Center, p. 1
03/23/2026 - 04/24/2026D. Madeup, PTFictional Physical Therapy GroupTherapy series10 sessions documented. Initial evaluation 03/23; re-evaluation 04/24 notes improved range of motion, persistent right-arm symptoms.Fictional Physical Therapy Group, pp. 1-22
04/30/2026E. Imaginary, MDFictional Ortho ClinicSpecialist consultRadiating right-arm pain. Patient reports a prior neck-pain episode in 2022 that resolved. Recommends C5-6 epidural steroid injection.Fictional Ortho Clinic, p. 14
05/01/2026 - 06/15/2026None documentedNone documentedGap in careGAP: 46 days with no records in the production. Confirm whether care paused or records are outstanding before relying on this gap.Absence: Fictional Ortho Clinic pp. 14-15 (no entries between visits)
06/16/2026E. Imaginary, MDFictional Ortho ClinicProcedureC5-6 interlaminar epidural steroid injection performed without complication.Fictional Ortho Clinic, p. 21
UndatedNot statedFictional Family PracticeRecord (undated)Medication list with no date of service. Listed here instead of borrowing a nearby date.Fictional Family Practice, p. 9

Three rows to notice. The 03/18/2026 imaging row records the degenerative finding alongside the disc protrusion, because leaving it out would only delay the causation argument. The 05/01-06/15 row is a gap, cited to the pages where entries would have appeared, with a note to confirm it against the production. The undated medication list sits at the bottom instead of borrowing a nearby date.

For a second fictional case worked row by row, including the record excerpt behind each entry, see our medical chronology example.

How to adapt the template by matter type

The six columns stay the same. What changes is what you emphasize.

Matter typeDate precisionSummary emphasisRows to watch for
Personal injury (plaintiff)DayMechanism, first complaint after incident, treatment course, work statusGaps in care, prior history of the same body part, missed appointments
Medical malpracticeMinute, when the record has timesOrders, results, notifications, and responses, in sequenceDelays between result and action, late entries, undocumented intervals
Insurance defenseDayPre-incident history, degenerative findings, patient-reported history across providersConflicting histories, pre-existing conditions, non-compliance
Claims teamsDay or visit rangeDiagnoses, procedures, treatment duration, current statusTreatment beyond the documented diagnosis, gaps, unrelated care mixed into the file

Template, example, or sample?

People use the three words interchangeably, but they answer different needs. A template is the empty structure (this page). An example is one completed case you study row by row (Post A). A sample is a finished work product you use to judge a format or a vendor before you commit (Post B).

Need the narrative version instead of a table? See what a medical record summary includes. New to the format? Start with what a medical record chronology includes.

Checklist: before you share a chronology

  • Matter header complete, including records outstanding and version date
  • Every row has a Source Page Citation to a page, not a document
  • Dates are dates of service, in one format, stored as text
  • Visit Type uses only the agreed list
  • Patient-reported history is marked as reported
  • Ordered vs. performed is clear for every test and procedure
  • Gap, conflict, and late-entry rows are present where they apply
  • Undated records are listed separately
  • Duplicates removed, primary source kept
  • Random rows checked against their cited pages
  • All example rows deleted from your working copy

When the stack is too big to do by hand

The template works the same whether you have 80 pages or 8,000. What changes is the time it takes to read them. Litegy is a pure-AI platform for medical-record case analysis built for personal-injury, medical-malpractice, and insurance-defense firms and claims teams. You upload records in any file type, Litegy's AI sorts them, and it produces medical chronologies and reviews in hours. If you would rather start from an AI-built chronology than a blank grid, see how Litegy works or go straight to Litegy's med chron software. For how a chronology differs from a full analysis, read Medical Chronology vs. Medical Record Analysis.

Want to see a full analysis? Get a free sample Litegy AI medical record analysis.

Frequently asked questions

What columns should a medical chronology template have?

At minimum: date of service, provider, facility, visit type, a factual summary, and a source page citation. Many teams add a flag column for gaps, conflicts, and pre-existing conditions. The citation column is the one you should never drop.

Should I build a medical chronology in a spreadsheet or in Word?

Build in a spreadsheet, because you can sort by date and filter by provider or visit type. Move to Word or PDF when the chronology is ready to be read, shared, or attached to a demand or report.

What date should each chronology row use?

Use the date of service documented in the record, not the date a page was printed, faxed, or signed. If a record has no date of service, list it as undated rather than guessing.

How do I cite medical records that are not Bates-stamped?

Use the source name plus page, such as "Fictional Ortho Clinic, p. 14," and keep that convention for the whole case. If the records are stamped later, update each citation to the Bates number.

Is the downloadable template based on real patient records?

No. Every name, facility, date, and page citation in the example tabs is fictional and was written for illustration. Delete the example rows and enter your own case data.