Vaccine Spreadsheet vs. Tracker App

A vaccine spreadsheet works fine for one child and starts leaking at three, usually around the moment a camp form asks for a date given by a pharmacy in another state. Nothing is wrong with the spreadsheet itself. What fails is the part around it: it is not on the phone in the parking lot, nobody remembers which of two versions is current, and it never tells you that something is due.

Four methods are in common use — a spreadsheet, a photograph of the paper card, a notes app, and a dedicated tracker. This article compares them on four concrete jobs rather than on features. It does not cover what a school or camp will accept as proof, which is a separate question with a separate answer.

The four jobs a family record has to do

A household record is asked to do exactly four things, and most tools do two of them well.

1. Find a date fast. Someone is standing at a desk with a form and a pen.
2. Say what is due. Not a diagnosis — just which items in a series have no date next to them.
3. Keep several people straight. Three children, two adults, five different histories.
4. Produce something you can hand over. A readable copy that leaves the device.

Job one is where a vaccine spreadsheet on a laptop at home loses, every time. Job two is where every manual method loses, because a static list does not know what a schedule says.

How each method performs

	Find a date fast	Say what is due	Several people	Hand something over
Spreadsheet	Only if it syncs to the phone	No	Good — one tab or column per person	Excellent
Photo of the paper card	Fast if you can read the handwriting	No	Poor — one image per card, unlabeled	A photograph, not a record
Notes app	Fast	No	Degrades quickly past two people	Copy and paste
Dedicated tracker	Fast	Compares entries against a published schedule	Designed for it	Depends entirely on the product

The photo row deserves a defense. A picture of the card is the single highest-value thing a parent can do in thirty seconds, because it preserves the original handwriting and survives a house move. It is a terrible day-to-day reference and an excellent archive, which is a reasonable thing to be.

Where a vaccine spreadsheet still wins

Be fair to the spreadsheet, because it is genuinely better at some things.

• Nothing can discontinue it. A .csv will open in twenty years. An app might not exist next year.
• It goes anywhere. Mail it, print it, paste it into a form, hand it to a new practice.
• It holds anything. A column for the school that asked, a column for the date you requested a copy from the state registry — no product's data model to argue with.
• You already know how to use it. No install, no learning, no permissions.

A vaccine spreadsheet is also the right answer for the specific job of preparing a document for someone else. If a new pediatric practice asks for the history, a clean table beats a screenshot of an app.

Where it stops being enough is the second job. Knowing what remains in a series means reading the current schedule, and the CDC's child and adolescent immunization schedule — the page is dated 2 July 2025 — is organized by age across two tables, birth to 15 months and 18 months to 18 years (child and adolescent immunization schedule). Cross-referencing that by hand for three children twice a year is the chore people stop doing in year two.

There is a second reason a home-made table drifts: it is a copy of a copy. The CDC's page for parents, dated 9 August 2024, states that "CDC does not keep vaccination records" and notes that clinics "may save records for only a few years" while schools may hold them "for a year or two after a student leaves or graduates" (Keeping Track of Records). Whatever you maintain at home is therefore an index pointing at institutions with short memories, and the value of the index rises the longer a childhood runs. The deadline that exposes a weak one is usually the same each year — the back-to-school paperwork window in August.

What every entry should contain

Whichever tool you pick, entries survive better when they hold the same four things. More fields look thorough and quietly make the record harder to maintain.

Field	Example	Why it earns its place
Person	Maya	Everything else is meaningless without it
Vaccine	MMR	The name as written on the paperwork you were given
Date	14 March 2026	The only value forms ever ask for
Dose in the series	2 of 2	Turns a list of dates into a status

Skip the clinical identifiers a practice logs for its own chart. They belong to the provider's record, they are tedious to copy correctly, and no school form asks for them. Why vaccine records never add up explains how the official history gets fragmented in the first place, which is the reason a family copy exists at all.

What a dedicated tracker changes

Vaxnext is the tracker published by the people who write this blog, so treat this as disclosure. It holds one record per family member with no limit, entries carrying a vaccine name, a date, a dose number and a short note, and custom entries for anything the built-in list does not name. It compares those entries against the U.S. child and adolescent schedule plus the annual flu vaccine, and it sends local reminders that fire with the phone offline and with no account anywhere.

The export is a plain JSON file passed to the phone's share sheet — which means, usefully, that a tracker and a vaccine spreadsheet are not rivals. The app is where entries get typed at the moment they happen; the file you send yourself is the archive that outlives the app. What a usable export should contain describes what to check in that file before you rely on it.

Whichever tool holds the entries day to day, the file sent out of it is what survives a replaced phone, a discontinued product, or a household deciding in two years that the table it abandoned was the better idea after all.

FAQ

Is a spreadsheet good enough for one child?

For one child with a stable pediatric practice, yes — provided it lives somewhere your phone can reach it and you actually update it after visits. The failure modes are scale and portability, not the format. A single well-maintained table beats an app nobody opens, and it can be handed to a new practice without any conversion.

What should every vaccine entry contain?

Four things: who it was for, the vaccine name as written on the paperwork, the date, and which dose in the series it was. That is enough to fill a school form, spot a gap and answer a clinician's question. Anything more is the provider's record rather than yours, and copying it by hand invites errors.

Not medical advice. This article is general information based on public U.S. CDC pages. It does not replace a clinician. Schedules and school requirements change — confirm the current official page and your own situation before you act.