A Google Sheets Family Medical History Template

Create the sheet before calling relatives

Open a blank Google Sheet and name it Family medical history. You do not need a complicated family tree or a separate tab for every branch.

Use these columns:

• Relative
• Mother's or father's side
• Relationship
• Condition
• Age at diagnosis
• Current status or outcome
• Source
• Certainty
• Questions to confirm
• Last updated

Keep one condition in each row. If a grandfather had diabetes and later had a stroke, enter two rows so each condition can be filtered and updated independently.

Use names, initials or labels such as maternal grandfather, depending on the identifying detail you are comfortable storing.

Record what you know without guessing

Family stories are often incomplete. If someone remembers “heart trouble” but not the diagnosis, record the phrase they used, mark it uncertain and add a question to confirm.

Relative	Family side	Condition	Age at diagnosis	Source	Certainty	Question
Grandfather	Mother's side	Heart condition	Unknown	Mother	Uncertain	What was the diagnosis?
Aunt	Mother's side	Ovarian cancer	47	Aunt	Confirmed	None

This distinction lets you tell a clinician exactly what you know: “My mother remembers a heart condition, but the diagnosis is unknown.” An unknown value is safer and more useful than a confident mistake.

Keep family relationships clear

Medical relevance depends on biological relationships, so grandmother may be too vague in a blended family. Distinguish biological relatives, half-siblings, step-relatives and adoptive relatives. Record the mother's or father's biological side when known.

If you are adopted or cannot access biological information, write biological family history unavailable. That is clearer than a blank sheet that could be mistaken for no known conditions.

Gather one side at a time

For each relative, ask which conditions they had, roughly when each began and how certain the information is. If the person has died, ask whether the cause is known.

Type directly into the sheet or update it immediately after the conversation. A voice memo can help, but obtain permission before recording anyone.

Family information often arrives in fragments. Parents may not know older relatives' exact diagnoses, medical terminology can change and some subjects were never discussed. Preserve uncertainty instead of resolving it yourself.

Prepare a short appointment view

Before an appointment, filter the sheet for the conditions and family branches relevant to the intake questions. Keep uncertain entries visible so the clinician can decide whether they matter.

Your role is to provide the clearest account available, not interpret its medical significance. If a clinician corrects a condition name or identifies a useful missing detail, update the sheet afterward. List the clinician as a source only for the clarification they actually provided.

Family history can affect conversations about screening, genetic testing, borderline laboratory results, medication decisions and recommendations for children. A clinician should interpret those implications.

Make updates small

• Add a row when a relative receives a diagnosis.
• Correct the age or condition when better information arrives.
• Update the date and source for every correction.
• Review unanswered questions before a routine appointment rather than contacting the whole family on a fixed schedule.

Protect the sheet before sharing

Review Google Sheets permissions and avoid public link sharing. Give siblings view or edit access only when needed, and remove details irrelevant to the recipient.

At an appointment, show relevant rows on your device or copy requested facts into the clinic's form. A personal spreadsheet is not automatically part of your official medical record.

Use another format if the spreadsheet becomes a chore

A paper form, private note or document works if it keeps the same core fields. A searchable memory tool such as dEssence can store notes or voice messages and help you find them later in your own words.

The format matters less than the discipline: preserve the source, label uncertainty, clarify relationships and update facts when you learn more.