1 / 15

Type each person once, the tree draws itself

Family Tree Spreadsheet

Type each person once, pick their father and mother from a drop-down, and your family tree chart draws itself. Pick anyone and five generations fill in, back to their great-great-grandparents.

SpreadsheetExcel + Google Sheets11 tabsInstant download

$10.99 one time, buy direct

Buy direct · $10.99

Instant download: the spreadsheet (.xlsx) and the free 8-page quick start PDF guide, right after you pay.

Buy on Etsy · $12.99

35% off on Etsy: code SAVE35

Try the free demo

Pay once, no subscription
No macros, no account
Works in Excel, Google Sheets and LibreOffice Calc
Free 8-page quick start PDF guide included

What's in the Family Tree Spreadsheet

Five generations, drawn for you

Pick anyone and see their parents, grandparents, great-grandparents and 2x great-grandparents, father's side and mother's side.

One row per person

Room for 300 people with names, married name, birth and death dates and places, father, mother, spouse, notes and a photo or record link.

Marriages

Up to 150 couples: when and where they married, how it ended, years together and the anniversary.

Family pages

One person's page with their parents, grandparents, marriages, children, and brothers and sisters.

Timeline

Births, marriages and deaths in order, oldest first. Show one kind of event or one family name.

Birthdays + anniversaries

Pick any month to see the birthdays and anniversaries, with the age each person turns.

Family names + places

The top 60 family names and birthplaces, most common first, with the earliest year for each.

Research log + print chart

Track what you're looking for, where you looked and what you found, and print a framed 5-generation chart on one landscape page.

How it works

Type each person once
One row per person, with their father and mother picked from a drop-down.
Pick anyone
Five generations fill in, from them back to their great-great-grandparents.
Every tab updates
Family pages, the timeline, birthdays, names and places and the print chart fill in by themselves.

Watch the how-to

The 3-minute how-to video, start to finish.

Plus the free 8-page quick start PDF guide comes with your purchase.

Old dates work. Mistakes get caught.

Born, died and married take a full date or just what you know: 12 Mar 1854, Mar 1854, abt 1880 or 1854. Dates before 1900 work too. The Check column on People flags:

A name used twice
A date with no year
Someone who died before they were born
A parent who isn't on the list
A parent born after the child

What you get, how you get it and what you need

What you get

One .xlsx workbook with 11 linked tabs, empty and ready for your family
The free 8-page quick start PDF guide, with real screens
A one-time purchase, no subscription

How you get it

Buy direct: right after you pay, you land on your download page with the spreadsheet and the guide.
On Etsy: open Purchases in a web browser and click Download Files. The Etsy phone app can't download files.
Open it in Excel, or upload it to Google Drive and open it with Google Sheets. The guide walks you through it.

What you need

Microsoft Excel, Google Sheets (free) or LibreOffice Calc (free)
No macros and no account

Good to know

It holds up to 300 people, 150 couples and 200 research log rows.
The tree shows five generations at a time, from the person you pick.
The timeline shows up to 300 events at a time.
It opens empty, ready for your family.
It's a digital download. Nothing is shipped.

Reviews

The Family Tree Spreadsheet doesn't have reviews yet.

Our Etsy shop has 150 reviews with a 4.8-star average.

Read all our reviews on Etsy →

Questions

Does it work in Google Sheets?

Yes. It works in Microsoft Excel, Google Sheets (free) and LibreOffice Calc (free). Type in the cream cells; everything else is filled in for you.

How many generations does the tree show?

Five: the person you pick, their parents, grandparents, great-grandparents and 2x great-grandparents, on both sides of the family.

How many people can I add?

Room for 300 people and up to 150 couples.

What if I only know part of a date?

Type just what you know. Mar 1854, abt 1880 or 1854 all work, and dates before 1900 work too.

Can I print the tree?

Yes. The Print Chart tab prints a framed 5-generation chart on one landscape page, Letter or A4.

Does it catch mistakes?

Yes. The Check column on People tells you when a name is used twice, a date has no year, someone died before they were born, a parent isn't on the list, or a parent was born after the child.

How do I get it after I buy?

Buy direct and you land on your download page right after you pay, with the spreadsheet and the free quick start PDF guide. On Etsy, open Purchases in a web browser and click Download Files.

Can I try it before I buy?

Yes. Try the free demo right in your browser before you buy.