Guides, October 2026

How to make a timeline of a grandparent's life

Start from the papers with dates on them. One row for each event, and next to it, how you know.

To make a timeline of one person's life, list every dated paper you have, write one row for each event, and note the source beside it. A plain spreadsheet is enough. When you sort the rows by year, two things show up that you could not see before: the papers that disagree, and the years with nothing in them.

There are two ways to get there. You can build it by hand, and the rest of this guide shows how. Or you can photograph the pages and let software read them and build it, which is what Unboxed does. The by-hand way is worth knowing either way, because it shows what a good timeline holds.

What do you need to start?

Less than you think. You need the papers, a spreadsheet, and a rule: no row without a source.

Start with whatever carries a date.

  • Letters, and their postmarks
  • Journal entries
  • Photos with a year on the back, or a car you can date in the driveway
  • Certificates, programs, and announcements
  • Newspaper clippings
  • A funeral program or an obituary, which often lists a whole life in one column

Memories count too. A thing an aunt told you is a source. Write it down as hers.

What goes in each row?

Five columns will carry a whole life.

  1. Date. As exact as the source is, and no more. "Spring 1951" is honest. "April 1, 1951" from a guess is not.
  2. What happened. One plain sentence.
  3. Where. A town is enough.
  4. Who was there. Full names when you have them.
  5. Source. Which paper, which page, or which person told you.

The source column is the one people skip, and the one that matters in a year. When a cousin says that isn't how it happened, you can both go and look.

Add a sixth column if you like: how sure you are. "About" and "before" are useful words.

What do you do when two papers disagree?

Keep both. Two papers with two birth years is not a mistake in your timeline. It is a fact about the papers.

Write a row for each, with its source, and mark them as a pair. Then ask which paper was closer to the event. A record made that week usually beats a memory written down fifty years later. But not always, and you don't have to rule on it. An open question on the page is better than a quiet choice that nobody can trace.

If someone alive might know, ask them, and write down who answered.

How do you find the gaps in a life story?

Sort by year and look for the empty stretches. They are easy to see in a spreadsheet and almost impossible to see in a box.

A few kinds turn up in nearly every life.

  • A quiet decade. Plenty of paper from the 1950s and the 1980s, and two rows between them. Those are often the busy years: small children, long hours, nobody writing letters.
  • A record that should exist. A wedding with no date. A move with no reason.
  • A story that was promised. A line in a journal that says more will follow, and then nothing follows.
  • A name with no face. Someone who is in six letters, and nobody knows who they were.

Each gap is a question for the family, and a specific one. "Tell me about Grandpa" gets a shrug. "Where were they living in 1968, and why did they leave?" gets an hour on the phone. Ask the oldest people first. That part has a clock on it.

When an answer comes back, it goes in as a new row, with the name of the person who gave it as the source.

How long does it take?

The timeline itself is quick. The reading is slow. If the papers are typed, a weekend gets you a good first pass. If they are handwritten journals, you are reading every page to find the dates, and that is weeks of evenings.

It helps to photograph the pages first, so you can work from a screen and leave the paper alone. How to scan letters with a phone covers that. And if a book is the goal, the timeline is the backbone of it: how to turn letters and journals into a book.

Where Unboxed fits

Unboxed builds this timeline from the papers, so you can skip the spreadsheet. You upload pictures of the pages, in any order. We read each one, handwriting included, and put the events on one timeline, with the people and the places linked. Each event shows the page it came from, which is the source column, filled in.

Where two papers disagree, it becomes a question, not a silent choice. Where a decade is quiet, the box asks the family, and an answer goes in with that person's name on it.

One box is one person's life, for one payment, and the family you invite reads for free. See pricing.

The spreadsheet works too. Either way, start with the source column.

Get started How it works