Skip Navigation

Spreadsheet

Letters & Milestone Time-Capsule Keepsake — 26 Milestone Letters to Your Child, Dated From One Birth Year (Excel + Google Sheets)

Write the letters you keep meaning to write. 26 milestones dated from one birth-year cell, 104 prompts, and a time-capsule index, for Excel & Sheets.

Click to enlarge the image / Click × or press ESC to close

What you'll love

  • One cell runs it — type the child's birth year and all 26 milestones work out the year they open, how many years are left, and a Write now / Coming up / Later / Any time / Done flag
  • The dashboard names the next letter — the single soonest unwritten milestone, its year, and who claimed it, plus a count of the letters nobody has been assigned
  • 104 writing prompts — four questions and one thing to leave out for every milestone, plus the five moves that get a letter out of a blank page
  • A time capsule that knows its dates — record why each memento is kept, pick the milestone it's handed over at, and the year calculates from the same birth-year cell
  • The handover record most keepsakes skip — where the box is, who else knows, and who would hand it over if you couldn't
  • A keepsake you own — an 8-tab workbook (Excel, Google Sheets & LibreOffice) + 44 pages of PDF guides and printable letter pages · evergreen · instant download

You have meant to write these letters for years. Not because you have nothing to say — because a letter to a person who doesn’t exist yet has no deadline, and things with no deadline lose, every week, for eighteen years. The Letters & Milestone Time-Capsule Keepsake turns “I should write that down someday” into twenty-six ordinary tasks, one of which is due now.

“Write letters for the big moments” isn’t a task. It has no start, no order, no end, and no way of telling you whether you’re behind — so it stays an intention, and intentions are what people are left holding when a chance runs out. Type a birth year into one cell and the whole plan dates itself: every milestone works out the year it opens, how many years are left, and whether it belongs at the top of the list this month or can wait a decade.

Why a milestone letter planner beats a blank notebook

A notebook gives you paper. A blank “letters to my child” template gives you somewhere to start on one letter. This gives you a dated plan and a method:

  • One cell runs it. The child’s birth year sits on the Setup tab. Every milestone’s opening year, its countdown, and the capsule’s hand-over years all calculate from it — so correcting it once re-dates all twenty-six at a stroke.
  • A calculated flag, not a wish list. Each row shows Write now, Coming up, Later, Any time, or Done — worked out from the years remaining and the status you set, so the plan tells you where to start instead of leaving you guilty about all of it.
  • The dashboard names the next letter. Not a count — a name: the single soonest unwritten milestone, the year it opens, and who claimed it. It also counts the letters nobody has been assigned, because a letter that’s everybody’s job is nobody’s job.
  • 104 prompts for the blank page. Four questions and one thing to leave out for every milestone, from the day they arrived to their fiftieth birthday — plus the five moves that get a real letter out of someone who’s been staring at the page for ten minutes.
  • A time capsule with dates attached. The hospital bracelet, the knitted hat, the drawing where everyone has the wrong number of legs. Record why each is kept and which milestone it’s handed over at, and the year is looked up from the plan — so a memento and its letter come due together.
  • The handover step everyone skips. A sealed letter nobody knows about is a letter that never gets delivered. Record where the box is, who else knows, and who would hand it over if you couldn’t — and the dashboard warns you while that number is still zero.

The twenty-six letters

Twenty dated milestones, in four groups, plus six undated ones:

  • The years they’re unlikely to remember (0–7). The day you arrived; your first birthday; your first day of school; the first time you were brave without us.
  • The in-between years (10–15). Double digits; the year you start middle school; thirteen; the first time your heart is broken.
  • The last years at home (16–18). Sixteen; the day you first drive alone; graduation; the day you leave home.
  • Out in the world (18–50). Your first real paycheck; twenty-one; finishing your degree or your training; the first place that’s yours; the day you choose your person; the day you become a parent; thirty; fifty.
  • Six “open when…” letters, with no date at all. A hard day; doubting yourself; homesick; angry with us; needing to be brave; and saying goodbye.

Delete the ones that aren’t your family, change the ages that aren’t right, and add the days only you would think of. The calculated columns follow whatever you type.

What to say when you don’t know what to say

The freeze is almost always the same: trying to write something worthy of the occasion instead of something true about the person. So the prompt book teaches the opposite — start in the middle of a memory, describe instead of praise, answer a question they’d actually ask, tell on yourself once, and stop before you’re finished. Short letters get finished, and a letter you finished beats a letter you’re still perfecting.

A keepsake you own, because it has to work in twenty years

That’s the whole point of it. An app that holds your letters for a monthly fee can raise the fee, change hands, lose interest, or shut down long before the sixteenth birthday it was supposed to reach — and the letters go with it. A file you own doesn’t: you decide where it’s stored, you print it, you copy it, and the paper in the box is yours regardless. Pair it with the New-Baby / New-Parent Records Binder for the practical half of the same childhood.

Who the milestone letter keepsake is for

New parents starting on day one, while the details are still theirs; parents of older children, for whom the plan will simply say a few are already overdue — which is exactly the nudge that gets the first one written; grandparents carrying a version of the family nobody else was there for; both parents claiming a milestone each and seeing who’s actually finished theirs; anyone facing an illness who wants to write the ones that matter first; and anyone shopping for a baby-shower gift that’s still in use when the child is grown.

An honest note

This is a keepsake for personal letters and mementos. A letter is not a will — it doesn’t direct who inherits anything, and it isn’t a guardianship nomination, a trust, a power of attorney, an advance directive, or a beneficiary designation. Nothing here is legal, financial, or medical advice, and the requirements differ by country and by state. If you want your wishes to be binding, put them in the right documents with a qualified professional where you live, keep those documents somewhere other than this box, and use these letters for the part the paperwork can’t carry. Don’t write account numbers, passwords, PINs, or where valuables are kept into the letters or into the file — a keepsake box is not a safe. The example family throughout is clearly fictional; you overwrite it with your own.

Prefer to start free? Try the free A Letter for One Day page — a printable with the prompts for a single milestone letter, the letter page itself, and a cut-out envelope label, free to download.

See it in action

Play

Built to last

  • Intuitive and straightforward design
  • Employs software best practices
  • Delivered as one spreadsheet that works in Microsoft Excel, Google Sheets, and LibreOffice Calc
  • Free updates — send us a message to be notified of updates when they are available
  • Completely customizable — add rows and columns, rename headings, and adjust formulas

In the download

This digital product is delivered as a zip file containing the following items:

  • 01 — The Letters & Milestone Time-Capsule Keepsake (.xlsx, 8 tabs): Read Me, Start Here Checklist, Setup & The Child, Keepsake Dashboard, Milestone Letter Plan, Time Capsule & Mementos, Writers & Contributors, Handover & Where It All Lives — pre-filled with a clearly fictional example; opens in Excel, Google Sheets, or LibreOffice
  • One-click Google Sheets copy — a ready-made native version (no import needed)
  • 00 — Start Here Guide (PDF, 10 pages): why these letters never get written, what this is and firmly is not, and how to cut 26 milestones down to your family's
  • 02 — The Letter Prompts Book (PDF, 17 pages): 104 prompts — four questions and one thing to leave out for each of the 26 milestones
  • 03 — Sealing, Storing & Handing Over (PDF, 8 pages): what goes on an envelope, storing paper and recordings for decades, what must never go in a letter, and why a letter is not a will
  • 04 — Printable Keepsake Letter Pages (PDF, 9 pages): a letter page, a continuation page, cut-out envelope labels, the 26-milestone plan pre-printed on paper, a capsule inventory, and a handover page
  • READ-ME-FIRST.txt

Compatibility & terms

Unless otherwise specified, this digital product is delivered as a spreadsheet (an .xlsx file) designed to work in Microsoft Excel, Google Sheets, and LibreOffice Calc . It is not guaranteed to work in any other application.

This digital product is copyrighted. It is intended for personal use only. It is strictly prohibited to reproduce, resell or share this product, in part or in full, with or without modifications. No refunds, exchanges, or cancellations. Given this is a digital product, no physical product will be delivered.

Why a workbook

Most tools force a choice between a blank spreadsheet you build from scratch and a monthly app that's overkill. Ardent Workshop is the rung in between — structure you own.

  1. Blank spreadsheet

    Free, but you build and maintain every formula, tab and layout yourself.

    • Free
    • Infinite setup
    • No structure
  2. You are here

    Ardent Workshop

    Owned, structured, connected workbooks — a one-time price, yours to keep.

    • One-time price
    • Structured & connected
    • Yours to own
  3. Generic SaaS app

    Powerful, but overkill, rented and locked-in — built for someone bigger than you.

    • Monthly rent
    • Overkill
    • Lock-in

Ready to start

Instant download · Free lifetime updates · Personal use license

$17.95 USD
Buy now

Pairs well with