Thanksgiving is Nov 26. Shop Thanksgiving & fall
ColorQuietCO For Communities Shop
Puzzles & keepsakes

Family Tree Spreadsheet Organizer

Excel and Google Sheets, room for 500 people

$8.99

Buy now · $8.99

Card or PayPal · no account needed · instant download

Prefer Etsy? Buy this pack on Etsy

What you get

  • Instant download
  • Excel and Google Sheets
  • Print as often as you like at home

Good to know

  • Your download link shows right after you pay, and a copy comes by email. Nothing is shipped.
  • A file won't open or something looks wrong? Email kevin@colorquietco.com and we'll fix it or make it right, usually within one business day.
  • Something not right with a page? Email us and we'll make it right.

Keep your whole family tree in one tidy spreadsheet that does the linking for you. Add each person once, type their parents' ID numbers, and the organizer fills in names everywhere: on a four-generation tree, a family view and a summary of what's still missing.

Works in Excel and Google Sheets

Simple, standard formulas only: no macros, no add-ons, nothing to install. Open it in Microsoft Excel (Windows or Mac), or upload it to Google Drive and open it with Google Sheets for free. Share the Google Sheets copy so the whole family can add names.

What's inside (9 linked tabs)

  • People: room for 500 people, with dates, places, occupation and notes. Link father, mother and spouse by ID number
  • Tree: type any ID and see four generations of ancestors
  • Family View: one person with parents, spouse and every child
  • Timeline, Research Log (Found / Not found menu), Sources and To-Do (done items cross out)
  • Summary: live counts of people, missing birth years and unlinked parents
  • Start Here: how it works, in one page

What you get

  • family-tree-organizer.xlsx: blank, ready for your family
  • family-tree-organizer-sample.xlsx: filled with a made-up family so you can see how it works
  • A 5-page printable guide (US Letter and A4 PDF): opening it in Excel or Google Sheets, linking people, every tab explained

More like this

See all
Family Tree Spreadsheet Organizer$8.99
Buy now