Buy Now

Family Tree Excel Template

Trace your lineage and honor your family with our Family Tree Excel Template. 
It's easy to use and fun to share with the whole family!
Buy Now

What's Inside the Family Tree Template?

Details | 2 Sheets 

Supported Versions | Excel 2010, 2013, 2016, 2019, Office 365 (Mac)

Category | General

Tags | Diagram, Ancestry

Why Professionals Choose Simple Sheets

It's simple. Access to the largest library of premium Excel Templates, plus world-class training.

100+ Professional Excel Templates

Optimized for use with Excel. Solve Excel problems in minutes, not hours.

Buy Now

World-Class Excel University

With our university, you'll learn how we make templates & how to make your own.

Explore Catalog

How-To Videos

Each template comes with a guide to use it along with how-to videos that show how it works.

Buy Now

Inside Our Family Tree Excel Template

Input family members into the Family Tree. It will display your family hierarchy and create a 'tree'

They say the apple doesn’t fall far from the tree.

While some people may resent that they are more like their parents then they ever thought, a Family Tree Diagram helps you see your family at a glance in a shareable way on Excel.

This is one of our more fun templates as most are oriented towards business and productivity, but you may also enjoy our Personal Budget or Organizational Chart template, which is the business equivalent.

Let’s dive into this template. If you’re not super familiar with Excel, this template is simple and approachable.

In the top left corner of the Family Tree Diagram sheet is a plus button. Click that and a section will open up titled Family Details. Inside the Family Details section are tables for Father’s Relatives, Mother’s Relatives, 1st Degree Family and Offspring Family. You can input fields like Name, Date of Birth and Death.

As you enter that data and assign titles, the Tree diagram will automatically populate. Under the Family Details header is a table titled Family Data. This table will auto populate as well.

Close the Family Details section and you’ll get a full view of the diagram.

Make a Family Tree in minutes with our Family Tree Maker for Excel.

Three features that make this template super awesome and simple to use: Full Screen makes the screen... goes without saying. You can also Update Family if there’s a new addition to the family or Delete Diagram if you want to start from scratch.

Last but not least, replace the placeholder image of the cartoon with a photo of your family. Only then is your diagram complete.

Making a Family Tree is a great activity for families and kids who want the benefit of seeing a visualization of their immediate heritage.

As long as it’s an .XLSM file, you can use this spreadsheet in Google Sheets and without it losing its formatting.

More Templates For Personal Use

Simple Pricing for Full Access

Unlock full access to the entire library for one low price.



(no bundle savings)

  • 45+ Customizable Excel Templates
  • One User
  • One-Time Payment

Premium + University


($699 bundle savings)

  • Full Access to Excel University ($399 bundle savings)
  • 100+ Customizable Excel Template
  • Personal Membership Portal
  • Excel, PowerPoint, & Word 101 Courses ($199 bundle savings)
  • Two Users
  • One-Time Payment



($299 bundle savings)

  • 100+ Customizable Excel Templates
  • Excel, PowerPoint & Word 101 Courses ($199 bundle savings)
  • One User
  • One-Time Payment