Skip Navigation

Spreadsheet

Life-Story & Memory Keepsake Journal — 200 Interview Questions for a Parent or Grandparent (Excel + Google Sheets)

200 interview questions for a parent or grandparent, in a workbook that tracks which era of their life is still thin. Excel & Google Sheets.

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

What you'll love

  • 200 curated interview questions across ten eras of a life — each written to be read out loud word for word, each with a "Go Deeper" follow-up to ask second
  • Graded so you know where to start — 57 Cornerstone questions (the ones worth asking first, because nobody else can supply the answer), 102 Core and 41 Bonus, with the Cornerstones counted separately so one pass covers the right ones
  • A live Story Coverage dashboard — set a question to Captured and its era's progress bar moves; it names the thinnest era for you, so the next conversation plans itself
  • A Session Planner that counts prompts planned against prompts actually captured, turning a "someday" project into forty-five minutes in the calendar
  • A Life Timeline that works out their age at every event from one birth-year cell, and a Photos & Artifacts log that flags any photo still missing a person, a date, or a story
  • Five PDF guides — 63 pages, designed and typeset, not a bare template — how to ask, what to do with silence, getting past "there's nothing to tell", and what to do when a memory turns painful

Almost every family means to write down a parent’s or grandparent’s stories. Almost nobody does it, until it’s too late — and what disappears first isn’t the big facts. Someone always remembers the war, the move, the year of the flood. What goes is the texture: what the kitchen smelled like, what a loaf of bread cost, what their mother said the day they left home.

Tell Me Your Story is the journal that gets it finished. It gives you 200 curated interview questions across ten eras of a life, and wires them into a workbook that tells you, era by era, which stretch of the life is still thin and which questions are still worth asking first. One conversation a month, and the file plans the next one for you.

Why 200 questions instead of a list of prompts

A blog post gives you thirty prompts and no plan. This gives you a library and a method.

Every question is written to be read out loud, word for word — and every one carries a “Go Deeper” follow-up beneath it, the second question that gets the real layer once the first answer is out. The ten eras run from Roots and Before You through Childhood, School Years and Coming of Age, Young Adulthood, Love and Partnership, Work and Calling, Parenthood and Family Life, Home, Place and Everyday Life, and Times That Changed You, to Lessons and What You’d Pass On.

Each question is also graded — 57 Cornerstone, 102 Core and 41 Bonus. The Cornerstones are the ones worth asking first, because nobody else can supply the answer, and the dashboard counts them separately on purpose: if you only ever get through one pass, it makes sure it’s the right one.

The part a blank notebook can’t do

Open the Story Coverage tab and the workbook shows you the whole life at a glance: for each era, how many questions exist, how many you’ve captured, how many Cornerstone questions are still open, how many stories you’ve actually written up, a progress bar, and a depth band that runs from Not started to Complete.

Set a question to Captured and the bar moves. The dashboard then names the thinnest era for you — that’s your next conversation, already planned, instead of a negotiation about where to start.

  • The Session Planner counts prompts planned against prompts actually captured, so a project that could run for years becomes forty-five minutes in the calendar.
  • The Life Timeline works out their age at every event from a single birth-year cell — and the empty stretches between entries become the most honest list of what to ask next.
  • The Photos & Artifacts log flags any photograph, letter, or object still missing a person, a date, or a story. That flag is the whole reason the tab exists: an unlabeled photograph becomes a stranger in one generation, and you are very likely the last person who can prevent it.

Knowing what to ask is only half of it

The hard part is the asking. The Interview Guide is that skill written down: how to set the room up, how to ask one question and then stay quiet, how to get past “oh, there’s nothing to tell”, what to do when a memory turns painful, and how to write it up afterward so it still sounds like them rather than like a summary of them.

Alongside it: a Start Here guide, The Complete Prompt Library in print (all 200 questions, so you can take them to a hospital room or a long drive without a laptop), a Preserving & Passing On guide, and Printable Keepsake Pages for the people who’d rather write by hand — including every Cornerstone question gathered in one place, for the day you find you have an hour and no plan.

Every tab opens pre-filled

The workbook arrives on a worked example — a clearly fictional family part-way through the project, with real captured stories, a half-filled timeline, and a dashboard mid-progress — so you can see exactly how a working journal behaves before you overwrite a single cell with your own.

Works in Excel, Google Sheets, and LibreOffice

It ships as an .xlsx and as a one-click Google Sheets copy: open the included link, click Make a copy, and a fully working native Sheet lands in your Drive. No importing, no broken formulas.

Own it, don’t rent it

This is a file on your own drive, not an account on somebody’s platform. There’s no subscription to lapse, no company to be acquired and shut down, and no export to fight for later. Print it, copy it for every grandchild, and hand it on. Pair it with the Family Recipe Heritage Keepsake Binder for the rest of what a family passes down.

A keepsake, not advice

This journal helps a family capture what one person remembers, in their own words. It is not medical, legal, financial, or mental-health advice, and it is not genealogical research — recollections are often imprecise, and that is part of the record rather than a fault in it. These conversations can reach grief and hard memories; if one surfaces distress beyond a difficult memory, stop and help the person reach real support. Keep account numbers, passwords, and identity numbers out of the file — it’s designed to be copied and shared around a family. The worked example throughout is invented.

Not ready for the full journal? Start with the free Three Stories to Capture First printable — the three questions worth asking before any others, with room to write the answers down.

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 — Tell Me Your Story (.xlsx, 10 tabs): Read Me, Start Here Checklist, Life Overview, Story Coverage, Prompt Library, Session Planner, Story Register, Life Timeline, People & Places, Photos & Artifacts — every tab pre-filled with a clearly fictional worked 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): why this has to happen sooner than it feels, how the coverage engine works, and the session plan that actually finishes
  • 02 — The Interview Guide (PDF): setting the room up, how to ask and when to stay silent, getting past 'there's nothing to tell', handling a memory that turns painful, and writing it up so it still sounds like them
  • 03 — Preserving & Passing On Guide (PDF): the three-copy rule for recordings, what to label, what to keep out of a shared keepsake, and how to get a copy into every household
  • 04 — The Complete Prompt Library (PDF): all 200 questions in print, era by era, with the follow-up to ask second and the 57 Cornerstone questions marked
  • 05 — Printable Keepsake Pages (PDF): a story page, a session plan, a life-timeline sheet, a photograph-labeling page, and every Cornerstone question gathered in one place
  • 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

$19.95 USD
Buy now

Pairs well with